Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can't stop/start 8iEE (8.1.6)
I don't seem to have the right permission to stop/start the Oracle DB.
I downloaded the trial version of Oracle 8iEE (8.1.6) for Solaris (2.7) last week. I installed it and everything went fine. I could connect to it via SQL*Plus and create tables, insert data, etc.
Over the weekend, we had a power outage and the Sun box went down. On Monday, I tried to startup the DB using dbstart. No luck, and dbstart doesn't throw any errors either. Looking at the dbstart script, I can see it will never work as is because it doesn't grab the version correctly. So I tried to execute the commands contained in dbstart by hand:
bash-2.03$ sqlplus /nolog
SQL*Plus: Release 8.1.6.0.0 - Production on Mon Mar 27 10:56:27 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> connect internal
Enter password:
ERROR:
ORA-01031: insufficient privileges
SQL> startup
ORA-01031: insufficient privileges
SQL> quit
bash-2.03$
I tried the password for SYS, SYSTEM, oracle and even scott (=tiger). Nothing worked. I also tried using svrmgrl, but it gave the same results. BTW, this was all done as the oracle user (uid=oracle, gid=oinstall,dba).
I though maybe a file was corrupted from the power failure, so I removed
all the oracle files, including the ones in /var. Then I re-installed
Oracle from the trial CD-ROM (the CD's arrived over the weekend). The
install starts the DB for me. But now I can't shut the DB down. I
tried dbshut - no luck and no error. I tried to type the commands
myself:
bash-2.03$ sqlplus /nolog
SQL*Plus: Release 8.1.6.0.0 - Production on Tue Mar 28 11:01:43 2000
(c) Copyright 1999 Oracle Corporation. All rights reserved.
SQL> connect internal
Enter password:
ERROR:
ORA-01031: insufficient privileges
SQL> shutdown
ORA-01012: not logged on
SQL> quit
bash-2.03$
No luck. I don't seem to have the correct password. I didn't change any of the defaults (SYS=>change_on_install; SYSTEM=>manager). Does anyone know what I am doing wrong?
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 28 2000 - 00:00:00 CST