Where is Oracle Listener Log Locationby Ed ChenApril 18, 2019July 6, 20193 CommentsThe 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
Script to Delete Log Files Automatically in Oracleby Ed ChenMay 18, 2018September 1, 2020Trace 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 »Script to Delete Log Files Automatically in Oracle
How to Trim Alert Log File in Oracleby Ed ChenApril 19, 2018September 1, 2020The 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 occurredby Ed ChenMay 29, 2014December 24, 2020ORA-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 Modeby Ed ChenDecember 3, 2012August 8, 2019In 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 4by Ed ChenDecember 2, 2012April 20, 2018Here 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