By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,506 Members | 1,876 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,506 IT Pros & Developers. It's quick & easy.

How to connect with rman

P: 5
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
Share this Question
Share on Google+
9 Replies


P: 14
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

P: 3
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

P: 5
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

P: 3
can you post the result of the command "lsnrctl service"
Dec 2 '09 #5

P: 5
WHEN I ENTER
LSNRCTL>service bsnl
TNS-12541: no listener
TNS-12560: protocal error
TNS-00511: no listener
Dec 2 '09 #6

P: 5
linux error:111: connection refused
Dec 2 '09 #7

P: 3
seems there is no listener ...
create the listener and start it..
Dec 2 '09 #8

P: 5
sir how to create listener...
Dec 2 '09 #9

P: 14
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.