Skip to Content
0
Former Member
Nov 05, 2007 at 03:40 AM

Kernel Upgrade problem: R3, 4.71, Oracle 9i, Sun Solaris

21 Views

Hi experts,

I am facing problem while Kernel Upgrade. There are two methods I tried.

1 Method:

Our Development system is 640 kernel and Production is 620. So I copied exe directory from Development to local desktop thro ftp and also copied 620 kernel from production and on this 620 kernel added 640 kernel contents. After this zipped this folder and ftp’ed to unix server then replaced exe directory of sapmnt/P47. File ownerships/permissions copied from development system.

Then when I try to start system database is not starting. It is showing following error in startdb.log

::::::::::::::

startdb.log

::::::::::::::

-


Sat Nov 3 19:34:58 IST 2007

LOGFILE FOR STARTING ORACLE

Trying to start P47 database ...

-


Sat Nov 3 19:34:58 IST 2007

checking required environment variables

ORACLE_HOME is >/oracle/P47/920_64<

ORACLE_SID is >P47<

-


Sat Nov 3 19:34:58 IST 2007

check initora

-


Sat Nov 3 19:34:58 IST 2007

check initora

-


Sat Nov 3 19:34:58 IST 2007

checking V2 connect

TNS Ping Utility for Solaris: Version 9.2.0.7.0 - Production on 03-NOV-2007 19:34:58

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:

/oracle/P47/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

= prd47e) (PORT = 1527))) (CONNECT_DATA = (SID = P47) (GLOBAL_NAME = P47.WORLD)))

OK (0 msec)

tnsping: V2 connect to P47

-


Sat Nov 3 19:34:58 IST 2007

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-


Sat Nov 3 19:34:59 IST 2007

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-


Sat Nov 3 19:35:08 IST 2007

starting database

SQL*Plus: Release 9.2.0.7.0 - Production on Sat Nov 3 19:35:08 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 1249618280 bytes

Fixed Size 731496 bytes

Variable Size 788529152 bytes

Database Buffers 459022336 bytes

Redo Buffers 1335296 bytes

Database mounted.

Database opened.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.7.0 - Production

-


Sat Nov 3 19:35:16 IST 2007

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/P47/SYS/exe/run/startdb: Terminating with error code 12

……………………………………………………………………..

But when I try R3trans –d it is giving return code 0

Here is some info of our file system

bash-2.05$ pwd

/usr/sap/P47/SYS/exe

bash-2.05$ ls -l

total 80

lrwxrwxrwx 1 root other 15 Oct 29 2004 dbg -> /sapmnt/P47/exe

drwxr-xr-x 2 p47adm sapsys 512 Oct 29 2004 opt

lrwxrwxrwx 1 root other 3 Oct 29 2004 run -> dbg

...........................................................

bash-2.05$ pwd

/sapmnt/P47

bash-2.05$ ls -l

total 176

drwxr-xr-x 3 p47adm sapsys 3072 Sep 26 2006 exe

drwx------ 6 p47adm sapsys 512 Nov 3 19:39 global

drwx------ 2 root root 8192 Oct 28 2004 lost+found

drwxr-xr-x 2 p47adm sapsys 512 Nov 2 2004 profile

Is it correct to replace the exe in sapmnt/SID ??? or any extra we have to do.??

More over the contents of run and dbg are identical while opt folder is empty.

2nd method I tried:

Downloaded both database dependent and independent SAR files when I uncar database dependent it is ok.

But while uncaring database independent SAR file it is throwing error as below.

root@prd47e # ./SAPCAR -xvf SAPEXE_175-20000221.SAR

SAPCAR: processing archive SAPEXE_175-20000221.SAR

x FRFCLIB32.SAR

x R3check

x R3trans

x SAPCAR

Bus Error (core dumped)

Any body face this type of problem. . . . .

Adv Thanks