on 11-05-2007 3:40 AM
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 ftped 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
Hi Jalli,
Patch release for kernel is downward compatible but not its release.
You cannot add kernel contents 640 to 620 release.
For your sapcar, do not include sapcar.exe on the directory on which you want to extract the file since when the file is extracted, it has sapcar included in the file.
Regards,
Jeff
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.