Shell Programming and Scripting

Hi All,
I am not able to access an oracle table even if the table is present. After initial analysis, found that there is a password warning for the specified oracle user. Can you please help me in ignoring the password expiry and access the oracle table ? However, the log file does not store the password expiry error message, rather it says the table is not found, with ORA-28002 in the DataStage director.

Pls help

If your password has expired, you will have to talk to your Oracle DBA to reset it. You may also want them to set the password life time limit.

If your password is about to expire and you see a warning regarding that, then you'll have to change the password. You can do it yourself if your database user has the "alter user" system privilege.

Hi,
Thanks for the reply. My query is how to ignore the password expiry warning message and access the oracle table using unix. Currently, I am unable to access the oracle table using unix as there is a warning message of password expiry.

May be my earlier message content was bit unclear, let me be more concise. Can we access an oracle table using unix, when there is a warning for password expiry in the db. Password has not expired yet.

I can update the password and access, that's correct.

Fair enough, let me be more concise as well.
Can we access the Oracle table? - yes we can if we have the right client, no we cannot if we have the wrong client.

An example of the right client is sqlplus - the command-line client shipped with Oracle. It displays and bypasses this warning and lands you to the SQL prompt.

An example of the wrong client is sqlldr - it does not load data if that warning is encountered.

Most likely, your client happens to the wrong one.

Can the DBA remove the password expiry warning for the affected account, i.e. set it to zero days?

Just a quick thought.


Robin