ORA-01031 for Oracle User

[Ankit Grover]

Hi,

We have HP-UX Itanium B.11.23 IA64 box. Oracle9i was installed on this system under user ORACLE & groups as DBA & OINSTALL.
We wanted to check our application compatibility with Oracle 10G, so we installed Oracle 10G also on the same box with different credentials.

Oracle9i
ORACLE_HOME=/oracle/product/9.2

Oracle10g
ORACLE_HOME=/oracle/product/10g
User is ORACLEG and groups are DBAG & OINSTALLG.
(We have created separate groups on the recommendation of Installation guy.)

Now if I try to login to 10G DB through Oracleg user, I am getting ORA-01031 insufficient privileges error. But the login is working fine with SYS user.

I am suspecting that the problem is beacuse of group name. But I am not sure. Can some expert please help me?

Also, if someone can share his/her expertise of having both 9i & 10g on the same machine, it would be of great help.

Regards,
Ankit

[Peter Godron]

Ankit,
how are you connecting with the oracleg user ?
If you are trying to connect with "/", does the oracle account have connect,resource etc. on the database ?

Please also read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33 on how to reward any useful answers given to your questions.

[SANTOSH S. MHASKAR · Accepted solution]

Hi Ankit,

First of all there was no need to create seperate user (owner of oracle) and group
to install both Oracle 9i and 10g.
One oracle owner (oracle) with primary group
oinstall and suppelementary group dba can
own the oracle 9i and 10g software.
Only thing u need to set ORACLE_HOME properly.

--Now if I try to login to 10G DB through Oracleg user, I am getting ORA-01031 insufficient privileges error. But the login is working fine with SYS user.

Oracleg is OS user OR DB user?
OR u r logging with OPS$USER?
like

SQL> connect /



Now ur error is
-----------------------------------------
[oracle@wfms1] $oerr ora 1031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.

--------------------------------------------

This means u may not be having appropriate previliges.


-SANTOSH

[Yogeeraj_1]

hi Ankit,

make sure you have also exported the appropriate ORACLE_SID

hope this helps too!
kind regards
yogeeraj

[Ankit Grover]

Peter, Santosh & Yogeeraj,
The problem was not with ORACLEG (OS User) privileges or SID. But it had to do with its group name.

As I had mentioned in my first post that the installation guy created new user groups for Oracle10g installation. I was suspecting it but never really tried it.

Today I tried by adding ORACLEG user to DBA group and the things are working fine from Oracleg (OS User) now.

Thanks for ur support.

[Ankit Grover]

The Oracle user should be part of DBA user group to have direct DBA access to databases.
The group name should be DBA for both the users if 9i & 10g installation has been done through differnet oracle users.