Home » RDBMS Server » Server Administration » ORA-01034:ORACLE not available
ORA-01034:ORACLE not available [message #187706] Tue, 15 August 2006 01:35 Go to next message
pradeep.goyal
Messages: 2
Registered: August 2006
Location: india
Junior Member

Dear Sir,
I really need a help from everybody who good in Oracle !
When the time I login by entering the username and password, I received a error message as stated ORA-01034:ORACLE not available.

error 1053 The service could not respond to the start or control request in a timely fashion.

My OS is Window XP home, and my oracle version is Personal Edition 8.1.6 !

Please give a help, please !

your sincerely,
pradeep

pradeep.goyal@arisglobal.co.in
Re: ORA-01034:ORACLE not available [message #187725 is a reply to message #187706] Tue, 15 August 2006 03:24 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Have you started the Oracle service?

Do you see any errors in the database's ALERT.LOG file?
Re: ORA-01034:ORACLE not available [message #187730 is a reply to message #187725] Tue, 15 August 2006 04:01 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is it a new installation, or did it work properly until now?

Could the source of your problems be the fact that Oracle 8 isn't certified with Windows XP (and, besides that, I don't remember I saw that Oracle works properly on XP Home, only Professional edition).
Re: ORA-01034:ORACLE not available [message #187838 is a reply to message #187730] Tue, 15 August 2006 22:53 Go to previous messageGo to next message
pradeep.goyal
Messages: 2
Registered: August 2006
Location: india
Junior Member

step process of what i did
1. format the system--successfully done
2 install win xp sp2--successfully done
3. install oracle 8i- successfully done.
4. able to use oracle . able to login. no problem what so ever.
5. restart the system.
6. unable to login to ORACLE.
7. ERROR MESSAGE ORA-01034:ORACLE NOT AVAILABLE
Re: ORA-01034:ORACLE not available [message #187848 is a reply to message #187838] Wed, 16 August 2006 00:26 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to start the Oracle database up manually? From the command prompt, follow these commands and see whether you'll get something like this:
C:\oracle\product\10.2.0\db_1\BIN>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Pet Tra 28 09:42:15 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys/pwd as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              75498852 bytes
Database Buffers           88080384 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.
SQL>
Previous Topic: no. of buffers?
Next Topic: full export??
Goto Forum:
  


Current Time: Thu Dec 08 18:05:12 CST 2016

Total time taken to generate the page: 0.05098 seconds