Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Renumbering + Snapshot + L-Class

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US