Database startup problem

[Former Member]

Hi All,

SAP ECC6.0 with oracle 10 on HP - UX.

I have stopped the SAP instance & the database in SQL>shutdown, it took very long time to execute down DB , so i cancelled it.

when i was trying to get in the same position, its giving error

MDECCSAN:mdsadm 22> startsap

Checking MDS Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

11:45:04 21.07.2009 LOG: Effective User Id is root

***********************************************************************

• This is Saposcol Version COLL 20.95 700 - V2.7.1 2008-08-11 HP-UX IA64

• Usage: saposcol -l: Start OS Collector

• saposcol -k: Stop OS Collector

• saposcol -d: OS Collector Dialog Mode

• saposcol -s: OS Collector Status

• The OS Collector (PID 29461) is already running .....

************************************************************************

saposcol already running

Running /usr/sap/MDS/SYS/exe/run/startdb

Trying to start MDS database ...

Log file: /home/mdsadm/startdb.log

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

DB startup failed

-

---

and when i was trying to start database,

SQL> startup

ORA-01081: cannot start already-running ORACLE - shut it down first

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress - no operations are permitted.

Kindly suggest.

[Former Member]

Hi

You may try check this blog

Regards

Uday

[Former Member]

we use 10.2.0.2

[Former Member]

try to upgrade the patchset to make it .4, ie. 10.2.0.4

It is very much recommended to have latest patchset and then interim/cpu all patches to it.

[former_member204746]

try this:

sqlplus / as sysdba

shutdown immediate;

if this fails:

shutdown abort;

then:

startup

exit;

then, try stopping and starting SAP again.

good luck.

[Former Member]

Hi Anjali,

Thnx for reply.

kindly suggest how i can update patch set of oracle from 10.0.2 to 0.4

ist i download patchset grom market place, palce it in /oracle/stage

how to uncar these files & execute,

any step by step doc please

i have not updayes oracle patches yet

Regards!!

[Former Member]

Hi

Try to follow the Notes, these will tell everything what to do and how to do. With downloads, Readme.html file comes, which contains step by step procedure too. For documents, I do not think there is some procedure to attach them here on SDN

Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0

Note 871735 - Current patch set for Oracle 10.2.0

[Former Member]

This message was moderated.

[Former Member]

Hi,

It has been resolved, i kiled the process and started database & got up.

SAP also working fine.

But i want to onething, why SHUTDOWN takes this much time to get DB down.

Rgds!!

[Former Member]

Hi,

verify your SCHEMA user is locked .also verify the user password.

regards,

ajai

[Former Member]

Seems like an installation problem to me. which vesion of orcale do u run - 10.2.0.2 ?