You need Net8 client on this server.
>From: Ken Janusz <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Connect Problem
>Date: Tue, 30 Oct 2001 12:20:21 -0800
>
>I am trying to connect to
I am trying to connect to an Oracle server. I don't have a database on this
server. Do I need a database to connect to the server via SQL*Plus?
Thanks,
Ken
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET: [EMAIL PROTECTED]
Fat City Network Service
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 <[E
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
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 st