db start failed

[sivakumar_kilari3]

Hi Markus,

Please help me urjent.

I appliying abap patch 12. automaticalyy stucked.

so restarted instance. Iam getting follwing error.

sapdev:edvadm 5> startsap

Checking EDV Database

-

---

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-

---

14:26:02 28.10.2008 LOG: Effective User Id is root

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

• This is Saposcol Version COLL 20.94 700 - AIX v10.35 5L-64 bit 070123

• 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 356568) is already running .....

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

saposcol already running

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

Trying to start EDV database ...

Log file: /home/edvadm/startdb.log

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

DB startup failed

Regards

Siva

[markus_doehr2 · Accepted solution]

Which database are you using? Can you start the database manually?

Markus

[sivakumar_kilari3 · Accepted solution]

Hi Markus,

Thanks for qucik reply

SQL> startup

ORACLE instance started.

Total System Global Area 2399141888 bytes

Fixed Size 2022736 bytes

Variable Size 1207960240 bytes

Database Buffers 1174405120 bytes

Redo Buffers 14753792 bytes

Database mounted.

ORA-16038: log 2 sequence# 3130 cannot be archived

ORA-19502: write error on file "", blockno (blocksize=)

ORA-00312: online log 2 thread 1: '/oracle/EDV/origlogB/log_g12m1.dbf'

ORA-00312: online log 2 thread 1: '/oracle/EDV/mirrlogB/log_g12m2.dbf'

Regards

Siva

[markus_doehr2 · Accepted solution]

It seems your Oracle archive log directory/filesystem is full.

Markus

[Former Member · Accepted solution]

can you paste result of 'df -k' unix command.

cheers,

-Sunil

[sivakumar_kilari3 · Accepted solution]

Thanks markus

Problem solved.

Regards

Siva

[Former Member]

hi skumar,

check your startdb.log first. Please paste here so we can analyzed it.

I am sure you can find some information why your database doesn't want to start.

ardhian

http://sapbasis.wordpress.com

http://ardhian.kioslinux.com