Is your database name different than SID name? Try sqlplus
username/password@databasename
Don Bricker
Information Systems Analyst
Illinois Environmental Protection Agency
1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
[EMAIL PROTECTED]
(217) 558-2290
>>> Leslie Lu <[EMAIL PROTECTED]> 03/15/01 01:16PM >>>
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@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.
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices.
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3105.105" name=GENERATOR></HEAD>
<BODY style="FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
<DIV><FONT size=1>Is your database name different than SID name? Try sqlplus
username/password@databasename</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=1>Don Bricker<BR>Information Systems Analyst<BR>Illinois
Environmental Protection Agency<BR>1021 North Grand Avenue East<BR>Mail Code
#32<BR>Springfield, IL 62794-9276<BR><A
href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A><BR>(217)
558-2290</FONT><BR><BR>>>> Leslie Lu <[EMAIL PROTECTED]>
03/15/01 01:16PM >>><BR>Hi,<BR><BR>Thank you for solving my off network
connection<BR>problem. Now I have another problem.<BR><BR>If set SID, then
sqlplus user/pwd, works fine; but<BR>sqlplus user/pwd@SID doesn't work, error:
ora 12154,<BR>TNS: could not resolve service name. <BR><BR>Testing
connection using Easy Config, works fine. <BR>Listener started and ORCL has 3
handlers.<BR><BR>This is how the tnsnames.ora looks:<BR>ORCL.JONESCYBER.COM
=<BR> (DESCRIPTION =<BR> (ADDRESS_LIST
=<BR> (ADDRESS = (PROTOCOL = TCP)(HOST =
demo)(PORT =<BR>1521))<BR> )<BR>
(CONNECT_DATA =<BR> (SERVICE_NAME =
ORCL)<BR> )<BR>
)<BR><BR>EXTPROC_CONNECTION_DATA.JONESCYBER.COM =<BR> (DESCRIPTION
=<BR> (ADDRESS_LIST =<BR>
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))<BR>
)<BR> (CONNECT_DATA =<BR> (SID =
PLSExtProc)<BR> (PRESENTATION =
RO)<BR> )<BR> )<BR><BR>Any suggestion? Thanks a
lot.<BR><BR><BR>__________________________________________________<BR>Do You
Yahoo!?<BR>Yahoo! Auctions - Buy the things you want at great prices.<BR><A
href="http://auctions.yahoo.com/">http://auctions.yahoo.com/</A><BR>--
<BR>Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com</A><BR>-- <BR>Author: Leslie
Lu<BR> INET: [EMAIL PROTECTED]<BR><BR>Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San
Diego, California -- Public Internet
access / Mailing
Lists<BR>--------------------------------------------------------------------<BR>To
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in<BR>the message
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list
you want to be removed from). You may<BR>also send the HELP command for
other information (like subscribing).<BR></DIV></BODY></HTML>
