RDBPROD: Copying Configuration File From One Version to the Next Prevents Multiversion Function (Doc ID 553383.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1 and later
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

Upgrading from SQL/Services 7.2 to SQL/Services 7.3 (or 7.1 to 7.2 or 7.3) with the intention of running both versions at the same time, alternate ports must be used.  In many instances, it is ideal to have the same dispatchers and services in both versions.  It is perceived that the easiest way to acquire a configuration identical from the old version to the new version would be to copy the configuration file from one directory to the new directory.  Ports in the copied file would then be changed to be unique from the older version.

However, after carefully ensuring all ports are unique, it is not possible to get both the old version and the new version running at the same time.  

After starting the first monitor, for example 7.3 using:

$ @sys$startup:sqlsrv$startup73

starting the 7.2 monitor fails with the following errors in the monitor log file:

---EVENT BEG: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.950 2008---
%SQLSRV-I-EVENT_LOG, event logged at line 1039 in file SQS_MON.C;1
%SQLSRV-I-CFILE_OPENED, Configuration file has been opened successfully
---EVENT END: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.960 2008---

---EVENT BEG: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.960 2008---
%SQLSRV-I-EVENT_LOG, event logged at line 1699 in file SQS_MON.C;1
%SQLSRV-I-READ_SRVR, Read definition of server SQLSRV_72 from the configuration file
---EVENT END: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.960 2008---

$$ Shmem Trace init: LNM=SQLSRV_SHMEM_TRACE_ENABLED_MON, Value=0, Tue Feb 12 08:30:02.960 2008 ***
$$ Mutex Trace init: LNM=SQLSRV_SHMEM_TRACE_ENABLED_MON, Value=0, Tue Feb 12 08:30:02.960 2008 ***
---EVENT BEG: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.970 2008---
%SQLSRV-I-EVENT_LOG, event logged at line 708 in file EVT.C;1
%SQLSRV-E-FLOBCREATERR, Error on system service call
%SYSTEM-W-NOTQUEUED, request not queued
---EVENT END: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.970 2008---

---EVENT BEG: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.970 2008---
%SQLSRV-I-EVENT_LOG, event logged at line 1522 in file SQS_MON.C;1
MON ServiceMain: Unexpected Exception 'DBS_SYSERVICEFAILED' raised
---EVENT END: EVENT_LOG ------------------------ Tue Feb 12 08:30:02.970 2008---

%DBS-F-BUGCHECK: bugcheck dump will be written to SYS$SYSROOT:[SYSMGR]SQS_NODE_SQLSRV_72.DMP;2
%NONAME-F-NOMSG, Message number 0731C26C 
USER job terminated at 12-FEB-2008 08:30:03.16

Changes

A new version of SQL/Services is installed and the OpenVMS copy command is used to copy the old configuration file to a new configuration file.

$ copy SYS$SYSROOT:[SYSMGR]SQLSRV_CONFIG_FILE72.DAT -
       SYS$SYSROOT:[SYSMGR]SQLSRV_CONFIG_FILE73.DAT

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms