Configuring Multiple Databases
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Configuring Multiple Databases

  1. #1
    Join Date
    Aug 2000
    Posts
    33
    Hi,

    Can anyone point out How to configure the listener.ora , in the same server having more than one databeses. I have two databases and sid is ORCL and ORAL respectively. Iam able to connect to ORCL but not to ORAL. ORAL database is
    running fine.

    Thank You in Advance
    Ravi

  2. #2
    Join Date
    Jul 2000
    Posts
    53
    Try This entry in your listener.ora:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME= ORCL)
    (ORACLE_HOME= /opt/app/oracle/product/7.3.4)
    (SID_NAME = ORCL)
    )
    (SID_DESC =
    (GLOBAL_DBNAME= ORAL)
    (ORACLE_HOME= /opt/app/oracle/product/7.3.4)
    (SID_NAME = ORAL)
    )
    )

    Don't forget to include relevant entries in your tnsnames.


    Steve

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