PI Instance could not start after Kernel upgrade from 7.11 to 7.20

[former_member269096]

Hello, Experts,

I'm now upgrading SAP kernel from 7.11 to 7.20 with PI.

Referring to SAP Note:1636252

The steps are...

1.Download kernel files SAPEXE_201, SAPEXEDB_201,DBATL720O10

2.Backup old kernel files.

3.Change access permission of old  kernel executables

4.Delete old  kernel executables

5.Extract new kernel files with SAPCAR.

6.Execute root.sh

7.Execute sapcpe to copy new kernel files.

8.brconnect -u system/<pw> -f chpass -p <new_password>

After step 8, PI Instance won't come up with error message below.

-----------------------------------------

Starting Startup Agent sapstartsrv

Unknown webmethod: WaitforServiceStarted

Startup of Instance Service failed

See /home/dt0adm/startsap_SCS01.log for details

-----------------------------------------

At first I tried to start PI instance after step7,

PI instance won't come up.

So I checked some note and SCN Discussion.

I concluded this situation will be solved with step 8, But it still won't work.

Does anyone have faced similar situation like us ?

If you have any ideas about this condition?

Please let me know.

Our environement is below.

OS : RedHatEnterpriseLinux 5.8

DB : Oracle11.2.0

Componet: PI7.1Ehp1 SP08

Best Regards,

[former_member191911 · Accepted solution]

What does the log startsap_SCS01.log says?

Kr. Mark

[former_member269096 · Accepted solution]

Dear M.Dijsselbloem,

Thanks for your reply.

You mean the log file /home/<sidadm>/startsap_SCS01.log ?

This log message are below.

-------------------------------------------------------

Trace of system startup/check of SAP System DT1 on 2012年  7月 31日 火曜日 22:14
:35 JST

Called command: startsap start

-------------------------------------------
22:14:35
Starting Startup Agent sapstartsrv

-------------------------------------------
22:14:35
Startup of Instance Service failed

-------------------------------------------
22:14:35
See /home/dt1adm/startsap_SCS01.log for details

-------------------------------------------------------

Best Regards,

[former_member191911 · Accepted solution]

Okay, this doesn't tell anything... Can you check the dev_* files in the work directory of the SCS instance?

What you can try as well, is stopping the SCS instance (stopsap SCS01), clear the shared memory segments via cleanipc 01 remove and try to start it again..

Kr. Mark

[former_member269096 · Accepted solution]

Dear M.Dijsselbloem

Thanks for your help.

I checked dev_sapstart file and the contents are below.

---------------------------------------------------

trc file: "dev_sapstart", trc level: 1, release: "711"

---------------------------------------------------

Wed Aug 1 13:45:14 2012

SigISetDefaultAction : default handling for signal SIGCHLD

SigISetIgnoreAction : SIG_IGN for signal SIGINT

SigISetIgnoreAction : SIG_IGN for signal SIGQUIT

SigISetIgnoreAction : SIG_IGN for signal SIGINT

SigISetIgnoreAction : SIG_IGN for signal SIGQUIT

SigISetIgnoreAction : SIG_IGN for signal SIGINT

SigISetIgnoreAction : SIG_IGN for signal SIGQUIT

SigISetIgnoreAction : SIG_IGN for signal SIGINT

SigISetIgnoreAction : SIG_IGN for signal SIGQUIT

SigISetIgnoreAction : SIG_IGN for signal SIGINT

SigISetIgnoreAction : SIG_IGN for signal SIGQUIT

SigISetIgnoreAction : SIG_IGN for signal SIGINT

SigISetIgnoreAction : SIG_IGN for signal SIGQUIT

SigISetIgnoreAction : SIG_IGN for signal SIGINT

SigISetIgnoreAction : SIG_IGN for signal SIGQUIT

Wed Aug 1 15:08:20 2012

SI_USER: Sent by kill, sigsend, raise

Sending process ID = 21317

Real user ID of sending process = 3200

caught SIGINT (2)

And I tried to cleanipc as you mentioned.

The results are same as before....

sfapi:dt1adm 51> cleanipc 00 remove

Show/Cleanup SAP-IPC-Objects V2.3, 94/01/20
===========================================

Running SAP-Systems (Nr)...:

----------------------------------------------------------
---- Clear IPC-Objects of Sap-System  0 ------------------
----------------------------------------------------------

Number of IPC-Objects...........:    0
Number of removed IPC-Objects...:    0
Summary of all Shared Memory....:     6674.1 MB (may be incomplete when not in superuser mode)

Number of SAP_ES files found:.............:    0
Number of SAP_ES files removed:...........:    0

sfapi:dt1adm 52> cleanipc 01 remove

Show/Cleanup SAP-IPC-Objects V2.3, 94/01/20
===========================================

Running SAP-Systems (Nr)...:

----------------------------------------------------------
---- Clear IPC-Objects of Sap-System  1 ------------------
----------------------------------------------------------
OsKey:    10173 0x000027bd Shared Memory Key: 73 removed
OsKey:    20126 0x00004e9e Semaphore Key: 26 removed
OsKey:    20138 0x00004eaa Semaphore Key: 38 removed
OsKey: 58900101 0x0382be85 SCSA Shared Memory Key: 58900000 removed

Number of IPC-Objects...........:    4
Number of removed IPC-Objects...:    4
Summary of all Shared Memory....:     6674.1 MB (may be incomplete when not in superuser mode)

Number of SAP_ES files found:.............:    0
Number of SAP_ES files removed:...........:    0

sfapi:dt1adm 53> startsap
Checking DT1 Database
Database is not available via R3trans
-------------------------------------------
Trying to start DT1 database ...
Log file: /home/dt1adm/startdb.log
/usr/sap/DT1/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed

please send the tracefile /home/dt1adm/startsap.trc to support

Best Regards,

[former_member191911 · Accepted solution]

Ah, now we're getting somewhere... Looks like your database cannot be started.

Can you try to start the database via sqlplus.

As <sid>adm user: sqlplus "/as sysdba"

SQL> startup

Kr. Mark

[former_member269096 · Accepted solution]

Dear M.Dijsselbloem

Thanks for your responce.

I followed your advice, but the data base seemed to be started...

Does this database perfectly started ??

--------------------------------------------------------------------------

sfapi:dt1adm 58> stopsap
Checking DT1 Database
Database is not available via R3trans
-------------------------------------------
stopping the SAP instance DVEBMGS00
Shutdown-Log is written to /home/dt1adm/stopsap_DVEBMGS00.log
-------------------------------------------
Instance DVEBMGS00 was not running!
stopping the SAP instance SCS01
Shutdown-Log is written to /home/dt1adm/stopsap_SCS01.log
-------------------------------------------
Instance SCS01 was not running!
sfapi:dt1adm 59>
sfapi:dt1adm 59>
sfapi:dt1adm 59> startsap
Checking DT1 Database
Database is not available via R3trans
-------------------------------------------
Trying to start DT1 database ...
Log file: /home/dt1adm/startdb.log
/usr/sap/DT1/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed

please send the tracefile /home/dt1adm/startsap.trc to support

sfapi:dt1adm 60> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 2 15:28:52 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>

--------------------------------------------------------------------------

Best Regards,

[former_member191911 · Accepted solution]

Can you execute the following statement via sqlplus: select open_mode from v$database;

If the database is open (read/write), than please execute R3trand -d as user <sid>adm and post the output here.

Kr. Mark

[former_member269096 · Accepted solution]

I checked database open mode as below.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL>

I attached the trans.log

Please check it.

Best Regards,

trans.log.txt.zip

[former_member191911 · Accepted solution]

Looks like there is no password set for user SAPSR3

Can you execute the following command: brconnect -u system/<password> -f chpass -u SAPSR3

After that execute again R3trans -d

Kr. Mark

[former_member269096 · Accepted solution]

The result of brconnect are below....

sfapi:dt1adm 66> brconnect -u system/SAPadmin06 -f chpass -u SAPSR3
BR0801I BRCONNECT 7.20 (20)
BR0153E Unknown option '-u' found at position 5
BR0154E Unexpected option value 'SAPSR3' found at position 6

BR0280I BRCONNECT time stamp: 2012-08-02 16.32.39
BR0804I BRCONNECT terminated with errors
sfapi:dt1adm 67> brconnect -u system/SAPadmin06 -f chpass -o SAPSR3
BR0801I BRCONNECT 7.20 (20)
BR0280I BRCONNECT time stamp: 2012-08-02 16.35.09
BR1048I Enter new password for database user 'SAPSR3' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2012-08-02 16.35.19
BR1048I Reenter new password for database user 'SAPSR3' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2012-08-02 16.35.26
BR0829I Password changed successfully in database for user SAPSR3
BR0830I Password changed successfully in table OPS$DT1ADM.SAPUSER for user SAPSR3

BR0280I BRCONNECT time stamp: 2012-08-02 16.35.26
BR0802I BRCONNECT completed successfully
sfapi:dt1adm 68> startsap
Checking DT1 Database
Database is not available via R3trans
-------------------------------------------
Trying to start DT1 database ...
Log file: /home/dt1adm/startdb.log
/usr/sap/DT1/SYS/exe/run/startdb: Terminating with error code 12
DB startup failed

please send the tracefile /home/dt1adm/startsap.trc to support

sfapi:dt1adm 69>

Is R3trans not working correctly?

[former_member191911 · Accepted solution]

No, it's not... Can you post again the output of R3trans -d to see if you get rid of the ORA-1005 error.

If the issue still persists, you should have a look at note Note 400241 - Problems with ops$ or sapr3 connect to Oracle

Kr. Mark

[former_member269096 · Accepted solution]

I retried R3trans -d, and found the ORA-1005 still remained.

I re-attached the trans.log.

I will start to cheke the note 400241,

Best Regards,

trans.log2.txt.zip

[former_member269096 · Accepted solution]

Dear  M. Dijsselbloem.

Thanks for your advice.

I appriciate your comment very much!

I checked all of procedure I have done.

I found that the Kernel files was for Non-Unicode system!!

I re-down load the Kernel files fo Unicode system.

After all I succeeded the Kernel upgrade.

The only change I have made from the instruction was execute sapcpe not only for DVEBMGS00 but also for SCS01.

Best Regards,

[former_member191911 · Accepted solution]

Good to hear that your issue has been resolved!