If you are on Unix

check the name of your password file and the name if your sid

Make sure the sid's case matches that of the environment variable ORACLE_SID. If the environment for ORACLE_SID is set to ORACLE_SID=TEST and the password file is name is orapwtest then you would encounter the ORA-01990.


You can also try recreating the password file using the orapwd utility.

[Edited by ronnie on 05-10-2002 at 04:52 PM]