Change SID Sript

 

Home
Up

 

#!/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

 

Change Oracle SIDSAP Basis Hint

This page was last updated on 08/23/98.

iexplore.gif    iexplore.gif (14871 bytes)