-
RMAN creating alias for catalog in tnsnames.ora
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
-
-
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 !
-
Originally Posted by Thomasps
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 like
a normal DB and it all worked out. thread can be closed
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|