Skip to Content
0
Former Member
Dec 06, 2008 at 09:23 AM

Error in DB_ACTION_LOWQ2 phase in Shadow import

25 Views

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

  1. 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).

  1. 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