Can i add another port in my listener.ora file for the listener to listen to a different database on the same box ?
For eg. my current port id is 1521 (oracle default) . Apart from this, can i add another port no say 1600 so that another database can listen to it ?
OS - Solaris 2.8 and Oracle 8.1.7. ? Assuming all hardware is setup.
Or is it a vague question ..??
I am not sure I understood very well your question.
Anyway, you can define to listener (with 2 different prots) & use the first for a DB1 and the second for DB2.
Hope this helps
Yes u can add another port in listener.ora file to listen to another database.But make sure u start that listner.
thanx all. noor - you've sure got it the way i wanted.
It is a little outdated, but there is a list on this web site that tells the port numbers used by certain software.
Choose the port numbers option on the sidebar menu.
OCP DBA 8i, 9i, 10g
Thanks for the URL...
For Oracle Listeners, usually : 1521, 1523, 1525, 1527, 1529 are used ...
Click Here to Expand Forum to Full Width