Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after 
Author Message
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after

Shutting down server using standby or hibernate does not cause a problem
but as soon as server has been restarted once Oracle will never work
again!

I have tried reinstalling Oracle and creating a new database. Connected
to the database successfully using Toad and sqlplus. Place server on
standby and then restart server can still connect using Toad. Placed
server in Hibernate and restarted and can still connect using Toad.
Restart server and get the "Oracle not available" message. This
behaviour is consistent.



Thu, 23 Oct 2003 15:42:25 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after


Quote:

> Shutting down server using standby or hibernate does not cause a
problem
> but as soon as server has been restarted once Oracle will never work
> again!

> I have tried reinstalling Oracle and creating a new database.
Connected
> to the database successfully using Toad and sqlplus. Place server on
> standby and then restart server can still connect using Toad. Placed
> server in Hibernate and restarted and can still connect using Toad.
> Restart server and get the "Oracle not available" message. This
> behaviour is consistent.

Why use the power-saving features for desktop users on a server computer
at all?!! (Didn't even think that it'd exist on "server" versions of
W2k)

Regards,
/Fad



Thu, 23 Oct 2003 21:38:06 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after
Short Question
is your W2K Server a PDC? - if it it's a known problem -- install your
Server
as a standalone Server and it would work! (in oradim.log is there a error
ORA-????? can't start authentication adapter or so?)

bye
Andr



Quote:

> Shutting down server using standby or hibernate does not cause a problem
> but as soon as server has been restarted once Oracle will never work
> again!

> I have tried reinstalling Oracle and creating a new database. Connected
> to the database successfully using Toad and sqlplus. Place server on
> standby and then restart server can still connect using Toad. Placed
> server in Hibernate and restarted and can still connect using Toad.
> Restart server and get the "Oracle not available" message. This
> behaviour is consistent.



Thu, 23 Oct 2003 22:39:18 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after
I am running Oracle on a laptop for my personal use and frequently use the
power-save features although as you can see these are not causing the
problems.. The o/s is w2k Professional.
Quote:



> > Shutting down server using standby or hibernate does not cause a
> problem
> > but as soon as server has been restarted once Oracle will never work
> > again!

> > I have tried reinstalling Oracle and creating a new database.
> Connected
> > to the database successfully using Toad and sqlplus. Place server on
> > standby and then restart server can still connect using Toad. Placed
> > server in Hibernate and restarted and can still connect using Toad.
> > Restart server and get the "Oracle not available" message. This
> > behaviour is consistent.

> Why use the power-saving features for desktop users on a server computer
> at all?!! (Didn't even think that it'd exist on "server" versions of
> W2k)

> Regards,
> /Fad



Fri, 24 Oct 2003 01:09:37 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after
What is a PDC? o/s is w2k professional and is running on a Dell laptop, hence
the use of power-save options, although these do not cause the problem. Only a
rebott does.

There is no oradim.log file on my file system.

Thanks
Aaron

Quote:

> Short Question
> is your W2K Server a PDC? - if it it's a known problem -- install your
> Server
> as a standalone Server and it would work! (in oradim.log is there a error
> ORA-????? can't start authentication adapter or so?)

> bye
> Andr



> > Shutting down server using standby or hibernate does not cause a problem
> > but as soon as server has been restarted once Oracle will never work
> > again!

> > I have tried reinstalling Oracle and creating a new database. Connected
> > to the database successfully using Toad and sqlplus. Place server on
> > standby and then restart server can still connect using Toad. Placed
> > server in Hibernate and restarted and can still connect using Toad.
> > Restart server and get the "Oracle not available" message. This
> > behaviour is consistent.



Fri, 24 Oct 2003 01:14:44 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after

Quote:
> Shutting down server using standby or hibernate does not cause a problem
> but as soon as server has been restarted once Oracle will never work
> again!

Power-saving features mess up computers all the time, and not just the
Oracle server.  It;s worth it to just turn it off.


Fri, 24 Oct 2003 02:48:50 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after
Power saving os not causing the problem - a clean reboot is!
Quote:

> > Shutting down server using standby or hibernate does not cause a problem
> > but as soon as server has been restarted once Oracle will never work
> > again!

> Power-saving features mess up computers all the time, and not just the
> Oracle server.  It;s worth it to just turn it off.



Fri, 24 Oct 2003 05:05:16 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after
On Sun, 06 May 2001 08:42:25 +0100, Phil McAvity

Quote:

>Shutting down server using standby or hibernate does not cause a problem
>but as soon as server has been restarted once Oracle will never work
>again!

>I have tried reinstalling Oracle and creating a new database. Connected
>to the database successfully using Toad and sqlplus. Place server on
>standby and then restart server can still connect using Toad. Placed
>server in Hibernate and restarted and can still connect using Toad.
>Restart server and get the "Oracle not available" message. This
>behaviour is consistent.

Sounds like a well-known bug in 8.1.6 corrected in patches 8.1.6.3.4
The service actually starts, but the process freezes when mounting
database.

try in srvmgrl
connect internal
and
startup

With the known bug this usually succeeds. I have forgotten whether you
have to change the autostart for the database  in registry to false
before doing this.

I saw a message that the bug has reappeared in 8.1.7, but  am not
quite sure about that.

Yours Hans Erik Busk



Sat, 25 Oct 2003 01:43:03 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after

Quote:
>> Shutting down server using standby or hibernate does not cause a problem
>> but as soon as server has been restarted once Oracle will never work
>> again!

>Power-saving features mess up computers all the time, and not just the
>Oracle server.  It;s worth it to just turn it off.

I know it - you know it - the whole world of Oracle & IT staffs know it.
Now try telling the bean counters in charge of the company who see such
features as a way of saving more $$$'s from the companies services budget
inorder to make themselves more $$$'s in annual bonuses every year.

Neil
(not being cynical - more a case of been there, tried to do it)



Sat, 25 Oct 2003 16:28:59 GMT
 Problems with Oracle 8i on W2k - ORA-01034: ORACLE not available - after

Quote:
> Now try telling the bean counters in charge of the company who see such
> features as a way of saving more $$$'s from the companies services budget

Hey we're like the Dilbert cartoons here:  A red alert sounds if someone
outside of I.T. is ever seen with a magazine!  Then the non-IT magazine
holder is given electric shocks until they cannot remember whatever they
just read...


Sun, 26 Oct 2003 21:05:29 GMT
 
 [ 10 post ] 

 Relevant Pages 

1. (ORA-01034: ORACLE not available) problem

2. ORA-01034: ORACLE NOT AVAILABLE

3. HELP!!!! ORA-01034: ORACLE not available

4. ORA-01034: ORACLE not available

5. ORA 01034, ORACLE not available

6. ORA-01034: ORACLE NOT AVAILABLE

7. ORA-01034: ORACLE not available via SQLplus and JDBC

8. ORA 01034 Oracle not available error

9. SQLPLUS - ORA-01034: ORACLE not available

10. ORA-01034: Oracle not Available

11. ora-01034 : oracle not available

12. ORA-01034 : Oracle not available


 
Powered by phpBB® Forum Software