Oracle 9i - startup problem

[Yajuvendra Singh]

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

[Hein van den Heuvel]

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]

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

[Eric Antunes]

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