Re: tnsping works, SQL/Plus does not

From: Cory Phillips <cory_at_localhost.localdomain>
Date: 1 Sep 2001 05:22:15 -0600
Message-ID: <slrn9p1dtt.1iu.cory@localhost.localdomain>

When I started SQL Plus, it was unresponsive for a few minutes, then it reported "Could not resolve Service name".

ORA-12154: TNS:could not resolve service name

I searched my hard drive and found two tnsnames.ora files. I already had my connect string set up in one but not the other, so I also added it to
d:\bin\orawin95\net80\admin\tnsnames.ora

So now I have both d:\bin\orawin95\net80\admin\tnsnames.ora and d:\bin\orawin95\network\admin\tnsnames.ora. So which is it anyway? Net80 or Network?

Now when I try to run sqlplus, I get the Windows invalid page fault in an unknown module. I cannot run Net8 Assistant. I get no error messages. When I hit ctrl-alt-delete for the task manager, I see I have an instance of Java running which I must then select and click the "End Task" button to kill it. I tried to reinstall Net 8 on the client. Oracle installer reports successful installation. I try again with the same results. I cannot run Net8 Assistant nor Net8 Easy Config. I can run Net8 Easy Configuration which all it will do is set up the tnsnames.ora file.

My firewall on the server is wide open (all ports). When I do a tnsping from a DOS prompt on the client, the network logs on the server report a network connection (see below where 192.168.0.128 is the client).

   03:54:15 09/01/01 192.168.0.128                            1521

1521

My listener.log file on the server, also reports the ping connection with

01-SEP-01 03:54:15 * ping * 0

When I try SQL/Plus, there are no entries in the server network log nor the listener.log, so I know that it is not able to make a connection.

I have also tried setting up a remote connection in Oracle Navigator, but it just crashes when I try to use it. Since Net8 is trying to use Java (I guess for the connection) and it keeps hanging and leaves Java running in the task manager, I guess I will attempt to troubleshoot it from there. Here is my PATH environment on the client. PATH D:\bin\ORAWIN95\bin;"%PATH%";D:\bin\orawin95\jre11\bin

I have also tried to test an ODBC connection. I set the connection up then used "Oracle ODBC Test". It causes the program to crash.

I have reinstalled Net8 and the ODBC drivers serveral times. It sill does not help.

Here is the listener startup output.

Starting /usr/oracle/u01/app/oracle/product/8.0.5/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 8.0.5.0.0 - Production System parameter file is
/usr/oracle/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/usr/oracle/u01/app/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=MYDB))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=127.0.0.1)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=MYDB)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.0.5.0.0 - Production
Start Date                01-SEP-01 03:16:43
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /usr/oracle/u01/app/oracle/
   product/8.0.5/network/admin/listener.ora
Listener Log File         /usr/oracle/u01/app/oracle/product/8.0.5/net

work/log/listener.log
Services Summary...

  MYDB          has 1 service handler(s)
  extproc               has 1 service handler(s)

The command completed successfully

Here is the tail of my listener.log file. TNSLSNR for Linux: Version 8.0.5.0.0 - Production on 01-SEP-01 03:15:11

System parameter file is
/usr/oracle/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/usr/oracle/u01/app/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=5)(KEY=MYDB))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=8)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=9)(HOST=127.0.0.1)(PORT=1521))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE TNSLSNR for Linux: Version 8.0.5.0.0 - Production on 01-SEP-01 03:16:42

System parameter file is
/usr/oracle/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/usr/oracle/u01/app/oracle/product/8.0.5/network/log/listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=MYDB))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on:

(ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=127.0.0.1)(PORT=1521)) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 01-SEP-01 03:16:43 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost. localdomain)(USER=oracle))(COMMAND=status) (ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=134238208)) * status * 0
01-SEP-01 03:54:15 * ping * 0
01-SEP-01 05:06:53 * ping * 0

-- 
Cory Phillips
cory_h_phillips_at_yahoo.com

Received on Sat Sep 01 2001 - 06:22:15 CDT