|
#!/bin/ksh if (( $# != 4 )) then print "USAGE : $0 OLDSID NEWSID oldsid newsid" else useradd -G dba -d /oracle/$2 -m -s /usr/bin/csh -c 'Oracle Administrator for $2' ora$4 useradd -G dba,sapsys,mem -d /usr/users/$4adm -m -s /usr/bin/csh -c 'SAP $2 Administrator' $4adm su - $3adm -c stopsap su - $3adm -c 'lsnrctl stop' su - $3adm -c 'saposcol -k' cd umount -a mkdir /usr/sap/$2 mkdir /sapmnt/$2 renamefset sapdomain1 $1 $2 renamefset sapdomain1 ora_$1 ora_$2 cp /etc/fstab /etc/fstab.$2 sed "s/$1/$2/g" /etc/fstab.$2 > /etc/fstab rm /etc/fstab.$2 mount -a cd /usr/sap/$2/SYS rm profile global ln -s /sapmnt/$2/global . ln -s /sapmnt/$2/profile . cd exe rm dbg run ln -s /sapmnt/$2/exe dbg ln -s dbg run chown -R $4adm:sapsys /usr/sap/$2 chown -R $4adm:sapsys /sapmnt/$2 chown -R ora$4:dba /oracle/$2 cp /usr/users/$3adm/* /usr/users/$4adm cp /usr/users/$3adm/.* /usr/users/$4adm cp /usr/users/$3adm/.*.* /usr/users/$4adm chown -R $4adm:sapsys /usr/users/$4adm chown root:system /sapmnt/$2/exe/saposcol cd /usr/users/$4adm sed "s/$1/$2/g" .login > .login.$2 cp .login.$2 .login rm .login.$2 sed "s/$1/$2/g" .profile > .profile.$2 cp .profile.$2 .profile rm .profile.$2 sed "s/$1/$2/g" .cshrc > .cshrc.$2 cp .cshrc.$2 .cshrc rm .cshrc.$2 sed "s/$1/$2/g" .kshrc > .kshrc.$2 cp .kshrc.$2 .kshrc rm .kshrc.$2 sed "s/$1/$2/g" .dbenv_restore.csh > .dbenv_restore.csh.$2 cp .dbenv_restore.csh.$2 .dbenv_restore.csh rm .dbenv_restore.csh.$2 sed "s/$1/$2/g" .dbenv_restore.sh > .dbenv_restore.sh.$2 cp .dbenv_restore.sh.$2 .dbenv_restore.sh rm .dbenv_restore.sh.$2 cd /sapmnt/$2/profile sed "s/$1/$2/g" $1_DVEBMGS05_restore > $2_DVEBMGS05_restore sed "s/$1/$2/g" DEFAULT.PFL > DEFAULT.PFL.$2 cp DEFAULT.PFL.$2 DEFAULT.PFL rm DEFAULT.PFL.$2 sed "s/$1/$2/g" START_DVEBMGS05_restore > START_DVEBMGS05_restore.$2 cp START_DVEBMGS05_restore.$2 START_DVEBMGS05_restore rm START_DVEBMGS05_restore.$2 cd /usr/sap/trans sed "s/$1/$2/g" tnsnames.ora > tnsnames.$2 cp tnsnames.$2 tnsnames.ora rm tnsnames.$2 cd /etc sed "s/$1/$2/g" listener.ora > listener.$2 cp listener.$2 listener.ora rm listener.$2 cd /oracle/$2 sed "s/$1/$2/g" .cshrc > .cshrc.$2 cp .cshrc.$2 .cshrc rm .cshrc.$2 sed "s/$1/$2/g" .dbenv.csh > .dbenv.csh.$2 cp .dbenv.csh.$2 .dbenv.csh rm .dbenv.csh.$2 sed "s/$1/$2/g" .dbenv_restore.csh > .dbenv_restore.csh.$2 cp .dbenv_restore.csh.$2 .dbenv_restore.csh rm .dbenv_restore.csh.$2 cd /oracle/$2/dbs sed "s/$1/$2/g" init$1.ora > init$2.ora sed "s/$1/$2/g" init$1.dba > init$2.dba sed "s/$1/$2/g" init$1.sap > init$2.sap cd /oracle/$2/sapreorg sed "s/$1/$2/g" struct$1.log > struct$2.log cd /oracle/$2 sed "s/$1/$2/g" control$1.sql > control$2.sql chown ora$4 control$2.sql chmod 755 control$2.sql su - ora$4 -c 'svrmgrl < control$2.sql' rm /tmp/o su - $4adm -c startsap fi |
This page was last updated on 08/23/98. |