Re: Can't stop/start 8iEE (8.1.6)

OK, to anyone who is interested... I just got the solution from Oracle support. I had TWO_TASK set on the server. As soon as I unset it, everything worked.

• Ed Wang

In article <8br4pl$od0$1_at_nnrp1.deja.com>, gnawed_at_my-deja.com wrote:
> 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?
> - Ed Wang
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 30 2000 - 00:00:00 CST