Document ID:	  37725.1
Subject:          DBSTART and DBSHUT do not work with Oracle 7.3
Last Modified:    31 Mar 96 
Author:           EWELLS


Problem: 
~~~~~~~~ 
  With Server release 7.3 'SQLDBA' has been obsoleted and is no longer 
  shipped.  The scripts 'dbstart' and 'dbshut' used to start and stop  
  instances on a machine will no longer work as they rely on 'sqldba'. 

  Users custom scripts which interface to SQLDBA will also fail.
 
Workaround: 
~~~~~~~~~~~
  The replacement for 'sqldba', Server Manager, can be used in line mode 
  to start and stop instances. E.G: 
   
	% svrmgrl 
 
	Oracle Server Manager Release 2.3.2.0.0 - Production 
 
	Copyright (c) Oracle Corporation 1994, 1995. All rights reserved. 
 
	Oracle7 Server Release 7.3.2.0.0 - Production Release 
	With the distributed, replication and parallel query options 
	PL/SQL Release 2.3.2.0.0 - Production 
 
	SVRMGR> connect internal 
	Connected. 
	SVRMGR> shutdown 
	Database closed. 
	Database dismounted. 
	ORACLE instance shut down. 
	SVRMGR> exit 
	Server Manager complete. 
	% 
 
  Use the following Bourne shell script to provide an interface to Server 
  Manager for the 'dbstart' and 'dbshut' commands: 
 
	: 
	########################################## 
	# This script is provided to support the # 
	# 'dbstart' & 'dbshut' commands only.    # 
	########################################## 
	if [ $# = 1 ] && [ $1 = "command=exit" ] ; then 
	    echo 'SQL\*DBA: Release 7.X.X.0.0 - Support Version \c' 
	    date 
	    echo 'Copyright (c) Oracle Corporation 1996.  All rights reserved.' 
	    exit 0 
	else 
	#   Add LD_LIBRARY_PATH to work round other problems. 
	    LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH 
	    export LD_LIBRARY_PATH 
	    exec $ORACLE_HOME/bin/svrmgrl $@ 
	fi 
 
  Save the script as '$ORACLE_HOME/bin/sqldba' and add execute permission.   

Additional Information:
~~~~~~~~~~~~~~~~~~~~~~~
  For full details of the Server Manager refer to: 
 
  "Oracle Server Manager User's Guide , Release 2.1"	Part No. A30887-1 
  "Oracle Server Manager Release 2.3.2 Addendum"	Part No. A42570-1 
  "SQL*DBA to Oracle Server Manager Migration Guide."	Part No. A42573-1