sap is not starting after applying oracle patch

[Former Member]

Dear All,

I have installed mySAP ECC5 on linux 32 bit with Orcle 9i 9.2.0.1 . It was successfully completed but giving dump on every sap transection

Then i have successfull installed Oracle patch 9.2.0.4 but after that sap is not working and database is not comming up.

and giving below error log

Log file: /oracle/PR2/startdb.log

/usr/sap/PR2/SYS/exe/run/startdb: Terminating with error code 12

prdtest:orapr2 2> vi /oracle/PR2/startdb.log

-

---

Tue Oct 7 19:31:39 IST 2008

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Tue Oct 7 19:31:39 IST 2008

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Tue Oct 7 19:31:39 IST 2008

starting database

-

---

Tue Oct 7 19:31:39 IST 2008

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

Pl. help . Thanks is advance

Thanks

Neeraj

[Former Member]

Hi Neeraj,

I think you didnt follow right process to install oracle patch. Never ignore any error and continue patching. SAP wont start as database is not running fine. You need to relink all libraries again. find our why it is unable to link libraries. update message with the log files during the patch installation. check whether you have correct gcc packages.

Thanks,

Kiran.

[former_member105207]

Hi Neeraj,

Further Pls refer the Sapnote 722273 - Red Hat Enterprise Linux 3 and 4: Installation and upgrade

This might help you.

Pls let us know the linux version you using now.

Regards

chandru

[markus_doehr2]

Did you run the necessary scripts after you installed the patch?

Markus

[Former Member]

Yes Sir,

I run the root.sh script after installation of patch 9.2.0.4 . it was giving below error

"Error in invoking target install of make file /oracle/PR2/920_32/network/lib/ins_net_server.mk "

I have ignored all the errors and patch was completed successfuly.

Pl. advice .

Thank you

Neeraj Ahuja

[markus_doehr2]

I run the root.sh script after installation of patch 9.2.0.4 . it was giving below error

"Error in invoking target install of make file /oracle/PR2/920_32/network/lib/ins_net_server.mk "

I´m not sure if the root script was giving that error.

I have ignored all the errors and patch was completed successfuly.

well - it was not successful and you´re not finished. If you read the README file that comes with the patch, you need to start the database and run a few scripts to adapt to the new patch.

The link error above means that the "network part" could not be linked and thus you have no listener and that´s why you don´t get any output when you issue the "lsnctl" command.

Try the following:

- login as ora

- execute "$ORACLE_HOME/bin/relink all"

Does this work without errors?

Markus

[Former Member]

Hi,

I have tried the command but it is also not giving any response .

Pl. advice

Thanks

Neeraj

[markus_doehr2]

It seems your Oracle installation is hosed (for whatever reason).

I would start from scratch and use Oracle 10g instead of 9.2 (which has some installation troubles on newer Linux versions). 9.2 is already out of maintenance and support.

If you need the system open an OSS call and let the support have a look on the system.

Markus

[Former Member]

Dear Sir,

Thanks for your reply , can you pl. help me how to install oracle patch 9.2.0.4 on Oracle 9i 9.2.0.1 .

At time of installation of oracle 9i 9.2.0.1 , it was giving same kind of error like

" Error in invoking target install of makefile /oracle/PR2/920_32/sqlplus/lib/ins_sqlplus.mk "

so many errors has come , I have ignored all the errors and installed Oralce 9i 9.2.0.1 and completed the sap installation .

SAP was giving dump on every transection so i have upgraded the kernel and updated the patch 9.2.0.4

at the time installation it was again giving same kind of error

" Error in invoking target install of makefile ................................."

and sap is stopped .

i have gone through with patch installation file but is very confusing document so many things and bugs are mentioned except above error.

Can you pl. help what is the currect step by step procedure to make it correct at next installation.

I will be very much thankfull to you .

Regd

Neeraj

[markus_doehr2]

The way it would be is like:

- install central instance

- install database instance untilt he point you´re requested by sapinst to install the database (do not install it before)

- run the script RUNINSTALLER in the SAP subdirectory of the DVD (no not run ./runInstaller)

- ignore the relink errors of version 9.2.0.1

- download patch 9.2.0.8 and install it using ./runInstaller

- download the latest interim patches for 9.2.0.8 and install them using opatch

you should not see any relink errors with that newest patchset.

and then continue with sapinst.

If you follow the official installation guides attentively there will be links to notes how to install.

Oracle is a complex beast.

Markus

[former_member105207]

Hi Neeraj,

Kindly check you have installed the required glib abd glibc packages.

Please refer these below links... this might help you overcome the problem

Oracle 9i needs old binary files for relinking. Pls refer Metalink oracle note 303859.1

Kindly proceed as below. Try to install glib and glibc version 2

cd /usr/bin

mv ./gcc ./gcc34

mv ./gcc296 ./gcc

http://ivan.kartik.sk/oracle/install_ora9_elinux.html

http://www.puschitz.com/InstallingOracle9i.shtml

I had the same problem and overcame by the above method.

Regards,

chandru.

[Former Member]

Dear Markus ,

I have downloaded the patch 9.2.0.8 and copied to the server . I have installed the oracle 9.2.0.1 when SAP database instance ask to install the oracle database and ignored relink errors comes in installation .

After completing the installation of 9.2.0.1 . I have started the installation of oracle patch 9.2.0.8 but below message has come

" the target area /oracle/orainventory is being used as a source by another session. "

then I have stoped the installation of SAP Database instance and restarted the server and restarted the installation of oracle patch 9.2.0.8

again few below error messages has came

"Error in invoking target "INSTALL" of makefile '/oracle/PR2/920_32/network/lib/ins_oemagent.mk "

I have completed the installation with continue option .

Is the right procedure to install the patch .

how to install interim patches with the use of opatch utility .

Now database installation is in process .

Pl. advice . I am installing mySAP ECC5 on RHEL 4.

Thanks

[markus_doehr2]

Did you follow the section "Additional notes for installation on Oracle 9i" in note

722273 - Red Hat Enterprise Linux 3 and 4: Installation and upgrade?

Markus

[Former Member]

Is Oracle listener up and running?

Useful commands (execute as user ora<sid>)

lsnrctl status

lsnrctl start

[Former Member]

Hi,

Thanks for your reply , the command

prdtest:orapr2 1> lsnrctl status

prdtest:orapr2 2> lsnrctl start

prdtest:orapr2 3>

are not giving any out put .

Pl. advice .

Thanks

Neeraj