Server status showing Ended

[naresh_bammidi]

Dear Experts,

I have installed sap ides in my system,when i start the server it is showing status as ended.Same problem has happened earlier,but i solved this issue by unlocking the SAPSR3 Database.But now if  i log in to the sqlplus through command prompt,it is showing error message like ORA-01033:ORACLE initialization or shtdown in progress.what is the problem here?being not a BASIS guy i couldn't resolve the issue.please help me out.

Thanks

Naresh

Message was edited by: Naresh Bammidi

[naresh_bammidi · Accepted solution]

Hi,

my outln account is locked and also db is not open.I solved my self by using following commands.

run->cmd->sqlplus

Enter user-name: <uname> as sysdba

Enter password: <pword>

SQL> select open_mode from v$database;

OPEN_MODE

---

MOUNTED

recover database until cancel;

alter database open resetlogs;

alter database open;

alter user outln account unlock;

Then started the sap server.worked fine.

Thanks

Naresh

[naresh_bammidi]

Any replies?

[Former Member]

Hi,

Perhaps the Oracle database is not started/shutdown properly. What DB operations happened before this? Try a 'shutdown abort' sqlplus command and then retry a clean startup again. Make sure the SAP system is shutdown before all this.

Regards,

Srikishan

[naresh_bammidi]

Hi srikishan,

I followed above steps,but nothing has worked.see the following operations which i have done in sqlplus prompt.

  SQL*Plus: Release 10.2.0.2.0 - Production on Sat May 26 23:31:07 2012

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

Enter user-name: system

Enter password:

ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

Enter user-name: / as sysdba

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> select username from dba_user;

select username from dba_user

                     *

ERROR at line 1:

ORA-01219: database not open: queries allowed on fixed tables/views only

SQL>

Now it is showing above error.please let me know if any other database issue.

[naresh_bammidi]

Hi,

Make sure the SAP system is shutdown before all this.

what it means?..do you mean to say stop the SAP server before doing DB operations?