Hi,
I have 2 oracle instances.
The first one, from the command prompt, I connect using sql plus no issue.
I can connect using syntax : sqlplus xxx/xxxx or sqlplus xxx/xxx@xxx for the default instance and it connects.
But for the second instance :sqlplus xxx/xxxx@xxxx , it just hangs, nothing happens.
I have to set the oracle_sid to point to the second instance, then I can connect. But then I wont be able to connect to the first instance, unless I point
the oracle_sid back.
My lsnrctl seem to be working fine, the listener log shows nothing, tnsping work as well for both instances.
This is the first time I am experiencing this. I have even deleted the second instance and created a second new instance but with the same issue.
Anyone can tell me know could be the issue with this?
Thanks in advance.