cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i - startup problem

Oracle 9i - startup problem

The Problem: When attempting to run dbstart I receive an "Insufficient Privileges" error.

The Pertinent Information:

- Database: Oracle 9i, Release 2 (9.2.0.1.0)

- OS: HP-UX 11.11i

- Logon user|group: oracle dba

- SYS password: oracle

- SPFILE contains remote_login_passwordfile=EXCLUSIVE

- The file $ORACLE_HOME/dbs/orapwSID was created by the Oracle Installer.

- From sqlplus /nolog:

o connect sys/oracle as sysdba (works)

o connect / as sysdba (does not work and returns an Insufficient Privileges error. Of course, this is the logon form that dbstart also uses.)

Any tips/suggestions on this issue will be helpfull to me.

Regards,
Yajuvendra Singh


3 REPLIES
Hein van den Heuvel
Honored Contributor

Re: Oracle 9i - startup problem

Did it ever work or is this a fresh install?

Sounds to me like Oracle is working but maybe not exactly as you expected.

The 'connect user/pass' seems to work which maps onto a "create/alter user X identified by Y".

The "connect /" takes the OS identified user name and tries to use that as per "create/alter user X identified EXTERNALLY"
Traditionally this involved a username prefix like OPS$ as defined by OS_AUTHENT_PREFIX.

>> Any tips/suggestions on this issue will be helpfull to me.

RTFM!
Read The `Fine' Manuals.

Notably check the Oracle DBA Manual,
Chapter 24, sub "User Authentication Methods"

Good luck,
Hein.
Steven E. Protter
Exalted Contributor

Re: Oracle 9i - startup problem

Shalom,

Seems that the Oracle environment may be wrong here.

what is ORACLE_HOME and ORACLE_SID prior to running sqlplus?

Please check the alert log.

Problems like this sometimes come from incomplete or incorrect setting of the environment.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Eric Antunes
Honored Contributor

Re: Oracle 9i - startup problem

Hi Yajuvendra,

That's excatly this parameter that's preventing you to start the database. See Metalink Note 216205.1 about Oracle 9i init parameters.

Best Regards,

Eric Antunes
Each and every day is a good day to learn.