TNSPING, How and Why
TNSPING Utility tnsping is a network testing utility provides by Oracle to test the availability of listener through the substrate of Oracle Net. Somebody may… Read More »TNSPING, How and Why
Network
How to Resolve ORA-12560 on Windows Server
ORA-12560 In this post, I'll talk about several error patterns of ORA-12560 on Windows platform. Database service is stop (SYSDBA) Listener service is stop (Normal… Read More »How to Resolve ORA-12560 on Windows Server
How to Resolve ORA-01034: ORACLE not available
ORA-01034 ORA-01034 means that the command you want to perform cannot be done in a stop, idle or shutdown database. If you're surprised by the… Read More »How to Resolve ORA-01034: ORACLE not available
How to Resolve ORA-12170: TNS:Connect timeout occurred
ORA-12170 At some points, the client sides received intermittent ORA-12170 repeatedly: ORA-12170: TNS:Connect timeout occurred Meanwhile, the server side did not receive any errors either… Read More »How to Resolve ORA-12170: TNS:Connect timeout occurred
How to Resolve ORA-12519: TNS:no appropriate service handler found (DBD ERROR: OCIServerAttach)
ORA-12519 in Enterprise Manager Found ORA-12519 when trying to connect to the database by using dbconsole
How to Resolve ORA-12537:TNS:connection closed
ORA-12537 Overview There're several possible causes to raise ORA-12537: Incorrect File Permission White or Black List ORA-12537 Caused by Incorrect File Permission Incorrect file permission… Read More »How to Resolve ORA-12537:TNS:connection closed
How to Set Client-Side Transparent Application Failover (TAF)
Transparent Application Failover (TAF) Besides connect-time failover to the standby database, there is a function called Transparent Application Failover (TAF) can do run-time failover to… Read More »How to Set Client-Side Transparent Application Failover (TAF)
How to Resolve ORA-3136 Inbound Connection Timed Out
ORA-3136 At times, some users complained about connection timeout, and you saw error messages ORA-3136 in sqlnet.log as such: Fatal NI connect error 12170. … Read More »How to Resolve ORA-3136 Inbound Connection Timed Out
How to Connect Idle, Nomount or Restricted Database Remotely
Connect an Idle, Nomount or Restricted Database Locally Users who belong to OSDBA or OSOPER can access a database in any states including idle, NOMOUNT… Read More »How to Connect Idle, Nomount or Restricted Database Remotely