-
I have two database in my Test Server. Iam unable to configure using neteasy config for the second database. For the first database it was configured successfully. When I tried for the second database, it giving invalid sid in the listener.ora. How can I make change in the LIstener.ora for the second database.
First database sid is ORCL
Second one is ORAL.
Thanks in Advance
Ravi
-
Edit the listener.ora would be the fastest and easiest way, just find the incorrect SID_NAME entry and change it to ORAL
-
If I change the SID as ORAL , then what will happen to ORCL sid. ?
I have to connect to both the database in the same machine. In that ORCL and ORAL are the respective SID's.
In my Listener.ora entry for ORCL is there and it is getting connected. But no entry for ORAL. How to make entry for ORAL in the same Listener.ora file ?
Thanks
Ravi
-
A listener can serve various instances,
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY=orcl))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= kerrigan)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME= /oracle)
(SID_NAME = orcl)
)
(SID_DESC =
(ORACLE_HOME = /oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /oracle)
(SID_NAME = exp)
)
)
for instance this listener.ora is serving for 3 instances
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
|