Getting this error in oracle ORA-01031 insufficient privilages

[shashidhar.v]

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

[Vladimir Fabecic]

Try this
# sqlplus /nolog
connect / as sysdba

[shashidhar.v]

Hi,

I tried this also but the same result.


Regards,
Shashi

[Ninad_1]

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]

Hi,

The oracle permissions are correct.


Regards,
Shashi

[Vladimir Fabecic]

Is the same problem with
connect sys/password as sysdba

[Svetoslav Gyurov]

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]

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]

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.

[shashidhar.v]

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]

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]

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.

[Joseph C. Denman]

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...

[Patti Johnson]

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