Renumbering + Snapshot + L-Class

From: Thomas Sielaff AS/HEN3 58/E/23 #44451 <Thomas.Sielaff_at_alcatel.de>
Date: Fri, 19 Oct 2001 11:00:17 +0200
Message-ID: <3BCFEBA1.4FF112BF@alcatel.de>

Hallo Wolfgang,
folgende files sind geaendert:
Renumbering Server:
slsg0i:/home/oracle/renumber_2/renumbering.sql slsg0i:/opt/DINOS_DB/app/oracle/admin/number/pfile/initnumber.ora P.S.: renumber_sql.pkg ist Source und soll nicht ausgeliefert werden.

Snapshot-IF:

sls560:/home/oracle/mbt/renumber_if.sql
sls560:/home/oracle/mbt/renumber_if2.sql
sls560:/home/oracle/mbt/renum_snap.pkg
sls560:/home/oracle/mbt/renum_snap_sql.pkg  # Source !!! nicht zur Auslieferung !!!

P.S.: nat_num.sql ist Source und soll nicht ausgeliefert werden.

---

Zur Info:

Vor Ort in CVS:

L-Class
IP-Address: 172.26.204.158

AeØnderungen:

/opt/DINOS_AP 7GB eingerichtet, nicht gespiegelt (OS ist gespiegelt)
/opt/DINOS_DB 36GB eingerichtet, nicht gespiegelt

groups:
dba 1002
ednsdm 1006
nead 1020
netis 1005

users:

oracle          1003    :dba
ergonom         1400    :ednsdm
nead            1500    :nead
netis           1300    :netis

passwords:
root st....
oracle oracle..
sys st....
system st....

Kernel-Modifizierung:
General OLTP/Database-Server

maxssize        8M -> 16M
maxssize_64     8M -> 16M
maxdsize       64M ->256M
shmseg          32 -> 128
shmmni         512 ->1024

/etc/hosts: alias dinos eingetragen
/sbin/init.d/dino_rn -Script fÏuer system startup/shutdown
/sbin/rc3.d/S995dinos_renumbering
/sbin/rc2.d/K095dinos_renumbering

Thomas

-- 
                            '''''
                           ( o o )
+---------------------.oooO--(_)--Oooo.------------------------------+
| Thomas Sielaff                    mailto:thomas.sielaff_at_alcatel.de |
| Alcatel Telecom                          Phone:  +49 711 821 44451 |
| Network Application Division             Fax:    +49 711 821 47336 |
| Department MS/E0B     .oooO              Mailbox: Alcatel SEL AG   |
| 58/E/19               (   )   Oooo.               Lorenzstrasse 10 |
|                        \ (    (   )               D-70435 Stuttgart|
+-------------------------\_)----) /---------------------------------+
                                (_/


#!/sbin/sh
#
# @(#) $Revision: 82.1 $
#
# NOTE:    This script is not configurable!  Any changes made to this
#          script will be overwritten when you upgrade to the next
#          release of HP-UX.
#
# WARNING: Changing this script in any way may lead to a system that
#          is unbootable.  Do not modify this script.

#
# <Insert comment about your script here>
#

# Allowed exit values:
#	0 = success; causes "OK" to show up in checklist.
#	1 = failure; causes "FAIL" to show up in checklist.
#	2 = skip; causes "N/A" to show up in the checklist.
#           Use this value if execution of this script is overridden
#	    by the use of a control variable, or if this script is not
#	    appropriate to execute for some other reason.
#       3 = reboot; causes the system to be rebooted after execution.
#	4 = background; causes "BG" to show up in the checklist.
#           Use this value if this script starts a process in background mode.

# Input and output:
#	stdin is redirected from /dev/null
#
#	stdout and stderr are redirected to the /etc/rc.log file
#	during checklist mode, or to the console in raw mode.

PATH=/usr/sbin:/usr/bin:/sbin
export PATH

# NOTE: If your script executes in run state 0 or state 1, then /usr might
#	not be available.  Do not attempt to access commands or files in
#	/usr unless your script executes in run state 2 or greater.  Other
#	file systems typically not mounted until run state 2 include /var
#	and /opt.

rval=0

# Check the exit value of a command run by this script.  If non-zero, the
# exit code is echoed to the log file and the return value of this script
# is set to indicate failure.

set_return() {
	x=$?
	if [ $x -ne 0 ]; then
		echo "EXIT CODE: $x"
		rval=1	# script FAILed
	fi
}

# Kill the named process(es).
# $1=<search pattern for your process>

killproc() {
	pid=`ps -el | awk '( ($NF ~ /'"$1"'/) && ($4 != mypid) && ($5 != mypid)  ){ print $4 }' mypid=$$ `
	if [ "X$pid" != "X" ]; then
		if kill "$pid"; then
			echo "$1 stopped"
		else
			rval=1
			echo "Unable to stop $1"
		fi
	fi
}


case $1 in
'start_msg')
	# Emit a _short_ message relating to running this script with
	# the "start" argument; this message appears as part of the checklist.
	echo "Starting the dinos and renumbering subsystem"
	;;

'stop_msg')
	# Emit a _short_ message relating to running this script with
	# the "stop" argument; this message appears as part of the checklist.
	echo "Stopping the dinos and renumbering subsystem"
	;;

'start')

	# source the system configuration variables
	if [ -f /etc/rc.config ] ; then
		. /etc/rc.config
	else
		echo "ERROR: /etc/rc.config defaults file MISSING"
	fi

	# Check to see if this script is allowed to run...
#	if [ "$CONTROL_VARIABLE" != 1 ]; then
#		rval=2
#	else

	# Execute the commands to start your subsystem
	/opt/DINOS_DB/NEAD/bin/dinos_db_ctrl.sh -start
	/opt/DINOS_AP/NEAD/bin/dinos_ap_ctrl.sh -start
        su - oracle -c "export ORACLE_SID=number; svrmgrl << EOF
connect internal;
startup;
EOF" 
        /opt/DINOS_AP/RenumServer/apache_1.3.20/bin/apachectl start
#	fi
	;;

'stop')
	# source the system configuration variables
	if [ -f /etc/rc.config ] ; then
		. /etc/rc.config
	else
		echo "ERROR: /etc/rc.config defaults file MISSING"
	fi

	# Check to see if this script is allowed to run...
#	if [ "$CONTROL_VARIABLE" != 1 ]; then
#		rval=2
#	else
        /opt/DINOS_AP/NEAD/bin/dinos_ap_ctrl.sh -stop
        /opt/DINOS_DB/NEAD/bin/dinos_db_ctrl.sh -stop
        /opt/DINOS_AP/RenumServer/apache_1.3.20/bin/apachectl stop
	su - oracle -c "export ORACLE_SID=number; svrmgrl << EOF
connect internal;
shutdown immediate;
EOF"

	# Execute the commands to stop your subsystem

#	fi
	;;

*)
	echo "usage: $0 {start|stop|start_msg|stop_msg}"
	rval=1
	;;
esac

exit $rval

Received on Fri Oct 19 2001 - 04:00:17 CDT