| ORA-01031 for Oracle User [message #227680] |
Thu, 29 March 2007 00:49  |
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 #228199 is a reply to message #228002] |
Mon, 02 April 2007 01:32  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
