| Oracle is not getting started. [message #130749] |
Tue, 02 August 2005 04:54  |
jerinvjose
Messages: 23
Registered: May 2005
Location: Mumbai
|
Junior Member |
|
|
Hii all
I installed Oracle 9i on an Windows XP machine.
After that i tested Oracle and even i created a new user also.
But after few days, whenever i m trying to start SQL
it is telling Oracle Shutdown or Initialization is in Progress.
So now i m not able to use Oracle,
Wat i can do now???
If anybody knows solution for this,
plzzzzz
thnx in advance..
Bye
Jerry..
|
|
|
|
|
|
| Re: Oracle is not getting started. [message #130888 is a reply to message #130757] |
Wed, 03 August 2005 01:39  |
jerinvjose
Messages: 23
Registered: May 2005
Location: Mumbai
|
Junior Member |
|
|
Hii tarun,
thnx for the reply,
but i m facing the problem everytime.
And even i restrted the Oracle Services, but this also didnt help me..
I tried top login as DBA but, the result is same...
Should i need to reinstall Oracle..
Hmm
Wat to do?
Jerry..
|
|
|
|
| Re: Oracle is not getting started. [message #130892 is a reply to message #130888] |
Wed, 03 August 2005 01:47 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi jerry,
Lets give us one more try from my side. Anyways dnt haste to reinstall Oracle cos there are some big gurus on this site and they r definitely going to help u out.
Meanwhile try my solution,
Startup & shutdown ur database manually .
After starting ur machine , login as sysdba and
SQL > startup
before shutting down ur machine , login as sysdba and
SQL> shutdown
( provided no other user is connected to the database otherwise it will wait for the users to disconnect )
Check this out, it might help u.
regards,
tarun
|
|
|
|
| Re: Oracle is not getting started. [message #130910 is a reply to message #130892] |
Wed, 03 August 2005 02:51 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Use shutdown immediate instead of normal shutdown in that case, when other users are connected & you want to shutdown database quickly & also maintain its consistency.
Meanwhile do check one thing... is your database in archive log mode & automatic archiving is enabled?
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
