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