Conference orarep::nomahs::dbintegrator_public_public

    
>What about:
    
>   1. How does he answer the rtg/oracle installation question of "where 
>       is orauser.com?"
    
    If the user installs the Oracle client software then orauser.com should
    end up getting put down (client software I think will include SQL*plus
    and SQL*net
    
>   2. rtg/oracle automatically links on site to create LDRV$ORACLE_SHR.EXE.
>       How does this happen if no oracle libraries are on the vms
>       system?

    If there are no libraries then no link will happen.
    
>I convinced him to install both SQL*Net AND SQL*Plus on the vms system so
>he could do the test SQLPLUS USERNAME/PASS@NODE before trying our gtwy.
>Will installing sql*net and/or sqlplus be enough to install orauser.com
>on the vms system and will the necessary libraries be installed so that 
>rtg/oracle can successfully link?

I think so, but make the and/or above an and.
    
    dan

Hi Dan,

#>I convinced him to install both SQL*Net AND SQL*Plus on the vms system so
#>he could do the test SQLPLUS USERNAME/PASS@NODE before trying our gtwy.
#>Will installing sql*net and/or sqlplus be enough to install orauser.com
#>on the vms system and will the necessary libraries be installed so that 
#>rtg/oracle can successfully link?
#
#I think so, but make the and/or above an and.

This didn't work.  Customer installed sql*net and sqlplus from an
oracle 7.1.5 system.  Also did:
   sqlplus user/pass@node  
and this worked fine.

Now installed rtg/oracle v7 and it fails linking the image.  Says he
nees oracle7 installed on his system.  I told him he didn't need it, just
the oracle client software.  He wants to know what is the oracle client
sw called?  If he doesn't hear from me in the next couple of hours,
they are planning to install oracle7 on the system. 

In the install guide, pg5-1, it mentions that you need oracle rdbms but
doesn't say it needs to be on the client system.  Also makes no mention
of oracle client software.

Thanks, Diane

    
    Hi Diane,
    
    So the ORAUSER.COM didn't end up on the system?  If it did and they got
    a link error could you post the error?  We seem to often get hit by the
    habit of Oracle changing the location of the Oracle libraries we link
    against.
    
    If there are libraries that can't be found in their regular location it
    might help if the user searches the Oracle directory structure (same if
    the orauser.com didn't end up where expected.
    
    Thanks,
    
    Dan

Hi Dan,

There was no problem with orauser.com.  The installation procedure asks
for the location of this file and they entered the location of the file and
the install proceeded.  The problem occurred when the ldrv* image was
being linked.  It said they needed oracle on their system.  They are faxing
me a copy of the error message sometime this afternoon.  I'll post as
a reply after receiving.

QUESTIONS:

1.  What is the name of the Oracle client software that rtg/oracle users
are supposed to install?  I have 2 customers asking me now.  No one has
heard of it.  Or do we mean, install sql*net and sqlplus?

2.  Customer referred to in base note decided to install Oracle rdbms
yesterday and now gateway works.  However, this was a development system.
They want to install the gateway on their production system in another week.  
They are not happy with the workaround which was to install Oracle RDBMS and
would like to know what else they need to install besides sql*net and
sqlplus.  I know this is an unfair question until I'm able to post the
link error message but just indicating that we need to know what is
meant by installing Oracle client software.

3.  Today I found the following STARS article.  This appears to indicate
that all that is needed is sql*net and that we will send linked images.
Do we have engineering's blessing on this or should we tell customers
to install sql*net AND sqlplus as indicated in 1160.1 and/or the oracle
client software and remove this article (or make it noncustomer-viewable).
If the article is correct, then it would seem that this entire note
1160 is moot.  Just install sql*net and if it doesn't work we'll send
an image.

Thanks, Diane
-----------------------------------------
TITLE: Installing Rdb Gateway for Oracle on a Node with Only SQL*Net Installed

PRODUCT:  Oracle Rdb V6.1

OP/SYS:   OpenVMS VAX V5.5 and higher

SOURCE:   Oracle Worldwide Customer Support


SYMPTOM:

You have a node that you wish to install the Oracle Gateway on.  This node
does not have Oracle7, nor SQL*Plus installed, but you do have SQL*Net 
installed.  The installation of the Rdb Transparent Gateway for Oracle
failes trying to find the LDRV$ORACLE_SHR.EXE file in the VMS Install 
"working directory".

RESPONSE:

This has been reported to engineering.


WORKAROUND:

Install the Database Integrator first.  If you are installing V7.0 of the 
Gateway, then choose option 3 off the installation menu instead of option 6.
Choose NO for the question regarding using an Oracle Catalog manager.
When that installation completes, you have all the files needed for the Oracle 
Gateway except for LDRV$ORACLE_SHR.EXE.  Call your support representative and 
this file will be sent to you.  Place this file in SYS$LIBRARY: and the Rdb 
Transparent Gateway for Oracle will function properly.

Hi Dan,

Here is their log file of the installation.  I found note 1117 which 
referred to a problem linking using rtg/gtwy 3.1A and Oracle 7.1.5 but
it was fixed in v7.  The current customer is using 7.1.5 and rtg/oracle v7.

Thanks, Diane
---------------------------------------------------------------------------

Welcome to CSL001, AlphaServer 2100 4/275, OpenVMS Alpha (TM) V6.2-1H3

Username: SYSTEM
Password:             
      Welcome to the ALC Lab Cluster 
      OpenVMS Alpha (TM) Operating System, Version 6.2-1H3
      Last interactive login on Tuesday, 29-APR-1997 11:42:31.88
      Last non-interactive login on Tuesday, 29-APR-1997 10:59:38.20
      You have 20 new Mail messages.

CSL001/SYSTEM> CD
 SYS$SYSROOT:[SYSMGR]  =   SYS$SYSROOT:[SYSMGR]  =   SYS$COMMON:[SYSMGR]

CSL001/SYSTEM> SET DEF SYS$UPDATE
CSL001/SYSTEM> @VMSINSTAL DBI070 DKA600:[DISTRIBUTED_PROD.KIT]

OpenVMS AXP Software Product Installation Procedure V6.2-1H3 
 It is 29-APR-1997 at 11:46.

Enter a question mark (?) at any time for help.
%VMSINSTAL-W-ACTIVE, The following processes are still active:
     RSM$BKPSCAN       
     DECevent_CSL001       
     SQLSRV$SERVER       
     DECW$TE_0258       
     DEV_DEFECTSRV1       
     DEV_DEFECTSRV2       
     DEV_DEFECTSRV3  
     DEV_INSERTSRV       
     _FTA3:       
     TST_DEFECTSRV1       
     TST_DEFECTSRV2       
     TST_DEFECTSRV3       
     TST_INSERTSRV      
     _FTA4:       
     _RTA3:       
     SERVER_0076       
     SERVER_0075       
     AICS_DEV_USR

* Do you want to continue anyway [NO]? YES
* Are you satisfied with the backup of your system disk [YES]? 

The following products will be processed:  DBI V7.0	

Beginning installation of DBI V7.0 at 11:46
%VMSINSTAL-I-RESTORE, Restoring product save set A ...%VMSINSTAL-I-RELMOVED, 
Product's release notes have been moved to SYS$HELP.        
*****************************************************************       
Copyright � Oracle Corporation 1996.  All Rights Reserved.        
*****************************************************************       
Rdb Distributed Suite for OpenVMS AXP V7.0-00 installation procedure.       

The Rdb Distributed Product Suite Install Guide has been copied to SYS$HELP.

*      Would you like to print the Rdb Distributed Product Suite Install 
       Guide [NO]?     

*******************************************************************	
Select from the following list of products to be installed and enter your 
selection(s) as a comma-separated list of numbers.   

1) Rdb Parallel Query Option for OpenVMS AXP V7.0-00   
2) Rdb Distributed Option for OpenVMS AXP V7.0-00 
3) DataBase Integrator for OpenVMS AXP V7.0-00   
4) Visual Schema Builder   
5) Rdb Transparent Gateway for DB2 for OpenVMS AXP V7.0-00   
6) Rdb Transparent Gateway for Oracle for OpenVMS AXP V7.0-00  
7) Rdb Transparent Gateway for SYBASE for OpenVMS AXP V7.0-00   
8) Rdb Transparent Gateway for PC Data for OpenVMS AXP V7.0-00   
9) Exit the installation procedure

*      Kits to install: 2,6

You have selected the following kits to be installed:   
2) Rdb Distributed Option for OpenVMS AXP V7.0-00   
6) Rdb Transparent Gateway for Oracle for OpenVMS AXP V7.0-00

*       Is this correct  [Yes]? 

%DBI-I-CHECK_SYS_REQ,   Checking system requirements...    
Input for installation of DataBase Integrator for OpenVMS AXP V7.0-00    
DECdtm shows either no log file or a log file that has not    
been used since the system was last rebooted.  The Rdb Parallel     
Query Option, the Rdb Distributed Option, and/or DB Integrator    
will not run if DECdtm is not running on your system.  If you     
have followed the instructions in the Installation Guide then    
these products can run.

* Do you want to proceed with the installation  [NO]? YES
* Do you want to run the IVP after the installation [YES]?    

Input for installation of Rdb Transparent Gateway for Oracle for OpenVMS AXP
V7.0-00.  Please enter the name and location of the Oracle user  command
procedure.    For example, ORA_ROOT:[UTIL]ORAUSER.COM. It will be necessary to
invoke this command procedure in order to  define   logical names pointing to
the Oracle libraries. These libraries are required in order to link the Rdb
Transparent Gateway for Oracle driver.    If you are unsure of the name and
location of this command  procedure    ask your ORACLE database administrator
(DBA) or ORACLE SQL*Net installer.Enter name and location of the Oracle user
command procedure

* Enter the name of the ORACLE user command file: 
  SYS$SYSDEVICE:[ORACLE7.UTIL]ORAUSER.COM
* Would you like the Oracle Gateway to be installed read-only? [NO]? 
* Do you want to purge files replaced by this installation [YES]? 

  **************************************************************
 There are no more questions.  The installation and IVP take between   
12 and 45 minutes depending on processor type and machine load.
    **************************************************************
   **************************************************************   
Installing Rdb Distributed Suite for OpenVMS AXP V7.0-00    under 
OpenVMS V6.2-1H3- 29-APR-1997 11:47    
**************************************************************
%VMSINSTAL-I-RESTORE, Restoring product save set C ...
%VMSINSTAL-I-RESTORE, Restoring product save set G ...   
**************************************************************  
Adding DBI help to the DCL help library
 **************************************************************
    **************************************************************
   DBI$STARTUP.COM has been placed in SYS$STARTUP.  The following
   line should be placed in your system startup file.   

     $ @SYS$STARTUP:DBI$STARTUP.COM     

**************************************************************   
The IVP has been placed in SYS$COMMON:[SYSTEST].  You may run this 
procedure separately at any time.  To execute it, type:

     $ @SYS$COMMON:[SYSTEST]DBI$IVP  

 **************************************************************
%TPU-S-FILEIN, 59 lines read from file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LDRV$ORACLE_LINK_V7_AXP.OPT;1
%TPU-S-FILEIN, 8 lines read from file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LORA$EDIT_OPT.DAT;1%TPU
-S-FILEOUT, 59 lines written to file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LDRV$ORACLE_LINK_V7_AXP.OPT;2

%DBI-I-LNKGWYSHR, linking LDRV$ORACLE_SHR gateway shareable image...
  You must have Oracle V7 or above to install the gateway for Oracle

%TPU-S-FILEIN, 33 lines read from file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LORA$STARTUP.COM;1
%TPU-S-FILEIN, 4 lines read from file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LORA$EDIT.DAT;1
%TPU-S-FILEOUT, 33 lines written to file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LORA$STARTUP.COM;2
%TPU-S-FILEIN, 52 lines read from file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LDRV$ORACLE_LINK.COM;1
%TPU-S-FILEIN, 4 lines read from file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LORA$EDIT_LINK.DAT;1
%TPU-S-FILEOUT, 52 lines written to file 
$1$DKA0:[SYS0.SYSUPD.DBI070]LDRV$ORACLE_LINK.COM;2

%VMSINSTAL-W-NOFILE, File VMI$KWD:LDRV$ORACLE_SHR.EXE  does not exist.
%DBI-F-INSTALL_FAILED, Error encountered during installation while providing
 LDRV$ORACLE_SHR image

%VMSINSTAL-E-INSFAIL, The installation of DBI V7.0 has failed.    
Adding history entry in VMI$ROOT:[SYSUPD]VMSINSTAL.HISTORY	
VMSINSTAL procedure done at 11:49

CSL001/SYSTEM> 
 SYSTEM       logged out at 29-APR-1997 11:50:28.56

    
    Hi Diane,
    
    I believe only SQL*net is needed, but as you know we've had trouble
    understanding what exactly a customer gets with SQL*net license (not
    only do file locations change but the contents of the kit changes too).
    
    I looked at the error message and it comes at this section of our
    installation procedure:
    
    From file LDRV$ORACLE_LINK_V7.COM:
    
$ ! GET ORACLE VERSION NUMBER
$ !
$ @ora_install:ora_prdctl VERSION RDBMS CURRENT
$ ver = f$extract(0,1,rdbmsver$$)
$ if ((ver .eqs. "") .or. (ver .eqs. "6"))
$ then
$	write sys$output -
	"You must have Oracle V7 or above to install the gateway for Oracle"
$	goto EXIT
$ endif
$ !
$ if (ver .eqs. "7") then ver = "V7"
$ if (ver .eqs. "8")
$ then
$	write sys$output "This product has not been tested with Oracle V8"
$	write sys$output "You may get unpredictable results"
$	ver = "V8"
$ endif

    You might want to suggest they edit this part out and put ver = "V7"
    in the code, then file a bug report.  It could be that we are checking
    for a value wrong in the installation procedure.
    
    Sorry for the problems,
    
    Dan

    Is it possible that the user doing the install didn't run ORAUSER.COM
    and that the logical wasn't defined?
    
    Don

    
    Hi,
    
    According to my read of the installation procedure we would error out
    much sonner in the installation process is there was no orauser.com or
    if it didn't get invoked.
    
    Dan

Hi Dan,

Thanks.  I'll tell them to try editing this file.  Since this comes
before the actual link part, I suspect they will still have problems
linking (see 1160.4 article).  So my plan of action is to tell them
the following.  Can you give me your feedback?

Production system:
-----------------
1.  Install SQL*Net
2.  Modify ldrv$oracle_link_v7.com as noted in .6
3.  If still not working, continue:
4.  Install Distributed Option and not rtg/oracle
5.  Copy linked image from development system to production system
(Unless a different platform.  If a different platform, call us and we'll
send a specially linked image.)
6.  If still not working, continue:
7.  Install SQLPLUS and do sqlplus u/p@node
8.  If still not working, continue:
9.  Install Oracle7

Thanks, Diane

    
    Hi Diane.
    
    Are no files being left on their system when the gateway link fails?
    If only the link fails and they still get all their files then you can
    just copy the image I hope.  Installing the distributed option only
    won't get them the startup and shutdown command procedures for the
    oracle gateway (i'm not sure what else might be missing).  Also,
    installing the distributed option will get them catalog manager files
    which they don't need.  ...and if they do, don't have them choose the
    oracle catalog manager or the same problem will hold true.
    
    Dan

Hi Dan,

The ldrv_msg.exe file was missing after the rtg/oracle installation but  the
lora$startup and shutdown files were there.  We thought possibly these
startup/shutdown files were left over from the 3.1 install.  Regardless of
which kit they came from (3.1 or 7.0) the only differences between 3.1 and 7.0
are the removed references to "DEC" so the files work the same way.
So I can't really answer the question "were any files left after the
installation" but they seem to have all the necessary files - except
that it doesn't work! :)

Bug 489585.

Thanks, Diane