connection problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: connection problem

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    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

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    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
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    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
  •  



Click Here to Expand Forum to Full Width