Home » RDBMS Server » Server Administration » regarding oracle database
regarding oracle database [message #291618] Sat, 05 January 2008 08:48 Go to next message
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.
Re: regarding oracle database [message #291619 is a reply to message #291618] Sat, 05 January 2008 08:53 Go to previous messageGo to next message
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
Re: regarding oracle database [message #291620 is a reply to message #291618] Sat, 05 January 2008 08:54 Go to previous messageGo to next message
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

Re: regarding oracle database [message #291621 is a reply to message #291618] Sat, 05 January 2008 08:57 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
when the error is oracle initialisation or shutdown in process
i doubt if any select statement would work?
Re: regarding oracle database [message #291622 is a reply to message #291621] Sat, 05 January 2008 09:13 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Sys user able to connect.
Re: regarding oracle database [message #291639 is a reply to message #291618] Sat, 05 January 2008 10:51 Go to previous message
varu123
Messages: 754
Registered: October 2007
Senior Member
yes sys user can connect.
sqlplus /no log
conn / as sysdba
Previous Topic: Temp file size
Next Topic: cdump...?
Goto Forum:
  


Current Time: Sat Dec 03 01:20:20 CST 2016

Total time taken to generate the page: 0.09847 seconds