- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Getting this error in oracle ORA-01031 insuffi...
Operating System - HP-UX
1755927
Members
3098
Online
108839
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
тАО06-05-2006 02:06 AM
тАО06-05-2006 02:06 AM
Re: Getting this error in oracle ORA-01031 insufficient privilages
When you run 'sqlplus' from the OS, the communication pathway is established with interprocess communication. In other words, you bypass 'tnsnames.ora', and as long as your user is a member of the dba group, you will be able to connect as sysdba. In order to test changes to your Oracle listener config, you need to connect from a client workstation, or run 'tnsping ' from the server or a client.
If your Oracle instance isn't running, you must start there. First determine what caused the instance to go down, then get it running again. Once it's running, then you can make changes to 'tnsnames.ora', if you need to. Please post the output of 'ps -ef |grep pmon'.
Consult alertlog:
$ORACLE_BASE/admin//bdump/alert_.log
You might also want to have a look at listener.log:
$ORACLE_HOME/network/log/listener.log
You should also check for hardware errors in syslog:
/var/adm/syslog/syslog.log
If your Oracle instance isn't running, you must start there. First determine what caused the instance to go down, then get it running again. Once it's running, then you can make changes to 'tnsnames.ora', if you need to. Please post the output of 'ps -ef |grep pmon'.
Consult alertlog:
$ORACLE_BASE/admin/
You might also want to have a look at listener.log:
$ORACLE_HOME/network/log/listener.log
You should also check for hardware errors in syslog:
/var/adm/syslog/syslog.log
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2006 04:36 AM
тАО06-05-2006 04:36 AM
Re: Getting this error in oracle ORA-01031 insufficient privilages
Make sure you belong to the group indicated in the file $ORACLE_HOME/rdbms/lib/config.c. If your user not in the dba group (/etc/groups) indicated in this file, you'll have exactly the problem you're seeing. Also run the unix command "groups" to see what groups you belong to.
We are the people our parents warned us about --Jimmy Buffett
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2006 05:00 AM
тАО06-05-2006 05:00 AM
Re: Getting this error in oracle ORA-01031 insufficient privilages
Check to make sure the Database was not started by someone other than oracle.
ps -ef | grep lgwr
I had a similar problam once and one of the DBA's had started the instance as a different user.
...jcd...
ps -ef | grep lgwr
I had a similar problam once and one of the DBA's had started the instance as a different user.
...jcd...
If I had only read the instructions first??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-05-2006 08:36 AM
тАО06-05-2006 08:36 AM
Re: Getting this error in oracle ORA-01031 insufficient privilages
Do you have a TWO_TASK environment variable set to a remote database?
ORACLE_SID should be set to the SID you are trying to start - and TWO_TASK should not be set.
Patti
ORACLE_SID should be set to the SID you are trying to start - and TWO_TASK should not be set.
Patti
- « Previous
-
- 1
- 2
- Next »
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP