- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Inssuficient previleges ERROR
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
тАО09-26-2006 09:33 PM
тАО09-26-2006 09:33 PM
Im having the folowwing problem with my database:
- As oracle user when i try to connect with: conn sys as sysdba
password: xxx
connected.
It seems to be ok. But when trying to connect with: conn / as sysdba
password: xxx
ERROR:
ORA-01031: insufficient privileges
I have trying to solve this but cant do, so need help. The user oracle have all the permissions so i dont understand why it says insufficint privileges.
I need to connect like this because the dbshut scipt try to connect as / and it cant shutdown the database automatically, and i need to do that.
Any idea, please?
Best Regards
Pinki
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-26-2006 09:49 PM
тАО09-26-2006 09:49 PM
Re: Inssuficient previleges ERROR
I ran into this a year ago. The oracle password file a security file that permits database access is missing or has ownership other than the database binary owner on it.
http://www.adp-gmbh.ch/ora/admin/password_file.html
http://www.orafaq.com/faqdbase.htm
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-26-2006 10:17 PM
тАО09-26-2006 10:17 PM
Re: Inssuficient previleges ERROR
If i create the password file, then when i connect with: conn / as sysdba it will prompt me for the password.
But i need a login without a password prompt. conn / as sysdba is supposed to login without a password. Thats why the dbshut script uses conn / as sysdba to login and shutdown.
So im little confused how to login without password.
Best Regards.
And thanks once again.
Pinki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2006 03:49 AM
тАО09-27-2006 03:49 AM
SolutionAmong several ways you can connect to the Oracle database, what you want to achieve is OS authentication, so no password file is needed for this.
When you issue 'CONNECT / AS SYSDBA' Oracle checks if your Unix account belongs to the OSDBA group, and if so then you are allowed to connect to the database.
OSDBA and OSOPER are defined at installation time. You can check what these groups are in $ORACLE_HOME/rdbms/lib/config.c
Let's assume the group is 'dba'. So in order for a OS user 'sam' (so to speak) to be able to 'conn / as sysdba', he should belong to the dba group. See example below. Also, notice that in doing so, sam will get connected as SYS user.
[root@archost ~]# id sam
uid=502(sam) gid=507(sam) groups=507(sam)
[root@archost ~]# su - sam
[sam@archost ~]$ export ORACLE_SID=ARC
[sam@archost ~]$ export ORACLE_BASE=/u01/dba/app/oracle
[sam@archost ~]$ export ORACLE_HOME=/u01/dba/app/oracle/product/10.2.0
[sam@archost ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[sam@archost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Sep 27 11:32:33 2006
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
[sam@archost ~]$ logout
[root@archost ~]# usermod -G dba sam
[root@archost ~]# id sam
uid=502(sam) gid=507(sam) groups=507(sam),505(dba)
[root@archost ~]# su - sam
[sam@archost ~]$ export ORACLE_SID=ARC
[sam@archost ~]$ export ORACLE_BASE=/u01/dba/app/oracle
[sam@archost ~]$ export ORACLE_HOME=/u01/dba/app/oracle/product/10.2.0
[sam@archost ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[sam@archost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Sep 27 11:30:33 2006
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> sho user
USER is "SYS"
SQL> select logins, status, instance_name
2 from v$instance;
LOGINS STATUS INSTANCE_NAME
---------- ------------ ----------------
ALLOWED OPEN ARC
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
[sam@archost ~]$ logout
Hope this clarifies,
-Ariel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-28-2006 04:56 AM
тАО09-28-2006 04:56 AM
Re: Inssuficient previleges ERROR
Really the user i was trying to connect ( oracle ) was belong only to the oinstall and osoper group and not dba group. It was my mistake, i just dont know how, but during the installation the user created have to belong to the dba group and i have done mistake and it was not.
so i have done:
usermod -G dba oracle, and then trying to connect "conn / as sysdba", it get connected.
Thanks a lot.
Best Regards
Pinki