-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|