Re: cannot connect to oracle

Rob,

I believe that the service is started, but the instance is not started. Why not dig in with Server Manager?

C:\> set oracle_sid=<your_sid>

C:\> svrmgrl

SVRMGR> connect / as sysdba
connected.

SVRMGR> startup

if at this point, you receive an error indicating that the initialization file has not been found, use the pfile=<full_path> e.g.

SVRMGR> startup pfile='D:\Oracle\Admin\DEV\pfile\initDEV.ora'

If the user account does not belong to the group ORA_DBA, use

SVRMGR> connect internal/<password>

hth,

Paul

Rob wrote:
>
> Hi everyone,
>
> i have been using for 2 months now oracle 8.1.7. on a windows2000 system
> without any problems.
> Since yesterday though i cannot connect to oracle. The error messages are
> the following:
> - ORA-01034: ORACLE not available
> - ORA-27101:Shared memory realm does not exist
>
> Windows was shut down in a normal way yesterday, nothing has been changed
> and today, out of the
> blue, these errors appeared.
> I don't get any wiser from the solutions, given by the error messages.
>
> I've stopped and started all oracle services, but I still can't connect :(
>
> Does anyone have any idea what could have caused this? and better yet, how
> can I solve this problem?
>
> Thanx in advance,
> Rob
Received on Sat Sep 22 2001 - 10:03:55 CDT