never mind -- ?? connect problem again

From: Leslie Lu <leslie_y_lu_at_yahoo.com>
Date: Thu, 15 Mar 2001 15:06:57 -0800
Message-ID: <F001.002CE4DC.20010315143623@fatcity.com>

I deleted .JONESCYBER.COM from tnsnames.ora, and it works!

Now tnsname.ora looks like:
> ORCL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT
> =
> 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = ORCL)
> )
> )

• Leslie Lu <leslie_y_lu_at_yahoo.com> wrote:
  > 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/
  >
  

  ---

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.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 - 17:06:57 CST