Hi
I am getting the following error when I ran the DB_ACTION_LOWQ2 phase
Our database is oracle 10g
UPGRADE/SHDIM: START OF PHASE DB_ACTION_LOWQ2
ERROR: SQL error (1) in LOWERQ.XQL - check TPSQLSTD.OUT and LOWERQ.LOG
Phase DB_ACTION_LOWQ2:
ERROR: No connect due to DbSl Load Lib Failure
ERROR: The values set for DIR_LIBRARY ('/usr/sap/DE1/SYS/exe/run') or dbms_type ('ORA') are invalid.
ERROR: Connect to DE1 failed (20081205230943).
Phase DB_ACTION_LOWQ2:
ERROR: No connect due to DbSl Load Lib Failure
ERROR: The values set for DIR_LIBRARY ('/usr/sap/DE1/SYS/exe/run') or dbms_type ('ORA') are invalid.
ERROR: Connect to DE1 failed (20081205232905).
Log
TPSQLSTD.OUT
BLOCKED SIGNALS: ''
SAPup> Starting subprocess 10966 at 20081206001946
ENV <0x900e9c>: auth_shadow_upgrade=0
ENV <0xffbffb82>: PATH=/oracle/DE1/102_64/bin:.:/home/de1adm:/usr/sap/put/exe:/usr/sap/DE1/SYS/exe/run:/usr/bin:/usr/ccs/bin:/usr/ucb
ENV <0x907584>: DIR_LIBRARY=/usr/sap/DE1/SYS/exe/run
ENV <0x907984>: LD_LIBRARY_PATH=/usr/sap/DE1/SYS/exe/run:/usr/jdk/instances/jdk1.5.0/jre/lib/sparc/server:/usr/jdk/instances/jdk1.5.0/jre/lib/sparc:/usr/jdk/instances/jdk1.5.0/jre/../lib/sparc:/usr/sap/DE1/SYS/exe/run:/oracle/DE1/102_64/lib:/usr/sap/put/exe
ENV <0xffbffde4>: dbms_type=ORA
ENV <0xffbffdf2>: dbs_ora_tnsname=DE1
ENV <0x90129c>: dbs_ora_schema=SAPR3
ENV <0xffbffe1b>: ORACLE_PSRV=DE1
ENV <0xffbffe2b>: ORACLE_SID=DE1
ENV <0xffbffe45>: ORACLE_HOME=/oracle/DE1/102_64
ENV <0xffbffe64>: ORACLE_BASE=/oracle
ENV <0xffbffe78>: ORA_NLS33=/oracle/DE1/102_64/nls/data
ENV <0xffbffe9e>: NLS_LANG=AMERICAN_AMERICA.WE8DEC
EXECUTING /usr/sap/DE1/SYS/exe/run/tp (tp) pf=/usr/sap/put/bin/DEFAULT.TPP execdbscript DE1 -x LOWERQ.XQL
This is /usr/sap/DE1/SYS/exe/run/tp version 305.13.25 (release 46D) for ANY database
ERROR: No connect due to DbSl Load Lib Failure
ERROR: The values set for DIR_LIBRARY ('/usr/sap/DE1/SYS/exe/run') or dbms_type ('ORA') are invalid.
ERROR: Connect to DE1 failed (20081206001946).
Warning: unknown parameter WITH_TACOB in parameter file (line 19).
Warning: unknown parameter WITH_TACOB in parameter file (line 19).
Connect to DE1 failed (20081206001946).
TRACE-INFO: 1: [developertra,00000] Sat Dec 6 00:19:46 2008 616 0.000616
TRACE-INFO: 2: [developertra,00000] db_con_init called 28 0.000644
TRACE-INFO: 3: [dlux.c ,00000] *** ERROR => DlLoadLib: ld.so.1: tp: fatal: libclntsh.so.9.0: open failed: No such file or directory -> DLENOACCESS (0,Error 0)
TRACE-INFO: 4: 2974 0.003618
TRACE-INFO: 5: [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/DE1/SYS/exe/run/dboraslib.so'
TRACE-INFO: 6: 44 0.003662
tp returncode summary:
TOOLS: Highest return code of single steps was: 0
ERRORS: Highest tp internal error was: 0249
tp finished with return code: 249
meaning:
connect failed due to DbSL load lib failure
Process with ID 10966 terminated with status 249
I guess there is some problem with environment variables, our database is ORA and DIR_LIBRARY is set to the correct point.
Is there anything to be added in the env
Thank you