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