Printable View
Is there a tool I can use that can create an entry for me in the tnsnames.ora for a catalog db.
for example: I want to use this type of syntax:
rman TARGET SYS/oracle@trgt CATALOG rman/cat@catdb
How do I create the catdb alais or can somebody provide me with an
example of what it looks like so I can plug it into my tnsnames.ora file
and edit it accordingly.
I am using oracle 10.2 on Solaris is that makes a difference.
Thanks to all who answer this post
Documentation is great for this...Configuring the tnsnames.ora File After Installation and General Syntax of tnsnames.ora.
Thanks for the documentation but after reviewing it I could not find what i needed.
Can somebody please provide me with an example of what has to go
in the tnsnames.ora so I can reference the RMAN catalog!!!
In addition, I am guessing I need to put something in the listener.ora file
too so something can listen to that connection. If somebody can give me
an example of that too it would be great
Please keep in mind I am trying to setup RMAN manually for the first time manually and I have no references to copy from.
Thanks to all who answer
Paul, configure the Oracle TNS entry (put all "something" into $ORACLE_HOME/network/admin/tnsnames.ora file so that thru sqlplus, you should be able to connect to the RMAN catalog DB) such way that sqlplus rman/rman@catdb should work. Once connection is successful, then try,
rman TARGET SYS/oracle@trgt CATALOG rman/cat@catdb
Good luck to you and your company specially !
I got it all working thanks to all who answered!! I just treated this likeQuote:
Originally Posted by Thomasps
a normal DB and it all worked out. thread can be closed