Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Getting this error in oracle ORA-01031 insufficient privilages

shashidhar.v
Regular Advisor

Getting this error in oracle ORA-01031 insufficient privilages

Hi All,

I am getting the error in the orcle9.2.06 on HP-UX11.11. When i do a su -oracle and sqplus /nolog it will take me to the sql prompt but here when i type

connect sys as sysdba

it give me this error
ORA-01031 insufficient privilages.

The listner is also not sarting and the database is also not started. This happened suddenly this morning.

Any lg files which may help me to find out what might have caused this problem?



Regards,
Shashi
13 REPLIES
Vladimir Fabecic
Honored Contributor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Try this
# sqlplus /nolog
connect / as sysdba
In vino veritas, in VMS cluster
shashidhar.v
Regular Advisor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Hi,

I tried this also but the same result.


Regards,
Shashi
Ninad_1
Honored Contributor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Check the file permissions for oracle
-rwsr-s--x 1 oracle dba 77824448 Nov 19 2004 /opt/oracle/product/9
.2.0.6/bin/oracle

Otherwise set
chmod 6751 /opt/oracle/product/9.2.0.6/bin/oracle


Regards,
Ninad
shashidhar.v
Regular Advisor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Hi,

The oracle permissions are correct.


Regards,
Shashi
Vladimir Fabecic
Honored Contributor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Is the same problem with
connect sys/password as sysdba
In vino veritas, in VMS cluster
Svetoslav Gyurov
Valued Contributor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Hi,

First check if your oracle environment variables are set correctly and second edit sqlnet.ora and check if you have enabled parameter sqlnet.authentication_services, if you do comment it and try again. Regards.

--
sve
shashidhar.v
Regular Advisor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Hi,

I checked the sqlnet.ora file we have no uch entry in it.

I rechecked all the environment variables all are correct. One good news is that the listner is starting but not the database.

We changed the hostname to ip address of the server in the tnsnamer.ora and the listner started. But we get the same error when we try to login to sqlplus to start the database.

Regards,
Shashi
Vladimir Fabecic
Honored Contributor

Re: Getting this error in oracle ORA-01031 insufficient privilages

My previous post was related to Svetoslav's idea.
Long time ago I had problem with Oracle because someone changed /etc/host entry for hostname. Sounds stupid but you can check network settings also.
In vino veritas, in VMS cluster
shashidhar.v
Regular Advisor

Re: Getting this error in oracle ORA-01031 insufficient privilages

Hi,

I have placed the I address of the server in the tnsnames.ora file instead of the hostname after this the listner started But the oracle is not starting i am getting the same ORA-01031 error when i try to connect to it.

Regards,
Shashi
spex
Honored Contributor

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
TwoProc
Honored Contributor

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
Joseph C. Denman
Honored Contributor

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...
If I had only read the instructions first??
Patti Johnson
Respected Contributor

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