Question:
Hi
After I upgraded Kernel from 620 to 640, SAP is not coming up.
OS: Solaris 10
SAP: R/3 Enterprise 4.71
DB : Oracle 9.2.0.4
-------------------
Notes says that Solaris 10 needs atleast Oracle 9.2.0.6. Upgrading Oracle will solve the problem?
Please go through my logs.
Ashraf
startdb.log
#########################################
#########################################
------------------------------ Sat Aug 12 11:23:31 IST 2006
LOGFILE FOR STARTING ORACLE
Trying to start MBD database ...
------------------------------ Sat Aug 12 11:23:31 IST 2006
checking required environment variables
ORACLE_HOME is >/oracle/MBD/920_64<
ORACLE_SID is >MBD<
------------------------------ Sat Aug 12 11:23:31 IST 2006
check initora
------------------------------ Sat Aug 12 11:23:31 IST 2006
check initora
------------------------------ Sat Aug 12 11:23:31 IST 2006
checking V2 connect
TNS Ping Utility for Solaris: Version 9.2.0.4.0 - Production on 12-AUG-2006 11:23:31
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/oracle/MBD/920_64/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = sapdev) (PORT = 1527))) (CONNECT_DATA = (SID = MBD) (GLOBAL_NAME = MBD.WORLD)))
OK (0 msec)
tnsping: V2 connect to MBD
------------------------------ Sat Aug 12 11:23:31 IST 2006
Connect to the database to check the database state:
R3trans: connect check finished with return code: 12
Database not available
------------------------------ Sat Aug 12 11:23:31 IST 2006
Shutdown database
First trying to shutdown the database - May be,
the database is in the nomount or mount state
------------------------------ Sat Aug 12 11:23:32 IST 2006
starting database
SQL*Plus: Release 9.2.0.4.0 - Production on Sat Aug 12 11:23:32 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 1647381672 bytes
Fixed Size 732328 bytes
Variable Size 872415232 bytes
Database Buffers 772898816 bytes
Redo Buffers 1335296 bytes
Database mounted.
Database opened.
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
------------------------------ Sat Aug 12 11:23:48 IST 2006
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.
/usr/sap/MBD/SYS/exe/run/startdb: Terminating with error code 2
####################################################
#####################################################
#####################################################
R3trand -d -w
##############
4 ETW000 R3trans version 6.09 (release 640 - 28.04.04 - 16:14:00).
4 ETW000 ===============================================
4 ETW000
4 ETW000 date&time : 12.08.2006 - 11:27:45
4 ETW000 control file: <no ctrlfile>
4 ETW000 R3trans was called as follows: R3trans -d -w ashraf.log
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [dev trc ,00000] Sat Aug 12 11:27:45 2006 145 0.000145
4 ETW000 [dev trc ,00000] db_con_init called 18 0.000163
4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 105 0.000268
4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/MBD/SYS/exe/run/dboraslib.so' ...
4 ETW000 58 0.000326
4 ETW000 [dev trc ,00000] load shared library (/usr/sap/MBD/SYS/exe/run/dboraslib.so), hdl 0
4 ETW000 40398 0.040724
4 ETW000 [dev trc ,00000] Library '/usr/sap/MBD/SYS/exe/run/dboraslib.so' loaded
4 ETW000 56 0.040780
4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/MBD/SYS/exe/run/dboraslib.so
4 ETW000 37 0.040817
4 ETW000 [dev trc ,00000] Version of '/usr/sap/MBD/SYS/exe/run/dboraslib.so' is "640.00", patchlevel (0.55)
4 ETW000 171 0.040988
4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/MBD/SYS/exe/run/dboraslib.so
4 ETW000 26 0.041014
4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/MBD/SYS/exe/run/dboraslib.so
4 ETW000 70 0.041084
4 ETW000 [dev trc ,00000] New connection 0 created 25 0.041109
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO
4 ETW000 28 0.041137
4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 39 0.041176
4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:
4 ETW000 22 0.041198
4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , con_max = 255, con_opt = 255, occ = NO
4 ETW000 24 0.041222
4 ETW000 [dev trc ,00000] Got ORACLE_HOME=/oracle/MBD/920_64 from environment
4 ETW000 677 0.041899
4 ETW000 [dev trc ,00000] -->oci_init1 33 0.041932
4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 19 0.041951
4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.US7ASCII 3365 0.045316
4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPMBD's password 19 0.045335
4 ETW000 [dev trc ,00000] Connecting as /@MBD on connection 0 (nls_hdl 0) ...
4 ETW000 23 0.045358
4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch
4 ETW000 37 0.045395
4 ETW000 [dev trc ,00000] 0 1 100ea79e0 100eaf1f8 100eaec08
4 ETW000 25 0.045420
4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 40 0.045460
4 ETW000 [dev trc ,00000] Allocating server context handle 19 0.045479
4 ETW000 [dev trc ,00000] Attaching to DB Server MBD (con_hdl=0,svchp=100eaeb38,svrhp=100eaf848)
4 ETW000 105 0.045584
4 ETW000 [dev trc ,00000] Assigning server context 100eaf848 to service context 100eaeb38
4 ETW000 40725 0.086309
4 ETW000 [dev trc ,00000] Allocating user session handle 26 0.086335
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100eaeb38,srvhp=100eaf848,usrhp=100eb9218)
4 ETW000 31 0.086366
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 2288 0.088654
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=100eaf848)
4 ETW000 23 0.088677
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=100eaeb38,srvhp=100eaf848)
4 ETW000 22 0.088699
4 ETW000 [dev trc ,00000] Deallocating server context handle 100eaf848 312 0.089011
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 44 0.089055
4 ETW000 [dev trc ,00000] Try to connect with default password 39 0.089094
4 ETW000 [dev trc ,00000] Connecting as SAPMBD/<pwd>@MBD on connection 0 (nls_hdl 0) ...
4 ETW000 24 0.089118
4 ETW000 [dev trc ,00000] Nls Characterset Natcharacterset C EnvHp ErrHp ErrHpBatch
4 ETW000 30 0.089148
4 ETW000 [dev trc ,00000] 0 1 100ea79e0 100eaf1f8 100eaec08
4 ETW000 24 0.089172
4 ETW000 [dev trc ,00000] Allocating server context handle 14 0.089186
4 ETW000 [dev trc ,00000] Attaching to DB Server MBD (con_hdl=0,svchp=100eaeb38,svrhp=100eaf848)
4 ETW000 32 0.089218
4 ETW000 [dev trc ,00000] Assigning server context 100eaf848 to service context 100eaeb38
4 ETW000 32737 0.121955
4 ETW000 [dev trc ,00000] Assigning username to user session 100eb9218 24 0.121979
4 ETW000 [dev trc ,00000] Assigning password to user session 100eb9218 19 0.121998
4 ETW000 [dev trc ,00000] Starting user session (con_hdl=0,svchp=100eaeb38,srvhp=100eaf848,usrhp=100eb9218)
4 ETW000 24 0.122022
4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 12705
4 ETW000 5883 0.127905
4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=1,svrhp=100eaf848)
4 ETW000 29 0.127934
4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=100eaeb38,srvhp=100eaf848)
4 ETW000 25 0.127959
4 ETW000 [dev trc ,00000] Deallocating server context handle 100eaf848 259 0.128218
4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12705'
4 ETW000 152 0.128370
4 ETW000 [dblink ,00419] ***LOG BY2=>sql error 12705 performing CON [dblink#1 @ 419]
4 ETW000 72 0.128442
4 ETW000 [dblink ,00419] ***LOG BY0=>ORA-12705: invalid or unknown NLS parameter value specified [dblink#1 @ 419]
4 ETW000 23 0.128465
2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'MBD'"
Answer:
http://ora-12705.ora-code.com/