Pavan DBA wrote:Well, not necessarily. By default, the instance will register with a listener on port 1521, if there is one. OP is not running his listener on port 1521, but on port 1523. So before attempting to register, OP must
also connect to testnew database as sysdba and issue below command
alter system register; - this will register listener information with listener.
alter system set local_listener='--myip---:1523';
993797 wrote:Having read this entire thread up to this point, let me address a few misconceptions you have.
Oracle Version : 11G
Database SIDs : test and testnew
Listener name: LISTENER
Port number: 1521
Net Services name: TEST and TESTNEW
I opened ./netca and I was able to test the service TEST successfully. But when i try to test the service TESTNEW, i get the error
ORA-03135: Connection Lost
How do i solve this.
Iam new to Database handling. Please help me...
Thanks in advance.