Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12203, but I can do a tnsping

Re: ORA-12203, but I can do a tnsping

From: <ejsanchez_at_gmail.com>
Date: 29 Nov 2004 16:01:22 -0800
Message-ID: <1101772190.533693.251580@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US