problem in login using local naming (tnsnames.ora) [message #520898] |
Thu, 25 August 2011 06:21 |
abhi_shakya
Messages: 50 Registered: September 2009 Location: Nepal
|
Member |
|
|
I can login to my database using
SQL>sqlplus sys/sys as sysdba
but it doesnot work when i do
SQL>sqlplus sys/sys@nocdb as sysdba
ERROR:
ORA-12518: TNS:listener could not hand off client connection
my tnsnames.ora looks like this
NOCDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Abhishek-PC)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = nocdb)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
error log in my listener log file looks like this
25-AUG-2011 16:59:20 * (CONNECT_DATA=(SERVICE_NAME=nocdb)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ABHISHEK-PC)(USER=Abhishek))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.248)(PORT=54460)) * establish * nocdb * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
is this (PORT=54460) causing the problems...i think it should read 1522 as in my listener.ora
please help
|
|
|
|