- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA-01031 for Oracle User
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 07:36 PM
тАО04-01-2007 07:36 PM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 08:17 PM
тАО04-01-2007 08:17 PM
Re: ORA-01031 for Oracle User
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 09:03 PM
тАО04-01-2007 09:03 PM
SolutionFirst 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-01-2007 11:14 PM
тАО04-01-2007 11:14 PM
Re: ORA-01031 for Oracle User
make sure you have also exported the appropriate ORACLE_SID
hope this helps too!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2007 05:52 PM
тАО04-02-2007 05:52 PM
Re: ORA-01031 for Oracle User
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-02-2007 05:55 PM
тАО04-02-2007 05:55 PM
Re: ORA-01031 for Oracle User
The group name should be DBA for both the users if 9i & 10g installation has been done through differnet oracle users.