SQL*Net V2. prob.

From: Anand K. Anumolu <ananda_at_mcs.net>
Date: 1996/07/09
Message-ID: <Pine.BSI.3.91.960709143023.15845A-100000_at_Mercury.mcs.com>#1/1

Hello :

We installed SQL*NET v2 on Sloaris 2.3(SUN SPARC 20). It has been really pain in the neck to deal with.

The following are steps for diagnostics:

STEP 1: checking to see if the listener is running :

drpsun1% ps -eaf | grep ora

  oracle 24499     1 71 17:15:20 ?          0:01 ora_pmon_DRP
  oracle 24502     1 80 17:15:27 ?          0:08 ora_smon_DRP
  oracle 26876     1 29 12:52:48 ?          0:00 /opt/oracle/bin/tnslsnr 
LISTENER -inherit  <----------**
  oracle 27073 27071242 14:20:55 pts/6      0:01 -csh
  oracle 24503     1 80 17:15:29 ?          0:01 ora_reco_DRP
  oracle 24500     1 80 17:15:23 ?          8:17 ora_dbwr_DRP
  oracle 27150 27073 36 14:26:41 pts/6      0:00 ps -eaf
  oracle 24501     1 80 17:15:25 ?         10:10 ora_lgwr_DRP

  oracle 24508 1 67 17:16:00 ? 0:01 orasrv  

• what in the heck is -inherit ???

STEP 2: Trying to do a loop-back on the Server:

drpsun1% sqlplusdrp/drp_at_DRP
SQL*Plus: Release 3.1.3.4.1 - Production on Tue Jul 9 14:21:46 1996

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

ERROR: ORA-12222: TNS:no such protocol adapter

Enter user-name: ^Cdrpsun1%

STEP 3: Check for installed adapters, drivers, and linkage:

drpsun1% cd
drpsun1% cd bin

drpsun1% nm oracle | grep nttini
[7865] | 791420| 124|FUNC |GLOB |0 |7 |nttini

drpsun1% strings oracle | grep nttini
_nttini

drpsun1% adapters

Installed SQL*Net V2 Protocol Adapters are:

   V2 BEQ Protocol Adapter
   V2 IPC Protocol Adapter
   V2 TCP/IP Protocol Adapter

Installed network security products are:

drpsun1% drivers
Installed SQL*Net Drivers are:

V1 Pipes
V1 TCP/IP
SQL*Net V2
drpsun1%

Well you have seen it. I wonder what drivers it is looking for???

STEP 4: My listener.ora, tnsnames.ora and sqlnet.ora files:

drpsun1% cd $ORACLE_HOME/network/admin
drpsun1% ls

help           ros            sqlnet.old     sqlnetlog.bak
resource       sqlnet.log     sqlnet.ora     tnsnames.ora

drpsun1% more sqlnet.ora
# $Header: tosnsqln.ora 2010100.1 93/08/17 20:36:19 jgraham Generic<base> $
automatic_ipc=off

drpsun1% more tnsnames.ora
# ############################
# FILE NAME: /var/opt/oracle/tnsnames.ora
# NODE: drpsun1 (SERVER)
# Created: Jun 21, 1996
# ############################

DRP=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)  (HOST=drpsun1)(PORT=1521))(CONNECT_DATA=(SID=DRP)))                                 

drpsun1% cd /var/opt/oracle
drpsun1% ls
listener.ora oratab.bak tnsnames.bak oratab sqlnet.log tnsnames.old

drpsun1% more listener.ora
listener=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=drpsun1)(PORT=1521))) SID_LIST_LISTENER=
(SID_LIST=
   (SID_DESC=

        (SID_NAME=DRP)(ORACLE_HOME=/opt/oracle)
            )
         )

drpsun1%

Pl. excuse me for posting such a detail question.

I tried my best getting some help from Oracle. Hopefully, somebody out there can answer, before Oracle can respond.

Thanx.

--Anand Received on Tue Jul 09 1996 - 00:00:00 CEST