Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ?? connect problem again
Hi,
Thank you for solving my off network connection problem. Now I have another problem.
If set SID, then sqlplus user/pwd, works fine; but sqlplus user/pwd_at_SID doesn't work, error: ora 12154, TNS: could not resolve service name.
Testing connection using Easy Config, works fine. Listener started and ORCL has 3 handlers.
This is how the tnsnames.ora looks:
ORCL.JONESCYBER.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
EXTPROC_CONNECTION_DATA.JONESCYBER.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Any suggestion? Thanks a lot.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: leslie_y_lu_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Mar 15 2001 - 13:49:14 CST
![]() |
![]() |