Home » RDBMS Server » Server Administration » ORA-01034 Error
ORA-01034 Error [message #135094] Mon, 29 August 2005 20:56 Go to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

Dear Sir,

I am new in Oracle. I have installed oracle on Windows 2003 Server. The oracle version is 8.1.6.0.0. When i installed it, it works fine. But when i have restarted my computer. It gives the error ORA-01034 Oracle Not available.

How to solve it. I have installed the oracle 3 times due to this only but every time I faced the same problem.

Please help me urgently as i am stuck due to it.

Thanks in advance.

Samit Gandhi
Re: ORA-01034 Error [message #135119 is a reply to message #135094] Tue, 30 August 2005 00:32 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
oracle service is not running & hence databse is not open.

For starting.. since you are using win2003, make oracle services startup automatically at system startup, listener & SID service for oracle in admin-services panel.

or

manually start the listener by using: lsnrctl start command on cmd prompt & then starting the sid service by using: oradim -startup -sid <sidname> at the command prompt.

Regds
Girish

Previous Topic: ORA-1207 (8.1.7)
Next Topic: How to increase sga
Goto Forum:
  


Current Time: Sun Jan 26 11:20:50 CST 2025