startup database [message #50735] |
Wed, 03 April 2002 21:04 |
René Jaunik
Messages: 4 Registered: April 2002
|
Junior Member |
|
|
Please can you help me.
I did the installation 2 times and had the same problems.
I installt Oracle 8.1.7 (Windows 2000, Sp2)
and was logged on as sys, system, scott, ...
Now I restartet the computer and I can't start
the database.
My Tries
dba Studio:
In the Studio I can log on with system.
But when I start the Database it runs 2 secounds and
stop. No error is shwon.
SQL*Plus Worksheet:
if I say
connect system/manager as sysdba
i got the message
ERROR:
ORA-01031: insufficient privileges
If I say
connect system/manager
or
startup
i got the message
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
|
|
|
Re: startup database [message #50737 is a reply to message #50735] |
Wed, 03 April 2002 23:22 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
In Windows2000/Windows NT, first thing is to makesure Oracle Service is startup (difference than Unix). Below is startup command
NET START OracleServiceSID.
NET STOP OracleServiceSID.
and setting this service to automatic startup when OS is startup. Hope this is helping
|
|
|
Re: startup database [message #50745 is a reply to message #50735] |
Thu, 04 April 2002 04:27 |
Helena
Messages: 42 Registered: February 2002
|
Member |
|
|
Did you check if services are running? Make sure that the TNS is running and the oracle SID....
Also try on your DOS command line the following:
svrmgrl
connect internal
startup force
if this gives you a error message like instance running
do this:
svrmgrl
connect internal
shutdown abort
then startup force
good luck
helena
|
|
|
|
Re: startup database [message #50749 is a reply to message #50737] |
Thu, 04 April 2002 07:57 |
Wei Lang
Messages: 23 Registered: March 2002
|
Junior Member |
|
|
Try this:
sqlplus /nolog
SQLPLUS> connect internal
SQLPLUS> startup
If you can not start it, plus post the error message
Thanks,
Wei
|
|
|
Re: startup database [message #50762 is a reply to message #50737] |
Thu, 04 April 2002 21:50 |
René Jaunik
Messages: 4 Registered: April 2002
|
Junior Member |
|
|
C:>sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production...
(c) Copyright 2000...
SQL>connect internal
ERROR:
ORA-01031: insufficient privileges
mfg René
|
|
|
|
|
Re: startup database [message #51203 is a reply to message #50735] |
Tue, 07 May 2002 02:15 |
irfan
Messages: 19 Registered: July 2001
|
Junior Member |
|
|
if your oracle server cannot recognize 'sys' and 'system' built-in users, the problem is severe. you may have to re-install the software again. ensure to clean your Registry for previous installation's paths and/or entry and do fresh installation, and if available, with a fresh CD
and if it still doesn't works, forget using Oracle ... lol
|
|
|
|