Home » Infrastructure » Unix » ORA-01031 for Oracle User
ORA-01031 for Oracle User [message #227680] Thu, 29 March 2007 00:49 Go to next message
ankitanshu
Messages: 2
Registered: March 2007
Location: Mumbai
Junior Member
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
Re: ORA-01031 for Oracle User [message #228002 is a reply to message #227680] Fri, 30 March 2007 11:44 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Search for "InstallPrep" script on metalink.
Re: ORA-01031 for Oracle User [message #228199 is a reply to message #228002] Mon, 02 April 2007 01:32 Go to previous message
ankitanshu
Messages: 2
Registered: March 2007
Location: Mumbai
Junior Member
While searching the solution over net, I have found that it is a known Installation bug of Oracle10G and is related to wrong OS file permissions on Oracle folder structure.
The suggested solution is to apply latest Oracle Patch.
Previous Topic: Passing String Arguments to SQL*Plus from a Unix Shell
Next Topic: Write file into Unix
Goto Forum:
  


Current Time: Thu Mar 28 17:13:28 CDT 2024