Where is Oracle Listener Log Location
The Default Location of Oracle Listener Log If you have read Where to Find Oracle Alert Log Location, you may have some clues to find… Read More »Where is Oracle Listener Log Location
listener.log
How to Delete Log Files Periodically in Oracle
Trace File, Audit File and Alert Log In this post I will introduce a shell script that can delete log files automatically. We will handle… Read More »How to Delete Log Files Periodically in Oracle
How to Trim Alert Log File in Oracle
The retention of alert log cannot be controlled by ADRCI utility, it needs manual intervention. In this post, I'd like to share how I reduce… Read More »How to Trim Alert Log File in Oracle
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 Create a 9i Database by DBCA with Silent Mode
In my experience, to create a new database by DBCA with silent mode in a 9i database on Linux, you must issue the dbca command… Read More »How to Create a 9i Database by DBCA with Silent Mode
How to Install Oracle 9i Database on Enterprise Linux 4
Here I show my experience on the steps to install 9.2.0.4 and patch it up to 9.2.0.8 on Enterprise Linux 4.4. In general, Oracle 9.2.0.4… Read More »How to Install Oracle 9i Database on Enterprise Linux 4