Oracle 9i problem

[NTidd]

Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:

sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup

Then it starts up and works fine for another day or so.

This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.

Any ideas?

[Hans Forbrich]

NTidd wrote:

Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:

sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup

Then it starts up and works fine for another day or so.

This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.

Any ideas?

Windows 2000 Server? Oracle9i Release 1?

(I'd certainly be looking at upping the memory a bit - I'd expect
512M/CPU, but that's likely off topic!)

In the above you do not need to shutdown. It's already shut down,
recognizable by the 'connected to an idle instance' message and the
reason for the ORA-01034/27101. (Nothing wrong with your procedure
though.)

TSTO - something's terminating the Oracle instance. Any chance you've
got Windows Update running and rebooting the machine automatically? Or
some other utility? Do you have Oracle's services auto-starting after
reboot? What else is running on the machine? Is there a job
consistently running immediately prior to the 'crash'? Can you monitor
for memory leaks?

[NTidd]

Hmm, Windows update is set to run and install updates I believe, but
not to reboot. This is release 1 from oracle. We initially thought
that it was the backups but the backups run at midnight, and sometimes
users can connect up to about 9:00 am before it crashes. After reboot
everything starts up and works as it should, the server is running
sp4. About the only other thing running on this machine is iis and an
online app that uses oracle.

Hans Forbrich <fo******@yahoo.net> wrote in message news:<3F***************@yahoo.net>...

NTidd wrote:

Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:

sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup

Then it starts up and works fine for another day or so.

This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.

Any ideas?

Windows 2000 Server? Oracle9i Release 1?

(I'd certainly be looking at upping the memory a bit - I'd expect
512M/CPU, but that's likely off topic!)

In the above you do not need to shutdown. It's already shut down,
recognizable by the 'connected to an idle instance' message and the
reason for the ORA-01034/27101. (Nothing wrong with your procedure
though.)

TSTO - something's terminating the Oracle instance. Any chance you've
got Windows Update running and rebooting the machine automatically? Or
some other utility? Do you have Oracle's services auto-starting after
reboot? What else is running on the machine? Is there a job
consistently running immediately prior to the 'crash'? Can you monitor
for memory leaks?

[Wizardo]

NT***@douglas-associates.com (NTidd) wrote in
news:db**************************@posting.google.c om:

Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:

sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup

Then it starts up and works fine for another day or so.

This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.

Any ideas?

What are the last 20-30 lines of the alrtSID.log file? This will
give you a clue if the DB is falling over because of itself or
because of an outside influence. If the log file just stops,
that is to say that everything's normal until it breaks, then
there in an outside process killing the DB. If the log file
reports errors, like ORA-00600 or ORA-07745, then you need to
research those errors and see why Oracle is falling over.

Good Luck,
Mike

[Cherrish Vaidiyan]

> news:db**************************@posting.google.c om:

Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:

sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup

Then it starts up and works fine for another day or so.

This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.

Any ideas?

HELLO,
I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS
SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE
INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR
LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS
NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.

REGARDS,
CHERRISH VAIDIYAN

[Frank]

Cherrish Vaidiyan wrote:

HELLO,
I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS
SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE
INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR
LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS
NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.

REGARDS,
CHERRISH VAIDIYAN

Would you mind:
- not shouting?
- learn to spell?
--
Regards, Frank van Bortel

[NTidd]

un***************@yahoo.com (Cherrish Vaidiyan) wrote in message news:<f0*************************@posting.google.c om>...

news:db**************************@posting.google.c om:

Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:

sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup

Then it starts up and works fine for another day or so.

This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.

Any ideas?

HELLO,
I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS
SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE
INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR
LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS
NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.

REGARDS,
CHERRISH VAIDIYAN

Yep, that is amazing, simply amazing. Anyways found out that there
was a miscommunication with one of my fellow coworkers, and it appears
to be a backup exec problem. Thanks for the help.

[NTidd]

un***************@yahoo.com (Cherrish Vaidiyan) wrote in message news:<f0*************************@posting.google.c om>...

news:db**************************@posting.google.c om:

Since we have upgraded to oracle 9i every day or so we have to go in
and shutdown oracle and restart it, here is what we do:

sqlplus /nolog
connect sys as sysdba
password:
connected to an idle instance
shutdown
ORA-01034 Oracle not available
ORA-27101 Shared memory realm does not exist
startup

Then it starts up and works fine for another day or so.

This is running on a Windows 2000 machine with 512mb ram, 2 1.8GHz
processors.

Any ideas?

HELLO,
I AM JUST AMAZED TO SEE THAT U LOGIN TO ORACLE USING SYS AS
SYSDBA.THEN U GIVE SHUTDOWN COMMAND. Y?? IF IT IS CONNECTED TO IDLE
INSTANCE THEN DO GIVE 'STARTUP' COMMAND.aLSO SEE IT TO IT THAT UR
LISTENER IS ALSO STARTED. IT MAYBE COZ UR ORACLE DATABASE SERVICE IS
NOT GIVEN AUTOMATICALLY IN THE aDMINISTATION TOOL>SERVICES.

REGARDS,
CHERRISH VAIDIYAN

Yep, that is amazing, simply amazing. Anyways found out that there
was a miscommunication with one of my fellow coworkers, and it appears
to be a backup exec problem. Thanks for the help.