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
Thank You in Advance
Try This entry in your listener.ora:
(SID_NAME = ORCL)
(SID_NAME = ORAL)
Don't forget to include relevant entries in your tnsnames.