OraFAQ Forum: Server Administration » regarding oracle database

Home » RDBMS Server » Server Administration » regarding oracle database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

regarding oracle database [message #291618]

Sat, 05 January 2008 08:48

akhilacsit
Messages: 2
Registered: January 2008

Junior Member

i have oracle reports and forms in my system and also oracle database.now problem is i am not able to work on oracle database.Is it due to d2k developer 2000 or any other problem i am not able to understand.how to make my oracle database work again?when i am trying to open oracle DB its giving error as oracle initialisation or shutdown in process(error number 01033.oracle version is 8.0.

Report message to a moderator

Re: regarding oracle database [message #291619 is a reply to message #291618]

Sat, 05 January 2008 08:53

varu123
Messages: 754
Registered: October 2007

Senior Member

Oracle 8??
Why do you hate 9i and 10g?
Connect as sysdba from sqlpus promt.
conn /as sysdba
issue :
startup

Report message to a moderator

Re: regarding oracle database [message #291620 is a reply to message #291618]

Sat, 05 January 2008 08:54

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1. first check database status.
connect with sys user.
select status from v$instance;

IF mount, nomount then first shutdown database then startup.

connect with sys user.
SQL>shutdown immdiate;
....
SQL>startup

Report message to a moderator