cancel
Showing results for 
Search instead for 
Did you mean: 

Shadow instance start up failed during upgrade preprocessing

0 Kudos
723

Dear All,

We are upgrading our SAP R/3 4.7 to ECC 6 EHP7. O/S is AIX 6.1 and database is Db2 9.1 FP10.

We are getting following error during upgrade pre-processing .

Severe error(s) occurred in phase MAIN_SHDPREPUT/START_SHDI_PREPUT!

Last error code set: Shadow instance couldn't be started, check 'STARTSSC.LOG' and 'DEVTRACE.LOG': Process /usr/sap/OS2/SUM/abap/exe/sapcontrol exited with 2, see '/usr/sap/OS2/SUM/abap/log/SAPup.ECO' for details

Belog is the log from /usr/sap/OS2/SUM/abap/log/DEVTRACE.LOG

*** ERROR in DbSlConnectDB6[/bas/741_REL/src/dbs/db6/dbsldb6.c, 1317] CON = 0 (BEGIN)

C  &+    DbSlConnectDB6: DB2DB6EKEY not found in environment or password file

C  &+

C  &+

C  &+

C  *** ERROR in DbSlConnectDB6[/bas/741_REL/src/dbs/db6/dbsldb6.c, 1317] (END)

M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 000256) [thDatabase.c 71]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c  2323]

Environment variable DB2DB6EKEY  is already set to OS2ri3pa043.

output of the command setenv

I have stopped SUM, sap on primary, shadow instances & regenerated the password file by using below command.

dscdb6up -create <connect_user password> <sidadm password>

Replaced the Kernel present in /usr/sap/OS2/SUM/abap/exe with the latest target release kernel available from service market place.

I tried to restart SUM but no luck.

I tried to start shadow instance manually, but failed with below error

ri3pa043:os2adm 10> cd /usr/sap/OS2/SUM/abap/bin

ri3pa043:os2adm 11> ./SAPup startshd

Starting shadow system ...

Starting service ...

FATAL ERROR: Process /usr/sap/OS2/SUM/abap/exe/sapcontrol exited with 2, see '/usr/sap/OS2/SUM/abap/log/SAPup.ECO' for details

I am attaching  DEVTRACE.LOG, STARTSSC.LOG from /usr/sap/OS2/SUM/abap/log & dev_w0 from /usr/sap/OS2/SUM/abap/system/OS2/DVEBMGS02/work.

Can someone please check the logs & help me.

Thanks,

Vinay

View Entire Topic
former_member182657
Active Contributor
0 Kudos

Hi Vinay,


ERROR in DbSlConnectDB6[/bas/741_REL/src/dbs/db6/dbsldb6.c, 1317] CON = 0 (BEGIN)

C  &+     DbSlConnectDB6: DB2DB6EKEY not found in environment or password file  

Issue here is with the encryption key DB2DB6EKEY,suggest you to follow the document http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f029fc09-9016-2a10-6684-c7fa324dd...


& SCN thread Error when installing dialog instance | SCN


Hope this will help you .


Regards,

0 Kudos

Hi Gaurav,

Thanks for the reply. I have already gone through the SCN thread Error when installing dialog instance | SCN & I was able to execute below command successfully.

dscdb6up -create <connect_user password> <sidadm password>

But when I tried to start up shadow instance manually after executing above command, it was failed with below error.

ri3pa043:os2adm 10> cd /usr/sap/OS2/SUM/abap/bin

ri3pa043:os2adm 11> ./SAPup startshd

Starting shadow system ...

Starting service ...

FATAL ERROR: Process /usr/sap/OS2/SUM/abap/exe/sapcontrol exited with 2, see '/usr/sap/OS2/SUM/abap/log/SAPup.ECO' for details



When I execute command db2 connect to OS2 user sapr3 <connect user password>, it failed with below SQL error.


Please let me know if you need any further logs.

Please help me to resolve the issue.

Thanks,

Vinay

0 Kudos

Hi Vinay,

Regarding your issue, can you please check if


.dbenv_<server>.csh
.dbenv_<server>.sh


exist under /home/<sid>adm


Maintain the DB2DB6EKEY environment variable if it is missing according to the guidelines of the note 582875:


1. su - <sid>adm
2. su root
3. setenv DB2DB6EKEY <sid><hostname>


then the entry should not occur in the work process files


582875 DB6: SAP cannot log onto the database


Stop all processes of the system afterwards (including sapstartsrv
process) and try to start the system.

Thank You.

Regards,

Deepika

0 Kudos

Hi Deepika,

Thanks for the reply.

I do not see .dbenv_<server>.csh, .dbenv_<server>.sh files under /home/<sid>adm.

ri3pa043:os2adm 1> pwd

/home/os2adm

ri3pa043:os2adm 2> ls -al

total 392

drwxr-xr-x    2 os2adm   sapsys         4096 Aug 11 07:10 .

drwxr-xr-x   98 root     system         4096 Aug 07 21:37 ..

-rwxr-xr-x    1 os2adm   sapsys         1367 Jan 08 2015  .cshrc

-rwxr-xr-x    1 os2adm   sapsys         5462 Apr 22 18:27 .dbenv.csh

-rwxr-xr-x    1 os2adm   sapsys         4624 Apr 22 18:27 .dbenv.sh

-rwxr-xr-x    1 os2adm   sapsys          250 Jul 02 2004  .dbsrc_ri3pa043.csh

-rwxr-xr-x    1 os2adm   sapsys          232 Jul 02 2004  .dbsrc_ri3pa043.sh

-rwxr-xr-x    1 os2adm   sapsys         1594 Jan 08 2015  .login

-rwxr-xr-x    1 os2adm   sapsys         1065 Jul 24 17:14 .profile

-rwxr-xr-x    1 os2adm   sapsys        10746 Apr 22 18:27 .sapenv.csh

-rwxr-xr-x    1 os2adm   sapsys         9733 Apr 22 18:27 .sapenv.shold

-rwx------    1 os2adm   sapsys         8367 Aug 10 05:37 .sapenv_ri3pa043.csh

-rwxr-xr-x    1 os2adm   sapsys         8397 Aug 10 05:40 .sapenv_ri3pa043.csh.old1

-rwx------    1 os2adm   sapsys         7593 Aug 10 05:37 .sapenv_ri3pa043.sh

-rwxr-xr-x    1 os2adm   sapsys         7634 Aug 10 05:39 .sapenv_ri3pa043.sh.old1

-rwxr-xr-x    1 os2adm   sapsys         1116 Oct 08 2004  .sapsrc_ri3pa043.csh

-rwxr-xr-x    1 os2adm   sapsys          817 Oct 08 2004  .sapsrc_ri3pa043.sh

-rw-------    1 root     system          472 Jul 31 04:30 .sh_history

-rwxr-xr-x    1 os2adm   sapsys         1058 Aug 11 08:40 dev_sapstart

-rwxr-xr-x    1 os2adm   sapsys           25 Dec 24 2014  rfcexec.sec

-rw-------    1 os2adm   sapsys          799 Jul 31 07:19 sapuxuserchk.log

-rwxr-xr-x    1 os2adm   sapsys         6992 Aug 07 02:31 smit.log

-rwxr-xr-x    1 os2adm   sapsys         1362 Apr 01 06:26 smit.script

-rwxr-xr-x    1 os2adm   sapsys         1761 Apr 01 06:26 smit.transaction

-rw-------    1 os2adm   sapsys          870 Aug 12 10:50 startdb.log

-rw-------    1 os2adm   sapsys         2127 Aug 12 10:51 startsap_DVEBMGS00.log

-rw-------    1 os2adm   sapsys          734 Aug 12 01:47 stopdb.log

-rw-------    1 os2adm   sapsys          264 Aug 12 07:46 stopsap_DVEBMGS00.log

-rwxr-xr-x    1 os2adm   sapsys        31894 Aug 13 01:54 trans.log

Where as the files present under /db2/db2<sid> & environment variable DB2DB6EKEY correctly maintained there.

But when I execute setnenv command as user <sid>adm, it's showing the entry DB2DB6EKEY=OS2ri3pa043.

I tried to copy .dbenv_<server>.csh, .dbenv_<server>.sh files from /db2/db2<sid> to /home/<sid>adm & tried to start the shadow instance but the start up failed & it created a core dump of 30 GB under shadow instance work directory & corresponding file sytem got full.

Thanks,

Vinay