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

Thanks for posting the solution.

We get so many questions asked,
with many answers suggested, but
rarely get a public note of what the
problem and solution actually turned
out to be.

(I was about to mail a suggestion
about password files)

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

gnawed_at_my-deja.com wrote in message <8c06dk$d3r$1_at_nnrp1.deja.com>...


>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

>