Re: SQL*Net V2. prob.

Hello,

I sympathise with your problem.

Firstly, I'd say you need to upgrade Solaris as I have had many problems with Solaris 2.3 and TCP loopbacks.

Oracle have a recorded "Vendor Bug" about this to do with the unix function GetHostByName which fails to retrieve IP addresses from the hosts file. I asked why the rest of the tcp programs like ftp, telnet etc still work and they say it's because they're never relinked after installation. Oracle advise going to 2.4 or higher.

I must say though, that the sort of errors I get are ORA-12203. As a test to see if this is the same problem, I would change all your hostnames for IP addresses. Also, include IPC addresses in your listener.ora and it will at least come up (but probably not go down).

Are you using Oracle Network Manager to configure your files ? It's recommended but very buggy. Get v3.1 not 3.0.

Hope this helps and that you've got more hair left than me.

John Butcher,

In article <Pine.BSI.3.91.960709143023.15845A-100000_at_Mercury.mcs.com>, "Anand K. Anumolu" <ananda_at_mcs.net> writes
>
>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
>
>
 

-- 
John Butcher