Renumbering + Snapshot + L-Class

Renumbering + Snapshot + L-Class

Post by Thomas Sielaff AS/HEN3 58/E/23 #4445 » Sat, 20 Oct 2001 18:00:17



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.siel...@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|
+-------------------------\_)----) /---------------------------------+
                                (_/

[ dino_rn 3K ]
#!/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

 
 
 

1. Help please creating own class Snapshot...

Hi all,

I use ACCESS database, and often recordsets (snapshots). I need to create my own class
(snapshot).

How may I access to fields like we can do with recordsets : MySnap.MyField or better :
MySnap("MyFieldName") ?

I imagine it would be possible to do it, if it's possible to create new properties at
runtime. Perhaps other ways ????

Regards.

Christian Hugoud

2. reading bytes from a long

3. Cannot resolve collation conflict for %ls operation.????

4. Retrieving Access foreign key info via ADOX

5. snapshot agent error: Another snapshot agent for the publication is running

6. Read SQL SERVER DB?

7. Snapshot won't run due to existing snapshot

8. Linked Server to Excel

9. Snapshot Replicaiton: periodic initial snapshot not yet available

10. Problem: rerun snapshot because current snapshot files are obsolete

11. %ls

12. Snapshot.base.tar.gz vs Snapshot.tar.gz

13. Printing Forms (in need of LS Paper 32bit)