Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12203, but I can do a tnsping
OK, I ended making the listener from scratch.
Here it is how it look now the listener.ora file:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.42)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
) ) )
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = gnumar)
(ORACLE_HOME = /u01/oracle/product/8.1.7)
(SID_NAME = numar)
)
)
for some reason I didn't have the sid_list_listener part..
thanks for all your responses.
regards,
-eduardo s.m.
Received on Mon Nov 29 2004 - 18:01:22 CST