SQL*net Problems

From: Nick Metrowsky <nmetro_at_rhine.is.rice.edu>
Date: 13 Oct 94 15:15:14 CST
Message-ID: <1994Oct13.151514.1_at_rhine.is.rice.edu>

I have been trying to get SQL*net to work and I am having some problems. When I attempt a connection, I receive the message "listener failed to bequeath connection".

I have tried using the SYS, SYSTEM and NET_CONF Oracle user ids to attempt the SQL*net connection, but to no avail. I am using the correct passwords.

For example:

$ SQLPLUS SYSTEM/password_at_TEST_DATABASE

SQL*Plus: Release 3.1.3.1.1 - Production on Thu Oct 13 15:09:49 1994

ERROR: ORA-12500: TNS:listener failed to bequeath connection

Enter user-name:

I get the following in SQLNET.LOG:

Fatal OSN connect error 12500, connecting to:

 (DESCRIPTION=(CONNECT_DATA=(SID=TESTDB)(CID=(PROGRAM=)(HOST=RHINE)
 (USER=ORACLE7)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)
 (KEY=test_database))(ADDRESS=(COMMUNITY=TCPCOM)(PROTOCOL=TCP)
 (HOST=rhine.is.rice.edu)(PORT=1521))))

  VERSION INFORMATION:
	TNS for VMS: Version 2.0.15.1.0 - Production
	VMS Mailbox NT Protocol Adapter for VMS: Version 2.0.15.1.0 - Production
	Oracle Bequeath NT Protocol Adapter for VMS: Version 2.0.15.1.0 - Production
	TCP/IP NT Protocol Adapter for VMS: Version 2.0.15.1.0 - Production
	RAW NT Protocol Adapter for VMS: Version 2.0.15.1.0 - Production

  Time: 13-OCT-94 14:02:20
  Tracing not turned on.
  Tns error struct:
    nr err code: 12204

TNS-12204: TNS:received data refused from an application

ns main err code: 12564

TNS-12564: TNS:connection refused

    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0

I am running Oracle V7, SQLnet V2 and OpenVMS V6.1 on a VAX. I am trying to do a loopback conncetion. That is, I am trying to act as a client on a server system, without having to try a connection between two systems (we cannot do that at this time). I am also trying to do this via TCP/IP using TGV Multinet V3.3C.

I performed the following steps, after installing Oracle and getting a small test database created:

Looked at the [ORACLE7.NETCONFIG]README_NETCONFIGV2.DOC file
Set up the NCFW tables in the database via NCSCHEMA
Built NCFW in the correct directory.
Ran NCFW to create my configuration files. I beieve I have everything configured properly.
Copied the *.ORA files in the correct directory [ORACLE7.NETWORK.ADMIN]
Shutdown and restarted the database
Started up the listener, with no problems.
Ran the test, several times, indicated above.

Below are a copy of all the config files:

###########


# FILENAME: listener.ora

# TIME....: 94-09-30 02:19:45

# NETWORK.: ADTEST

# NODE....: RHINE.IS.RICE.EDU
# SERVICE.: LISTENER
###########
LISTENER =
(ADDRESS_LIST =

        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= TESTDB)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= TEST_DATABASE)
        )
        (ADDRESS = 
          (PROTOCOL = TCP)
          (HOST = rhine.is.rice.edu)
          (PORT = 1521)
        )

)
STARTUP_WAIT_TIME_LISTENER = i
CONNECT_TIMEOUT_LISTENER = i

LOG_DIRECTORY_LISTENER = oracle7$system:[dba_home.listener_logs]
LOG_FILE_LISTENER = listener
SID_LIST_LISTENER =

(SID_LIST =
(SID_DESC =

      (SID_NAME = TESTDB)
      (PROGRAM='ORACLE$SYSTEM:[ORACLE7.NETCONFIG]ORASRV_NETV2.COM')

)
)
TRACE_LEVEL_LISTENER = OFF

###########


# FILENAME: sqlnet.ora

# TIME....: 94-09-30 02:19:45

# NETWORK.: ADTEST

# NODE....: RHINE.IS.RICE.EDU
# SERVICE.: C_TCPCOM
###########
TRACE_LEVEL_CLIENT = OFF

###########


# FILENAME: tnsnames.ora

# TIME....: 94-09-30 02:19:45

# NETWORK.: ADTEST

# NODE....: RHINE.IS.RICE.EDU
# SERVICE.: C_TCPCOM
###########
TEST_DATABASE =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = 
          (COMMUNITY = TCPCOM)
          (PROTOCOL = TCP)
          (HOST = rhine.is.rice.edu)
          (PORT = 1521)
        )

    )
    (CONNECT_DATA =
      (SID = TESTDB)
    )
  )

###########


# FILENAME: tnsnav.ora

# TIME....: 94-09-30 02:19:45

# NETWORK.: ADTEST

# NODE....: RHINE.IS.RICE.EDU
# SERVICE.: C_TCPCOM
###########
LOCAL_COMMUNITIES =
  (COMMUNITY_LIST =
    (COMMUNITY = TCPCOM)
  )

Also, I below I have provided a copy of [ORACLE7.NETCONFIG]ORASRV_NETV2.COM:

$! NAME: orasrv_netv2.com template
$! USAGE: In (PROGRAM=...) argument in CONFIG.ORA
$! FUNCTION: Setup environment for RDBMS shadow processes and start it for
$!           SQL*Net V2.
$! MODIFIED:
$!  VGokhale   01/22/92 - Created
$!
$!
$!-------------------------------------------
$! This file serves as a template for the actual file that will be created on a 
$! per instance basis to setup environment for, and startup RDBMS shadow 
$! processes for SQL*Net V2 connections.
$!
$! Name of the actual .COM file will be specified in (PROGRAM='...') name-value 
$! pair in the SIDMAP entry in CONFIG.ORA
$!
$! Edit following line to substitute full path for the ORAUSER file for the 
$! RDBMS instance. Example:
$! 
$!  
$ _at_ORACLE7$SYSTEM:[ORACLE7.DB_V7TESTDB]ORAUSER_V7TESTDB.COM 
$!
$!
$  orasrv := $ORA_SYSTEM:SRV.EXE
$!
$! Start ORACLE server
$
$  orasrv "(LOCAL=NO)" 
$  exit
$!

The following is [ORACLE7.DB_V7TESTDB]ORAUSER_V7TESTDB.COM:

$! NAME:  ORAUSER_V7TESTDB.COM
$!
$! Created by ORA_RDBMS_CDB.COM on 23-SEP-1994 13:53:10.83
$!
$! PURPOSE:
$!    This script sets up the database-specific and instance-
$!    specific logicals necessary to access a given ORACLE instance.
$!--------------------------------------------------------------------
$!
$  define/nolog ORA_LOCAL_DATABASE V7TESTDB
$  ora_local_database == "V7TESTDB" 
$!
$!     ORA_RDBMS has to be defined for ORA_FIND_SID and ORA_FIND_NODENAME.
$!     It will be reset once ORA_UTIL:ORAUSER.COM is run later in this file.
$!
$  define/nolog/trans=concealed ORA_ROOT DRHINE$USER1:[ORACLE7_SYSTEM.ORACLE7.]
$  define/nolog ORA_RDBMS ORA_ROOT:[RDBMS]
$!
$!      If P2 is defined, assume it is the nodename.
$!
$  nodename$$ = ""
$  if ("''P2'" .nes. "") then -
       nodename$$ = p2
$!
$  if (nodename$$ .eqs. "") then goto GET_THE_NODE
$  ORA_LOCAL_NODENAME == nodename$$
$  goto QUIET_TIME
$!
$GET_THE_NODE:
$  _at_ORA_RDBMS:ORA_FIND_NODENAME
$  nodename$$ = ORA_LOCAL_NODENAME
$!
$!      Allow the SID to be defined without a DCL informational message.
$!
$QUIET_TIME:

$ quiet_sid = " "
$ if ("''P3'" .nes. "") then -

      quiet_sid = "/nolog"
$  if (quiet_sid .nes. " ") then goto GET_SID
$  if (f$length(f$trnlnm("ORA_QUIET_SID")) .ne. 0) then -
      quiet_sid = "/nolog"
$!
$!      If P1 is defined, assume it is the SID.  Verify this SID
$!  is valid and use it if so, else exit with an error.
$!

$GET_SID:
$ if ("''P1'" .nes. "") then -

goto VALIDATE_SID

$!
$!       Find the first known SID for this database on this node.
$!
$  _at_ORA_RDBMS:ORA_FIND_SID F 'nodename$$' V7TESTDB
$  if (ora_rdbms_success .eqs. "UNKNOWN") then -
      goto UNKNOWN_SID
$  define'quiet_sid' ORA_SID 'ora_rdbms_success'
$  goto AFTER_SID
$!
$!       What to do if people run this on the wrong node.
$!
$UNKNOWN_SID:

$ write sys$output " "
$ write sys$output -

" ORAUSER_V7TESTDB: This database has no known instance on" $ write sys$output -

" node (''nodename$$'). As a result ORA_SID is *undefined*, and you" $ write sys$output -

" will have to use SQL*Net if you wish to connect to any database."

$  write sys$output " "
$  goto AFTER_SID
$!
$!      Make sure the SID we were passed is valid for this node
$!      and database.
$!
$VALIDATE_SID:
$  _at_ORA_RDBMS:ORA_FIND_SID S 'nodename$$' V7TESTDB 'P1'
$  if (ora_rdbms_success .nes. "Y") then -
$     goto SID_NO_GOOD
$  define'quiet_sid' ORA_SID 'P1'
$  goto AFTER_SID
$!
$SID_NO_GOOD:
$  write sys$output " "
$  write sys$output -

" ORAUSER_V7TESTDB: The SID ''P1' is not known on database V7TESTDB" $ write sys$output -

" and node ''nodename$$'."

$  write sys$output " "
$  write sys$output "       Exiting with an error status."
$  write sys$output " "
$  exit 2
$!
$AFTER_SID:
$  define/nolog ORA_INSTANCE  DRHINE$USER1:[ORACLE7_SYSTEM.ORACLE7.db_V7TESTDB]
$  define/nolog ORA_DUMP      DRHINE$USER1:[ORACLE7_SYSTEM.ORACLE7.db_V7TESTDB.TRACE]
$!
$!       Set up database-specific logicals.
$!
$  _at_DRHINE$USER1:[ORACLE7_SYSTEM.ORACLE7.db_V7TESTDB]ora_db_V7TESTDB
$!
$  deassign ORA_CONTROL1
$  deassign ORA_CONTROL2
$  deassign ORA_PARAMS
$  deassign ORA_INITSQL
$!
$!       Set up product-specific logicals and symbols.
$!
$  _at_ORA_ROOT:[UTIL]orauser
$!
$!---------------------------------------------------------------------
$!       ADD ADDITIONAL INSTANCE-SPECIFIC (DE)ASSIGNMENTS BELOW:
$!
$  exit

Any ideas about what I may be doing wrong, would be most helpful.

Thanks.

Nick

-- 
==============================================================================
Nick Metrowsky                     | 
System Programmer                  | Internet: nmetro_at_rice.edu
Rice University                    | 
P. O. Box 1892                     | Phone: (713)285-5409  FAX: (713)527-6099
Houston, Texas 77251-1892          | 
==============================================================================

Received on Thu Oct 13 1994 - 22:15:14 CET

This message: [ Message body ]
Next message: Carlos Netto: "Performance problems with bind variables"
Previous message: Patrick Rusk: "Re: SQL question"
In reply to Jef Kennedy: "Re: Oracle/OpenVMS Performance Question"
Next in thread: Carlos Netto: "Performance problems with bind variables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message