[Fix]-ORA-12560 Oracle 10g users are expired
ORA-12560 Oracle 10g users are expired
Scenario:
There is an Oracle 10g database connected to another Oracle server with client instance. The users a also sqlpus and instance client are faced with ORA-12560 error (Both servers were good but now I have no connection to data!)
Fix for this error:
Fix 1:
Login to database server as the Oracle owner (with Windows, as ORA_DBA), and set ORACLE_HOME and ORACLE_SID environment variables, then login as:
sqlplus / as sysdba
You can login without a password
Fix 2:
- Go to Command prompt and set Oracle SID
- C:\>set oracle_sid=ORCL
- Thn run the Net start command.
- C:\>net start oracleserviceORCL