Skip to Content
author's profile photo Former Member
Former Member

Error while starting Development Server.

Dear Gurus,

While starting my development server it is giving the following error:

Details:

OS: AIX 5.3

DB: 10.2.0.2

SAP: ECC6

Listner control is starting, but while starting SAP it is giving me the following eror:

hgdevsrv:hdsadm 1> startsap

Checking HDS Database

-


ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

-


16:39:48 26.10.2010 LOG: Effective User Id is root

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

  • This is Saposcol Version COLL 20.95 700 - AIX v11.65 5L-64 bit 090118

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

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

saposcol already running

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

Trying to start HDS database ...

Log file: /home/hdsadm/startdb.log

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

DB startup failed

I tried some of the methods suggested by forum gurus as follows:

hgdevsrv:orahds 1> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Oct 26 16:31:54 2010

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

SQL> shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 2298478592 bytes

Fixed Size 2072936 bytes

Variable Size 1157631640 bytes

Database Buffers 1124073472 bytes

Redo Buffers 14700544 bytes

Database mounted.

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '/oracle/HDS/sapdata1/system_1/system.data1'

Any suggestions please.

Thanks and Regards

Bhaskar.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Oct 26, 2010 at 11:27 AM

    Hi Uday,

    You need to recover your database.

    1. Goto Sqlplus "/as sysdba"

    2. give command Startup mount.

    3. give command recover database.

    4. Alter database open.

    5. Start sap.

    Thanks

    Anil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2010 at 11:44 AM

    Is your database restarted or stopped during backup?

    If yes then Follow Note 4162 - Missing "end backup"

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.