Re: Please Help :(

Sneff Gabor wrote:

> Hi All,
>
> I have a problem and I wonder if you could help me:
> I have a W2k server English standalone + oracle 8i. It'd worked until
> I made a DC out of this server. After the restart the oracle didn't
> start. All the services were running, but I couldn't connect to the
> database.
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
>
> the amount of memory is ok, services are running, the database exists,
> everything is ok seemingly.
> If I try to log in with a user, oracle says: ORA-01031: insufficient
> privileges.
>
> What can be the problem? Do you have any idea?
>
> Plese Help :(
> Thanks: Gabor Sneff
> snefi_at_freemail.hu

Open a DOS window. Navigate to the bin directory under ORACLE. Do the following:

lsnrctl status

If the listener is started, I expect it is, you should get back the amount of time it has been running. If not copy and keep the entire error message.

Then start the database by following these steps:

svrmgrl
connect internal
startup

If you get any error messages once again copy them completely.

If it appears the database is running try this query:

SELECT COUNT(*)
FROM tab$;

to verify that it is.

Exit server manager by typing EXIT.

If the database is up and running and you still can not connect using SQL*Plus I'd suspect the environment variables ORACLE_HOME and ORACLE_SID are not set.

Daniel Morgan Received on Sun Jan 26 2003 - 12:07:15 CST