RMAN creating alias for catalog in tnsnames.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: RMAN creating alias for catalog in tnsnames.ora

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    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

  2. #2
    Join Date
    Apr 2006
    Posts
    377

  3. #3
    Join Date
    Feb 2009
    Posts
    91
    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

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    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 !
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Feb 2009
    Posts
    91
    Quote Originally Posted by Thomasps View Post
    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
  •  



Click Here to Expand Forum to Full Width