User Connectivity Issue in Unix/Oracle 9i

Question

I used to connect oracle db frmo Unix terminal witout providing any password as mentioned below. sqlplus / and it connects to the data base. Now I am facing an error saying "Invalid Userid and Password".

Can someone please provide any pointers on this. Your inputs are higly appreciated, thanks in advance.

Answer 1

If you connect to SQL*Plus using / it means you are using Operating System authentication. Normally this requires your Unix user to be in group "dba" or the equivalent.

See TFM

You can check your groups like this:

$ groups

Also, you probably need to connect as sysdba, e.g.

sqlplus> CONNECT / AS SYSDBA

or AS SYS. Did you forget that?

Another problem can be if the DBA has turned off OS Authentication at the database.