Toad No Valid Oracle Clients Found
At the first time startup of Toad for Oracle, you may want to new a connection to start to use the tool. But sometimes, you… Read More »Toad No Valid Oracle Clients Found
Environment Variables
PL/SQL Developer Initialization error, Oracle Client not properly installed
At the first time startup of PL/SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »PL/SQL Developer Initialization error, Oracle Client not properly installed
tnsnames.ora in SQL Developer
At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »tnsnames.ora in SQL Developer
How to Resolve Unable to launch the Java Virtual Machine Located at path
Unable to launch the Java Virtual Machine Saw an error dialog when I launch SQL Developer for the first time. Unable to launch the Java… Read More »How to Resolve Unable to launch the Java Virtual Machine Located at path
How to Resolve opatchauto must run from one of the homes specified
opatchauto must run from one of the homes specified Met an error when I tried to apply a patch by root. [root@primary01 ~]# opatchauto apply… Read More »How to Resolve opatchauto must run from one of the homes specified
Oracle Client vs Instant Client
Here I list their differences including features, pros and cons for you to evaluate which one should be used for your clients: Oracle Client Features… Read More »Oracle Client vs Instant Client
How to Resolve "tnsping command not found" or "tnsping is not recognized as an internal or external command"
tnsping command not found This type of error message tnsping command not found in Linux or tnsping is not recognized as an internal or external… Read More »How to Resolve "tnsping command not found" or "tnsping is not recognized as an internal or external command"
How RMAN Set NLS_DATE_FORMAT
NLS_DATE_FORMAT for RMAN After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log,… Read More »How RMAN Set NLS_DATE_FORMAT