Where is Oracle Listener Log Locationby Ed ChenApril 18, 2019December 10, 20223 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
How to Delete Log Files Periodically in Oracleby Ed ChenMay 18, 2018December 10, 2022Trace 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 Oracleby Ed ChenApril 19, 2018December 11, 2022The 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, 2014June 23, 2023ORA-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, 2012February 8, 2023In 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, 2012February 13, 2023Here 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