Conference orarep::nomahs::dbintegrator_public_public

    
    Hi Diane,
    
    I don't think the gateway itself looks for TNSNAMES.ORA, but I'll have
    to double check that.  I think it is SQL*net that looks at this file.
    
    I have no idea as to why the problem is occurring.  Are they using
    SQL*net V1 or V2 syntax?  Can you post their definition?
    
    Thanks,
    
    dan

Hi Dan,

>    I don't think the gateway itself looks for TNSNAMES.ORA, but I'll have
>    to double check that.  I think it is SQL*net that looks at this file.

Yes, I know it seems a bit odd but I just remember the ORA-06401 error
of a couple years ago where the solution was:

   Rtg/oracle on unix requires tnsnames.ora to be in /etc.  

Even when sqlplus u/p@node worked fine with tnsnames.ora in a different 
location.  

I know this is not a unix gtwy but thought they might work the same way.
I have an article written which says our gateway always looks in the same
location to keep compatible with different versions of oracle.  Else we would
need a different gtwy for each version of oracle that modifies the file
location.  Certainly if it left the lookup to sql*net, the problem of
tnsnames.ora moving to different locations between versions would not
be a problem but this has not been my understanding.

Thanks, Diane

Hi Dan,

Customer site has never had SQL*Net v1 on the system.  It has always
been SQL*Net v2.  (But it sure seems like tnsnames.ora is being ignored
doesn't it?)

At the end of this note is output from their site showing attach strings both
with and without logicals, sqlplus which works and tnsnames.  Additionally we
tried the following on Friday:

  1.  Reinstalling rtg/oracle one more time.  Same problem. 
  vmi$jwd:ldrv$oracle_shr.exe file not found.  VMSINSTAL fails.
  2.  Ran loracle$startup.com to install specially linked image sent 
  to them by us back in Feb.
  3.  Ran orauser.com.
  4.  Tried sqlplus u/p@node.  Worked fine.
  5.  attach 'f /type=oracle/u/p/node.
Situation now is a bit worse.  Error appears to be the same, it's just harder
to figure out what the error is.  Instead of getting the ORA-06030 error
they get a noname message.  Using the error code translator we got
-LDRV-E-ORA_DB_SUPP, which is what they were getting before only 
before they were also getting ora-06030.  He is missing sys$message:
ldrv_msg.exe which is where I found the error on our system here.
Is this something distributed option would install?  I wonder if they
had it before they installed rtg/oracle again but no way to confirm.
Suggested he install distributed option again as he was told in Feb
but he doesn't want to.  Says if we reinstalled rtg/oracle that installation
should not have deleted any files from any other installation, only its
own files from its own failed install.  But if ldrv_msg.exe is part
of the gtwy, then it might delete this file even if it is from a
previous installation since it would also be from this install.
He is going to try and restore the file by unwinding the dbi saveset
kits until he finds it.

Thanks, Diane
-----------------------------------------------------------
Output from customer:

The following sections are included:

1) Rdb SQL with direct  attach - no  logical
2) Show logical of ora$database
3) Show logical of ora$database
4) Using same connect string for sqlplus and it works
5) The tnsnames.ora file



1)
SQL> DISCONNECT ALLL;
SQL> ATTACH 'FILENAME/TYPE=ORACLE/USER=APPL_USER/PASSWORD=APPL_USER/
NODE=TSTF01_EDTPR';
%SQL-F-ERRATTDEC, Error attaching to database /TYPE=ORACLE/
USER=APPL_USER/PASSWORD=APPL_USER/NODE=TSTF01_EDTPR
-RDB-F-SYS_REQUEST, error from system services request
-DBI-E-ATTACHERR, Error attaching database, Connect 
string='/TYPE=ORACLE/USER=APPL_USER/PASSWORD=<password>/NODE=TSTF01_EDTPR'
-RDB-E-BAD_DB_FORMAT, /DBKEY_DEFAULT_MODE=NATIVE
/MAX_LONG_SIZE=512/NODE=TSTF01_EDTPR/NOENFORCE_ALL_TXN/PASSWORD=/TX_MODE=WARN_1PC/Ty
-LDRV-E-CANT_CONNDB, Can NOT connect to database 
/DBKEY_DEFAULT_MODE=NATIVE/MAX_LONG_SIZE=512/NODE=TSTF01_EDTPR
/NOENFORCE_ALL_TXN/PR
-LDRV-E-ORA_DB_SUPP, ORA-06030: Unable to open message file (SQL-02113).


2)
HTSH13 BURLOCKM: show log ora$database
   "ORA$DATABASE" = "/type=oracle/user=appl_user/password=appl_user
/node=tstf01_edtpr" (LNM$PROCESS_TABLE)

3)
HTSH13 BURLOCKM: sql
SQL> disconnect all;
SQL> attach 'filename ora$database';
%SQL-F-ERRATTDEC, Error attaching to database ora$database
-RDB-F-SYS_REQUEST, error from system services request
-DBI-E-ATTACHERR, Error attaching database, Connect string='/type=oracle/user=appl_user/password=<password>/node=tstf01_edtpr'
-RDB-E-BAD_DB_FORMAT, /DBKEY_DEFAULT_MODE=NATIVE/MAX_LONG_SIZE=512/NODE=tstf01_edtpr/NOENFORCE_ALL_TXN/PASSWORD=/TX_MODE=WARN_1PC/Ty
-LDRV-E-CANT_CONNDB, Can NOT connect to database /DBKEY_DEFAULT_MODE=NATIVE/MAX_LONG_SIZE=512/NODE=tstf01_edtpr/NOENFORCE_ALL_TXN/PR
-LDRV-E-ORA_DB_SUPP, ORA-06030: Unable to open message file (SQL-02113).


4)
--- using same connect string for sqlplus -----------
HTSH13 BURLOCKM: sqlplus appl_user/appl_user@tstf01_edtpr

SQL*Plus: Release 3.1.3.5.1 - Production on Fri May  2 13:27:37 1997

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


Connected to:
Oracle7 Workgroup Server Release 7.3.2.1.1 - Production Release
PL/SQL Release 2.3.2.0.0 - Production

SQL>

5)
################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world
# Date..........: 
################
hts6f01_edtpr.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcpcom.world)
          (PROTOCOL = TCP)
          (Host = 152.159.87.102)
          (Port = 1526)
        )
    )
    (CONNECT_DATA =
       (SID = EDTP)
       (GLOBAL_NAME = hts6f01_edtpr.world)
    )
  )
tstf01_edtpr.world = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcpcom.world)
          (PROTOCOL = TCP)
          (Host = 152.159.87.72)
          (Port = 1526)
        )
    )
    (CONNECT_DATA =
       (SID = EDTP)
       (GLOBAL_NAME = tstf01_edtpr.world)
    )
  )

     Hi Diane,
    
  1.  Reinstalling rtg/oracle one more time.  Same problem. 
  vmi$jwd:ldrv$oracle_shr.exe file not found.  VMSINSTAL fails.
    
    When this failed, did it leave everything else around?
    
    LDRV_MESSAGE.EXE is in save set b (vax) or c (alpha)
    

Do you know if any funky logicals or anything were defined?  Can they look
    for VIDA and ORA logicals?
    

    I really can't think of anything off the top of my head that would
    cause this problem.

Hi Dan,

>>>    When this failed, did it leave everything else around?
>>>    
>>>    LDRV_MESSAGE.EXE is in save set b (vax) or c (alpha)
    
Thanks for the pointer to ldrv_msg.exe.  Because this is in saveset
b/c this answers the question that it is part of both Dist Option and
rtg/oracle so the rtg/oracle installation failure deleted it when it
it cleaned up after itself.   This also explains why back in February
when the rtg/oracle failed at the customer site with the same error
message, they were told by us to install Distributed option to get
everything back they needed except for the image which we sent 
separately.

>>>Do you know if any funky logicals or anything were defined?  Can they look
>>>    for VIDA and ORA logicals?

I'll have them:

   1.  Reinstall Distributed Option again.
   2.  Send output of all vida* and ora* logicals

Thanks, Diane

Hi Dan,

Is it possible the image we sent to this customer back in
February and linked on one of the engineering systems here was linked
on a system with SQL*Net v1 instead of v2?  

Thanks, Diane

Here are their ora logicals.  No vida logicals.

Thanks, Diane
------------------------------------------------------------
(LNM$PROCESS_TABLE)

  "ORA$DATABASE" = "/type=oracle/user=appl_user/password=appl_user/
node=tstf01_edtpr"
  "ORA_ADALIB" = "ORA_PROGINT_"
  "ORA_ATK" = "DISK$RDB61:[ORACLE7.ORA_ROOT.NETCONFIG]"
	= "DISK$RDB61:[ORACLE7.ORA_ROOT.SQLNETATK]"
  "ORA_COM" = "ORA_COMMON"
  "ORA_COMMON" = "DISK$RDB61:[ORACLE7.ORA_ROOT.NETCONFIG.STANDA]"
	= "DISK$RDB61:[ORACLE7.ORA_ROOT.UTIL]"
  "ORA_DUMP" = "ORA_SYSTEM"
  "ORA_ERROR" = "ORA_COMMON:ERROR.MSG"
  "ORA_GUICORE_ADMIN" = "ORA_ROOT:[UTIL]"
  "ORA_INSTALL" = "ORA_ROOT:[INSTALL]"
  "ORA_MAP" = "ORA_COMMON"
  "ORA_MOD" = "ORA_PROGINT_MESG"
  "ORA_MODC" = "ORA_PROGINT_EXE"
  "ORA_MODCDEMO" = "ORA_ROOT:[PROGINT.DEMO.MODDEMO.MODCDEMO]"
  "ORA_NETCONFIG" = "ORA_ROOT:[NETCONFIG]"
  "ORA_NETCONFIG_DEMO" = "ORA_ROOT:[NETCONFIG.DEMO]"
  "ORA_NETCONFIG_FAKE" = "ORA_ROOT:[NETCONFIG.STANDA]"
  "ORA_NETWORK" = "ORA_ROOT:[NETWORK]"
  "ORA_NETWORK_ADMIN" = "ORA_ROOT:[NETWORK.NETADMIN]"
  "ORA_NETWORK_OKT" = "ORA_ROOT:[NETWORK.NETADMIN]"
  "ORA_NETWORK_TRACE" = "ORA_ROOT:[NETWORK.ADMIN.TRACE]"
  "ORA_OCIADALIB" = "DISK$RDB61:[ORACLE7.ORA_ROOT.PROGINT.OCI.]"
  "ORA_OCIADA_DEMO" = "ORA_ROOT:[PROGINT.OCI.OCIADADEMO]"
  "ORA_OCIADA_SRC" = "ORA_ROOT:[PROGINT.OCI.OCIADASRC]"
  "ORA_OLB" = "ORA_COMMON"
  "ORA_PCC" = "ORA_PROGINT_MESG"
  "ORA_PCF" = "ORA_PROGINT_EXE"
  "ORA_PCO" = "ORA_PROGINT_MESG"
  "ORA_PGO" = "ORA_PROGINT_MESG"
  "ORA_PLS" = "ORA_COMMON"
  "ORA_PRECOMP" = "ORA_PROGINT_EXE"
	= "ORA_PROGINT_INCL"
  "ORA_PRECOMP20" = "ORA_PROGINT_EXE"
	= "ORA_PROGINT_INCL"
	= "SYS$LIBRARY"
  "ORA_PRO16" = "ORA_PROGINT_MESG"
  "ORA_PROADA" = "ORA_PROGINT_EXE"
  "ORA_PROADADEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO.PROADADEMO]"
  "ORA_PROADALIB" = "DISK$RDB61:[ORACLE7.ORA_ROOT.PROGINT.EXE.]"
  "ORA_PROADA_DEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO.PROADADEMO]"
  "ORA_PROADA_SRC" = "ORA_ROOT:[PROGINT.EXE.PROADASRC]"
  "ORA_PROC" = "ORA_PROGINT_MESG"
  "ORA_PROC20" = "ORA_PROGINT_MESG"
  "ORA_PROCDEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO.PROCDEMO]"
  "ORA_PROCOB" = "ORA_PROGINT_EXE"
  "ORA_PROCOBDEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO.PROCOBDEMO]"
  "ORA_PROCORE" = "ORA_PROGINT_MESG"
  "ORA_PROFOR" = "ORA_PROGINT_EXE"
  "ORA_PROFORDEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO.PROFORDEMO]"
  "ORA_PROGINT" = "ORA_ROOT:[PROGINT]"
  "ORA_PROGINT_" = "DISK$RDB61:[ORACLE7.ORA_ROOT.PROGINT.]"
  "ORA_PROGINT_DECC_HDRS" = "ORA_ROOT:[PROGINT.INCLUDE.DECC]"
  "ORA_PROGINT_DEMO" = "ORA_ROOT:[PROGINT.DEMO]"
  "ORA_PROGINT_EXE" = "ORA_ROOT:[PROGINT.EXE]"
  "ORA_PROGINT_INCL" = "ORA_ROOT:[PROGINT.INCLUDE]"
  "ORA_PROGINT_MESG" = "ORA_ROOT:[PROGINT.MESG]"
	= "ORA_PROGINT_EXE"
  "ORA_PROGINT_MOD_DEMO" = "ORA_ROOT:[PROGINT.DEMO.MODDEMO]"
  "ORA_PROGINT_OLB" = "ORA_ROOT:[PROGINT.OLB]"
  "ORA_PROGINT_PRE_DEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO]"
  "ORA_PROGINT_SLAX" = "ORA_ROOT:[PROGINT.MESG]"
	= "ORA_PROGINT_EXE"
  "ORA_PROGINT_VMS_HDRS" = "ORA_ROOT:[PROGINT.INCLUDE.OPENVMS]"
  "ORA_PROPAS" = "ORA_PROGINT_EXE"
  "ORA_PROPASDEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO.PROPASDEMO]"
  "ORA_PROPLI" = "ORA_PROGINT_EXE"
  "ORA_PROPLIDEMO" = "ORA_ROOT:[PROGINT.DEMO.PREDEMO.PROPLIDEMO]"
  "ORA_RDBMS" = "ORA_ROOT:[NETCONFIG.STANDA]"
	= "ORA_UTIL"
  "ORA_RDBMS_DEMO" = "ORA_ROOT:[NETCONFIG.DEMO]"
  "ORA_ROOT" = "DISK$RDB61:[ORACLE7.ORA_ROOT.]"
  "ORA_ROOTDIR" = "DISK$RDB61:[ORACLE7.ORA_ROOT]"
  "ORA_SLAX" = "ORA_PROGINT_SLAX"
	= "ORA_RDBMS"
  "ORA_SQLLIB" = "ORA_ROOT:[UTIL]"
  "ORA_SQLNET" = "ORA_ROOT:[NETCONFIG]"
  "ORA_SQLNETTCP" = "ORA_ROOT:[SQLNETTCP]"
  "ORA_SQLNETTCP_DEMO" = "ORA_ROOT:[SQLNETTCP.DEMO]"
  "ORA_SQLNET_DEMO" = "ORA_ROOT:[NETCONFIG.DEMO]"
  "ORA_SQLNET_OLB" = "ORA_ROOT:[NETCONFIG]"
	= "ORA_ROOT:[SQLNETTCP]"
	= "ORA_ROOT:[SQLNETASY]"
	= "ORA_ROOT:[SQLNETDNT]"
	= "ORA_ROOT:[SQLNETATK]"
	= "ORA_ROOT:[SQLNETLU62]"
  "ORA_SQLOLB" = "ORA_UTIL"
  "ORA_SQLPLUS" = "ORA_ROOT:[SQLPLUS]"
  "ORA_SQLPLUS_DEMO" = "ORA_ROOT:[SQLPLUS.DEMO]"
  "ORA_SQLPLUS_OLB" = "ORA_ROOT:[SQLPLUS]"
  "ORA_SYSTEM" = "ORA_COMMON"
  "ORA_TCP" = "DISK$RDB61:[ORACLE7.ORA_ROOT.NETCONFIG]"
  "ORA_TK2" = "ORA_UTIL"
  "ORA_UTIL" = "ORA_ROOT:[UTIL]"

(LNM$JOB_81AF1C40)

(LNM$GROUP_001300)

(LNM$SYSTEM_TABLE)

  "ORA_NETWORK" = "SYS$COMMON:[SQLSRV.SQLNET]"

(DECW$LOGICAL_NAMES)