8.1.5: setup Net8 for IPC and TCP, puzzling

From: <chrisoc_at_ans.net>
Date: Fri, 22 Oct 1999 19:16:28 GMT
Message-ID: <7uqd69$bvj$1@nnrp1.deja.com>

Sorry this is long. I have ideas from Tom Kyte's posts and Sybrand Bakker's, and wonder if maybe I am trying something that is not possible.

I'm close to a solution but it still eludes me. I am trying to make two aliases for one database instance (the real SID is DIALTEST). The first alias I want is DIALIPC, for use on the same machine as DIALTEST, to be deployed like this:

sqlplus system/manager_at_DIALIPC

and another alias, DIALTEST, that will connect over TCP either from the same box or a different one, as follows: sqlplus system/manager_at_DIALTEST

I only have one running Oracle database, DIALTEST. If I configure for TCP only, it is connectable from everyplace. I'm trying to control the access protocol by using DIALIPC to make the listener look for IPC, and DIALTEST to make it look for TCP. I'm not running ONAMES and not looking for external procs to work (yet). I want to to control my access protocol by means of which alias I use, from the same machine.

I have both aliases TNS-pingable now. But I cannot use them in the sqlplus command to get this control. Furthermore, the lsnrctl status output is not showing the TCP listener so I think I have a problem, there.

I should be seeing both TCP and ICP when I start my listener.

Here are the files and log snips. What am I doing wrong?

I have not set the global_names to True in my initdialtest.ora. It's commented out.

tnsnames.ora: DIALTEST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP ) (HOST = pebble.bd.ans.net ) (Port = 1521 ) ) ) (CONNECT_DATA = (SID = DIALTEST) (GLOBAL_NAME = DIALTEST) ) )

DIALIPC_CONNECTION_DATA=
(DESCRIPTION =

  (ADDRESS= (PROTOCOL=IPC)(KEY = DIALIPC)   )
  (CONNECT_DATA = (SID=DIALIPC)
  )
)

#TRY THIS
DIALIPC=
(DESCRIPTION =

  (ADDRESS= (PROTOCOL=IPC)(KEY = DIALIPC)   )
  (CONNECT_DATA = (SID=DIALIPC)
  (GLOBAL_NAME = DIALIPC)
  )
)

listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC) (KEY = DIALIPC))
        (ADDRESS = (PROTOCOL = TCP)(HOST = pebble.bd.ans.net)(PORT =
1521))
      )

)
)

# put a SID_DESC here for IPC as well as one for TCP # The first DESC is the TCP one

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (GLOBAL_DB_NAME = DIALTEST)
      (ORACLE_HOME = /ans2/oracle/u01/app/oracle/product/8.1.5)
      (SID_NAME = DIALTEST )

)
(SID_DESC =

      (SID_NAME = DIALIPC)
      (GLOBAL_DB_NAME = DIALTEST)
      (ORACLE_HOME = /ans2/oracle/u01/app/oracle/product/8.1.5)

)
)

from the sqlnet.ora file (thanks to Sybrand Bakker) automatic_ipc= ON
lsnrctl status shows this:

LSNRCTL for Solaris: Version 8.1.5.0.0 - Production on 22-OCT-99 18:03:52

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

Alias                     listener
Version                   TNSLSNR for Solaris: Version 8.1.5.0.0 -
Production
Start Date                22-OCT-99 16:08:34
Uptime                    0 days 1 hr. 55 min. 17 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/ans2/oracle/u01/app/oracle/product/8.1.5/network/admin/listener.ora Listener Log File
/ans2/oracle/u01/app/oracle/product/8.1.5/network/log/listener.log Services Summary...

  DIALIPC               has 1 service handler(s)
  DIALTEST              has 3 service handler(s)

my "env" has these two settings:
ORACLE_SID=dialtest
ORACLE_HOME=/ans2/oracle/u01/app/oracle/product/8.1.5

tnsping shows this:
$ tnsping dialtest

Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST=pebble.bd.ans.net)(Port=1521))
OK (20 msec)

$ tnsping dialipc

Attempting to contact (ADDRESS=(PROTOCOL=IPC)(KEY=DIALIPC)) OK (10 msec)

Now I can issue sqlplus without the "@DIAL"+something and get in, as follows:
$ sqlplus

SQL*Plus: Release 8.1.5.0.0 - Production on Fri Oct 22 18:07:29 1999

Enter user-name: system
Enter password:

Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

and the listener.log shows nothing new entered.

Using connect string "system/manager_at_DIALTEST" gives ORA-01034: ORACLE not available
and the listener.log shows:

22-OCT-99 18:11:19 *
(CONNECT_DATA=(SID=DIALTEST)(GLOBAL_NAME=DIALTEST)(CID=(PROGRAM=)(HOST=pebble
.bd.ans.net)(USER=oracle))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=147.225.48.50)(PORT=38052)) * establish *
DIALTEST *0 Using the one for DIALIPC is similar:

ERROR:
ORA-01034: ORACLE not available

and the listener log shows: 22-OCT-99 18:14:08 *
(CONNECT_DATA=(SID=DIALIPC)(GLOBAL_NAME=DIALIPC)(CID=(PROGRAM=)(HOST=pebble.b
d.ans.net)(USER=oracle))) * (ADDRESS=(PROTOCOL=ipc)(KEY=DIALIPC)) * establish * DIALIPC * 0 Maybe I am tangled up in the SID v GLOBAL_NAMEs v ALIAS distinctions.

I've lost the ability to use TCP, somehow. The setting of automatic_ipc to OFF or ON makes no difference.

Chris O'Connor

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 14:16:28 CDT