Re: Problems with SQLNET V2 on a VAX

mreagan_at_fast.net wrote:

{Let the cutting begin}

>> ORACLE>sqlplus system/manager_at_csistest
>>
>> SQL*Plus: Release 3.1.3.1.3 - Production on Mon Jul 31 16:59:08 1995
>>
>> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>>
>> ERROR: ORA-12500: TNS:listener failed to start a dedicated

{End}

Looks to me like you may have a problem (as we did) with the Oracle startup command file that is used when running SQL*Net. As you probably know, there's a reference in the LISTENER.ORA file to a command procedure...

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = JUNK)
      (PROGRAM='DKA200:[ORACLE7.DB_JUNK]ORASRV_NETV2.COM')

ORASRV_NETV2.COM should look like the following (depending on your version of Oracle, the command file may or may not be correct - the following one is correct).

$ _at_dka200:[oracle7.db_junk]orauser_junk
$ _at_dka200:[oracle7.rdbms]rdbmsuser.com
$!
$!
$  orasrv := $ORA_SYSTEM:SRV.EXE
$!
$! Start ORACLE server
$
$  orasrv "(LOCAL=NO)" 
$  exit

Hope this helps. If you need any more help, please Email me as we're running UCX 3.2 on a 3000/300, Open VMS 6.1 & Oracle 7.1.3. Received on Thu Aug 03 1995 - 00:00:00 CEST