-
connection problem
Hi,
i just installed a Oracle 8.1.7 on AIX 4.x.
When i try to execute sqlplus system/manager@link i hve following problem.
0509-150 libobk.a (shr ) can not be loaded.
when i try from client it's work.
bensmail
-
Re: connection problem
Hi,
Check out the setting for $LIBPATH environmental variable to $ORACLE_HOME/lib to get the current dynamic linked libraries and make sure the ORACLE_HOME is set correctly. Try relinking after
verifying the above. And have you tried "relink all" (did you check $ORACLE_HOME/install/make.log)
Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
oracle-support@indiatimes.com
-
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..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|