469,350 Members | 1,830 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,350 developers. It's quick & easy.

How to connect with rman

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.
Nov 26 '09 #1
9 11157
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 /
Nov 28 '09 #2
Check
1. whether you are able to tnsping the target DB
2,if yes check you are able to login using sql plus
Dec 1 '09 #3
HELLO,
I HAVE TWO DATABASE NAMED AS
1.AIRTEL
2.BSNL
BOTH ARE IN ARCHIVE LOG MODE
AT LISTENER I ENTERED THIS
-----------------------------------------------------------------------------------------------------
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME= bsnl)
(ORACLE_HOME=/opt/oracle)

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

)
)
Listener =
(DESCRIPTION_LIST=
(DESCRIPTION =
(Address= (Protocol= TCP) (Host = localhost.localdomain)(Port= 1521))
)
)
--------------------------------------------------------------------------------------------------
AT CLIENT
-------------------------------------------------------------------------------------------------------

bsnl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (Protocol = TCP)(Host=localhost.localdomain)(Port = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME= bsnl)
))
airtel =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (Protocol = TCP)(Host=localhost.localdomain)(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
Dec 2 '09 #4
can you post the result of the command "lsnrctl service"
Dec 2 '09 #5
WHEN I ENTER
LSNRCTL>service bsnl
TNS-12541: no listener
TNS-12560: protocal error
TNS-00511: no listener
Dec 2 '09 #6
linux error:111: connection refused
Dec 2 '09 #7
seems there is no listener ...
create the listener and start it..
Dec 2 '09 #8
sir how to create listener...
Dec 2 '09 #9
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?
Dec 2 '09 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by sunilwarrier | last post: by
1 post views Thread by steve | last post: by
1 post views Thread by RYAN | last post: by
2 posts views Thread by Tho Nguyen | last post: by
reply views Thread by TX-DBA | last post: by
2 posts views Thread by Alex | last post: by
reply views Thread by gohel | last post: by
reply views Thread by gunsbong | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.