Re: Oracle 9i problem

unbreakablematrix_at_yahoo.com (Cherrish Vaidiyan) wrote in message news:<f037d974.0312122144.6729be5_at_posting.google.com>...
> > news:db1f3a11.0312040825.3861332b_at_posting.google.com:
> >
> > > 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. Received on Wed Dec 17 2003 - 21:29:43 CET