How to connect with rman

[mdfaraz]

SIR AS IAM USING ORACLE 10G RELEASE 2 IN RED HAT LINUX AS4,
AS I CREATED ONE DATABASE NAMED AS <BSNL>..AND THE DEFAULT DATABASE IS ORCL.
I ALREADY SET BSNL IN TNSNAMES.ORA AND ALSO IN LISTENER.ORA.
PLZ TEL ME VERY STARTING PROCEDURE TO CONNET TO RMAN.
IF IAM ENTERING AS
$rman
iam getting as cant open target database...
please help me.

[jsmithstl]

make sure your environment is setup correctly.

set your ORACLE_SID to the database you wish to connect to:

export ORACLE_SID=BSNL

rman
connect target /

[prabukrishnan]

Check
1. whether you are able to tnsping the target DB
2,if yes check you are able to login using sql plus

[mdfaraz]

Rman

HELLO,
I HAVE TWO DATABASE NAMED AS
1.AIRTEL
2.BSNL
BOTH ARE IN ARCHIVE LOG MODE
AT LISTENER I ENTERED THIS
-----------------------------------------------------------------------------------------------------
SID_LIST_LISTEN ER=
(SID_LIST=
(SID_DESC=
(SID_NAME= bsnl)
(ORACLE_HOME=/opt/oracle)

)
(SID_DESC=
(SID_NAME= airtel)
(ORACLE_HOME=/opt/oracle)

)
)
Listener =
(DESCRIPTION_LI ST=
(DESCRIPTION =
(Address= (Protocol= TCP) (Host = localhost.local domain)(Port= 1521))
)
)
--------------------------------------------------------------------------------------------------
AT CLIENT
-------------------------------------------------------------------------------------------------------

bsnl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (Protocol = TCP)(Host=local host.localdomai n)(Port = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME= bsnl)
))
airtel =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (Protocol = TCP)(Host=local host.localdomai n)(Port = 1521))

(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME= airtel)
)
)
............... ............... ............... ............... ............... ............... ....
when iam entering $tnsping bsnl
its throughing an error TNS:12533 : TNS :ILLEGAL ADDRESS PARAMETRES

PLEASE CHECK THE ABOVE ONE

[prabukrishnan]

can you post the result of the command "lsnrctl service"

[mdfaraz]

WHEN I ENTER
LSNRCTL>service bsnl
TNS-12541: no listener
TNS-12560: protocal error
TNS-00511: no listener

[mdfaraz]

linux error:111: connection refused

[prabukrishnan]

seems there is no listener ...
create the listener and start it..

[mdfaraz]

sir how to create listener...

[jsmithstl]

Once you put the entries in your lsnrctl.ora file, did you stop and restart the listener?

lsnrctl stop
lsnrctl start

Once you've restarted the listener, do as Prabukrishnan suggested. Run the following from the command line and paste the output in here.

lsnrctl services

Also, can you paste the contents of your sqlnet.ora file as well?