if u are using tivoli


then the below will work for u



i was doing a database copy and change sid. upon svrmgrl, i got the below messages.

my exact error message

exec(): 0509-036 Cannot load program oracleNEW because of the following errors:
0509-150 Dependent module /oracle/OLD/lib64/libobk.a(shr.o) could not be loaded.
0509-022 Cannot load module /oracle/OLD/lib64/libobk.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
exec(): 0509-036 Cannot load program oracleNEW because of the following errors:
0509-150 Dependent module /oracle/OLD/lib64/libobk.a(shr.o) could not be loaded.
0509-022 Cannot load module /oracle/OLD/lib64/libobk.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
ORA-12547: TNS:lost contact

then found http://msgs.adsm.org/cgi-bin/get/adsm0310/751.html

what i did is to copy the file to /oracle/OLD/lib64/libok.a with permission as oraNEW

You can rename the link /usr/lib/libobk64.a to /usr/lib/libobk.a and
that should allow Oracle to easily find the library.
You can make the link $ORACLE_HOME/lib/libobk.a -> /usr/lib/libobk64.a and
then "export LD_LIBRARY_PATH=$ORACLE_HOME/lib;$LD_LIBRARY_PATH"
Or, you can make the link $ORACLE_HOME/lib/libobk.a ->
/usr/tivoli/tsm/client/oracle/bin64/libobk64.a and then "export
LD_LIBRARY_PATH=$ORACLE_HOME/lib;$LD_LIBRARY_PATH"


@rename.sql gives the below

ORA-00279: change 7747552220515 generated at 12/09/03 10:55:01 needed for thread 1
ORA-00289: suggestion : /oracle/NEW/saparch/NEWarch1_235788.dbf
ORA-00280: change 7747552220515 for thread 1 is in sequence #235788
Specify log: {=suggested | filename | AUTO | CANCEL}

i choose cancel and system gives "media recovery cancelled" . and have to wait for a long time before it started.


check my alert file

Tue Dec 9 13:13:18 2003
ORA-00202: controlfile: '/oracle/NEW/sapdata1/cntrl/cntrlNEW.dbf'
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Tue Dec 9 13:13:18 2003
ORA-205 signalled during: alter database mount...
Starting ORACLE instance (normal)

cos in my rename.trc, i have the CREATE CONTROLFILE REUSE DATABASE "OLDDB" NORESETLOGS;
this is the original setting. to recreate the DB, i need to use the keyword SET instead of REUSE



and all is fine now..