PL/SQL Log in database error code and resolution

1.1.1. ORA-12170 Timeout

You need to shut down the firewall and then log back in.

Susefirewall stop

View firewall status

SUSEFIREWALL2 status

1.1.2. ORA-01017

Su-oracle

Sqlplus/as SYSDBA

Alter profile default limit Password_reuse_time unlimited;

Alter profile default limit Passdord_reuse_max unlimited;

Alter user system identified by T_DPWDS8;

1.1.3. ORA-28000 account is locked

Su-oracle

Sqlplus/as SYSDBA

Alter user SYSTEM accout unlock;

1.1.4. ORA-03113

Su-oracle

Sqlplus/as SYSDBA

Kill the database process:

Alter system kill session ' 919 ';

1.1.5. ORA-12541 not listening program

Lsnrctl status Tdsysdba view listening status

Lsnrctl start tdsysdb boot listener

If the following information is displayed, indicating that the database listener is started, but the database service is not started, run the following command to start the database service.

The listener supports no sercices

TH command completed successfully

Hwsqlplus/nolog

Sql>conn/as SYSDBA

Sql>startup

Sql>quit

PL/SQL Log in database error code and resolution