Hi all,
I have applied the SAP kernal patch (SAPEXE_2364-20003061.SAR). After that i can't start my SAP server.
My SAP Version :46C
DB : Oracle 9.2.0.5
OS : Solaris 8
I have enclosed the Startup log, R3trans startup with error log below:
==================1.SAP STARTUP
==============
filsap:fdvadm 3% startsap
Starting SAP-Collector Daemon
-
20:05:08 13.05.2008 WARNING: Effective userid not root! Expect problems !
***********************************************************************
This is Saposcol Version COLL 20.81 07/01/20 46D - V3.40 64Bit
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 is already running .....
************************************************************************
saposcol already running
Checking SAP R/3 FDV Database
-
Database is not available via /usr/sap/FDV/SYS/exe/run/R3trans -d -w
Starting SAP R/3 FDV Database
-
Startup-Log is written to /home/fdvadm/startdb.log
Database startup failed!
See /home/fdvadm/startdb.log for details
filsap:fdvadm 4%
========================================================================
2.SAP startdb.log
===================
-
Tue May 13 20:05:08 IST 2008
LOGFILE FOR STARTING ORACLE
-
Tue May 13 20:05:08 IST 2008
checking required environment variables
ORACLE_HOME is >/oracle/FDV/920_64<
ORACLE_SID is >FDV<
-
Tue May 13 20:05:08 IST 2008
check initora
-
Tue May 13 20:05:08 IST 2008
check initora
-
Tue May 13 20:05:08 IST 2008
checking V2 connect
TNS Ping Utility for Solaris: Version 9.2.0.5.0 - Production on 13-MAY-2008 20:0
5:08
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/oracle/FDV/920_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (C
OMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = filsap) (PORT = 1527))) (CONNECT_
DATA = (SID = FDV) (GLOBAL_NAME = FDV.WORLD)))
OK (0 msec)
tnsping: V2 connect to FDV
-
Tue May 13 20:05:08 IST 2008
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
-
Tue May 13 20:05:08 IST 2008
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
-
Tue May 13 20:05:14 IST 2008
starting database
SQL*Plus: Release 9.2.0.5.0 - Production on Tue May 13 20:05:14 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 730040776 bytes
Fixed Size 731592 bytes
Variable Size 301989888 bytes
Database Buffers 425984000 bytes
Redo Buffers 1335296 bytes
Database mounted.
Database opened.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Producti
on
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
-
Tue May 13 20:05:23 IST 2008
Connect to the database to verify, that the database is now open
R3trans check finished with return code: 12
ERROR: Startup of database failed
Notify Database Administrator.
-
Tue May 13 20:05:23 IST 2008
/usr/sap/FDV/SYS/exe/run/startdb: Terminating with error code 2
========================================================================
filsap:fdvadm 1% R3trans -d
This is R3trans version 6.05 (release 46D - 17.03.08 - 10:42:00).
2EETW169 no connect possible: "invalid values set for DIR_LIBRARY '/usr/sap/FDV/
SYS/exe/run' or dbms_type 'ORA'"
R3trans finished (0012).
========================================================================
filsap:fdvadm 2% R3trans -x
This is R3trans version 6.05 (release 46D - 17.03.08 - 10:42:00).
2EETW169 no connect possible: "invalid values set for DIR_LIBRARY '/usr/sap/FDV/
SYS/exe/run' or dbms_type 'ORA'"
R3trans finished (0012).
filsap:fdvadm 3%
========================================================================
kindly do the needful to correct the error.
Regards,
S.John