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

Robert,

        actually the oracle user is a memeber of the dba group, but its not its primary group. The primary group is oinstall. I just tried changing oracle's primary group to dba (and added oinstall as a secondary group). No change. I still can't connect internal. Note: all the files are owned by oracle:oinstall (as oppposed to oracle:dba). I don't know if this is correct or not, or if it has any affect.

• Ed Wang

In article <8brd7u$pgu_at_gap.cco.caltech.edu>, xux_at_informa.bio.caltech.edu (Xuequn Xu) wrote:
> 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.
>

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