Re: ?? connect problem again

From: Donald Bricker <Donald.Bricker_at_epa.state.il.us>
Date: Thu, 15 Mar 2001 14:16:05 -0800
Message-ID: <F001.002CE16E.20010315122037@fatcity.com>

Is your database name different than SID name? Try sqlplus username/password_at_databasename

Don Bricker
Information Systems Analyst
Illinois Environmental Protection Agency 1021 North Grand Avenue East
Mail Code #32
Springfield, IL 62794-9276
Donald.Bricker_at_epa.state.il.us
(217) 558-2290

>>> Leslie Lu <leslie_y_lu_at_yahoo.com> 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_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.

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: 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 - 16:16:05 CST