Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
The Db name mentioned above were just examples. The actual db names are in tns file below. The details as as below:
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
Version TNSLSNR for 64-bit Windows: Version 22.214.171.124.0 - Production
Start Date 20-JAN-2011 10:16:27
Uptime 4 days 5 hr. 5 min. 37 sec
Trace Level off
Security ON: Local OS Authentication
Listener Parameter File C:\ORA\dbadmin\product\11.2.0\GISDEV\NETWORK\ADMIN\listener.ora
Listener Log File c:\ora\dbadmin\diag\tnslsnr\PDFPGISORDEV\listener_gisdev\alert\log.xml
Listening Endpoints Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "giszgg" has 1 instance(s).
Instance "gisdev", status READY, has 2 handler(s) for this service...
Service "orad2" has 1 instance(s).
Instance "orad2", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
Can anyone let me know why I am not able to connect both the servers at a time?
The issue was I have created giszgg cloned db from orad2. GISZGG and GISDEV are on same server. gisdev was up and running when I did clone and now all the trace files and alert log is getting created by gisdev suffix. Help me out to get solution on this so that GISZGG and GISDEV can run independantly?
according to me you cannot have two listeners listening to same port at a time,so i would suggest to separate out the listener ,create a new listener.ora assign new port(say 1529) set local_listener parameter.You should be all set
This does mean that we only have one listener for all our DBs, if you want one listener per DB then I guess you would need similiar to above but with something like SID_LIST_LISTENER1 and then SID_LIST_LISTENER2. Each with their single SID_LIST and SID_DESC section.
Is that of any help?
With the tnsnames.ora file we have our SIDs listed, all with the same port.
1) I can have two listeners on same port that 1521 (Verified after testing).
Both the listener are up and running.
2) The issue was as below and it's strange:
Windows 2008R2 has new interface like commandprompt and it is windows power shell. I was setting ORACLE_SID first and was logging into the database. But "ENVIRNMENT CANNOT BE SET IN THIS WINDOWS POWER SHELL". Then I did it from normal windows command prompt and it could set the env veriables to logg into the proper db.