Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

SAP is down. R3trans -d not connecting the DB after upgrade

|| 4

SAP is down. R3trans -d not connecting the DB after upgrade
Stechies

We have upgraded our system from ORA 9/ECC 5.0 to ORA 10g/ECC 6.0 The upgrade went successfully we were able to login and run transactions. I increased some work processes in RZ10 and took a re-start. Now after the re-start, DB is opening but SAP is not coming up.  Below is the list of activities and their results, which I have performed

=========================================================================================

I upgraded the kernel to latest version

=========================================================================================
R3trans -d returns the following

This is R3trans version 6.14 (release 700 - 03.11.09 - 14:15:00). 2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SRD/SYS/exe/run') or dbms_type ('ORA')" R3trans finished (0012).

=========================================================================================
trans.log of R3trans -x 4

ETW000 R3trans version 6.14 (release 700 - 03.11.09 - 14:15:00). 4 ETW000 4 ETW000 4 ETW000 date&time : 21.02.2010 - 11:25:14 4 ETW000 control file: 4 ETW000 R3trans was called as follows: R3trans -d 4 ETW000 trace at level 2 opened for a given file pointer 4 ETW000 [dev trc ,00000] Sun Feb 21 11:25:14 2010 90 0.000090 4 ETW000 [dev trc ,00000] db_con_init called 14 0.000104 4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 40 0.000144 4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/SRD/SYS/exe/run/dboraslib.o' ... 26 0.000170 4 ETW000 [dlux.c ,00000] *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/SRD/SYS/exe/run/dboraslib.o") FAILED 4 ETW000 " 0509-022 Cannot load module /usr/sap/SRD/SYS/exe/run/dboraslib.o. 4 ETW000 0509-150 Dependent module libclntsh.a(shr.o) could not be loaded. 4 ETW000 0509-022 Cannot load module libclntsh.a(shr.o). 1742 0.001912 4 ETW000 0509-026 Syste" (errno=2,No such file or directory) 4 ETW000 [dbcon.c ,00000] *** ERROR => Couldn't load library '/usr/sap/SRD/SYS/exe/run/dboraslib.o' 4 ETW000 73 0.001985 2EETW169 no connect possible: "maybe someone set invalid values for DIR_LIBRARY ('/usr/sap/SRD/SYS/exe/run') or dbms_type ('ORA')"

===========================================================================================

Results of startsap r3

Checking SRD Database ------------------------------ ABAP Database is not available via R3trans Starting SAP-Collector Daemon ------------------------------
*********************************************************************** *

This is Saposcol Version COLL 20.95 700 - AIX v11.65 5L-64 bit 090118 * Usage: saposcol -l: Start OS Collector * saposcol -k: Stop OS Collector * saposcol -d: OS Collector Dialog Mode * saposcol -s: OS Collector Status * The OS Collector (PID 467068) is already running ..... ************************************************************************

saposcol already running ABAP Database SRD must be started first ===========================================================================================

Results of lsnrctl start

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on21-FEB-2010 11:50:54 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /oracle/SRD/102_64/bin/tnslsnr: please wait... TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production System parameter file is /oracle/SRD/102_64/network/admin/listener.ora Log messages written to /oracle/SRD/102_64/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SRD.WORLD))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SRD))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gpisaps2)(PORT=1527))) Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SRD.WORLD)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production Start Date 21-FEB-2010 11:50:54 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Parameter File /oracle/SRD/102_64/network/admin/listener.ora Listener Log File /oracle/SRD/102_64/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SRD.WORLD))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SRD))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gpisaps2)(PORT=1527))) Services Summary... Service "SRD" has 1 instance(s). Instance "SRD", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully


Comments

  • Shalesh Singh Visen
    22 Feb 2010 2:57 pm
    Please login in OS by SIDADM and run command df-g and chek the files system, may be any one of fule system is 100% full , if any one is 100% full then run command chfs - k=+2G /filesystem name wich increase 2 GB space
  • Shalesh Singh Visen
    22 Feb 2010 2:57 pm
    Please check the env variables DIR_LIBRARY or dbms_type for orasid ?
  • Shalesh Singh Visen
    23 Feb 2010 3:04 am
    Please start oracle instance directly from SQL prompt. Might be issue with Oracle itself. If its successfully started then test connection from user adm. You can also verify oracle library which is complaining in your error log. You can also verify oracle client environment variables. Please verify NLS_LANG for sure.. whether you are using appropriate Oracle client or not.Here are some more parameters you can verify.
    dbms_type=
    dbs_ora_tnsname=
    dbs_ora_schema=
    ORACLE_SID=
    DB_SID=
    ORACLE_BASE=
    ORACLE_HOME=
    NLS_LANG=

    Hope this will help. If still did'nt work then please upload Trans.log file. There could be issue with port or services. You can analyse this log for root cause.
  • 24 Feb 2010 5:32 am
    yes i agree with shailendra you shul check the enviornment variable directory

Advertisement
Advertisement
Advertisement