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

Hi,
You should run svrmgrl (server manager line-mode) to start/stop instance, not with sqlplus.

Yang
from Paris.

Xuequn Xu wrote in message <8brd7u$pgu_at_gap.cco.caltech.edu>...
>Add yourself to the dba group. If there is not such a group, create
>one. Then connect internal in sqlplus. It should not ask for password.
>
>"Robert" Xuequn Xu, Oracle DBA
>Caltech, Pasadena, CA 91125
>
>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.
Received on Thu Mar 30 2000 - 00:00:00 CST