472,351 Members | 1,581 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,351 software developers and data experts.

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 11309
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

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

Similar topics

3
by: sunilwarrier | last post by:
I found a few documents on this topic, but didn't resolve my issue. I am trying to restore an RMAN backup to a different host (with a differnet...
1
by: steve | last post by:
Hi, I am using the java database manager on oracle 9i linux , to monitor and modify my oracle 9i system. there is a wizard that allows the...
1
by: RYAN | last post by:
Hi All, I am new to Oracle and I have some question that I hope that someone out there can help me. I have heard the Oracle Rman can do...
2
by: Tho Nguyen | last post by:
Hi, folks! I am new to RMAN and now trying to configure it. There is one issue concerning me. Let's say I backup the target database every 6:PM...
0
by: TX-DBA | last post by:
#####Background 1) CRONJOB runs 2 RMAN shell scripts at 3AM backup_begin.sh- export and rman backups report_begin.sh- list rman reports My...
2
by: Alex | last post by:
Hi all Is possible with RMAN recover only one table of my db? Where can i find some infromation about this? If is not possible , where can i...
0
by: rmli | last post by:
Duplicating a Database using RMAN http://quickdba.blogspot.com/2006/05/duplicating-database-using-rman_22.html
0
by: gohel | last post by:
I have cofigured rman on linux with oracle 9i (catdb) as revecory catalog db and target db is on win XP with oracle 9i in archive log mode , Now...
0
by: gunsbong | last post by:
hello again everybody.. i just copied the backup file from production to another server with the same config with the production...when i restore...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.