Since Oracle Database 11g, all traces, incident dumps and packages, the alert log, Health Monitor reports, core dumps, and more files are stored in the ADR, a file-based Automatic Diagnostic Repository for simplified database diagnostic data management. In spite the housekeeping or purging of those files got not simplified, unfortunately the new Oracle utility ADRCI can not purge all the files that Oracle database generates in ADR. Thus, you should use the other OS methods and tools to accomplish Oracle database housekeeping.
This time I share a method of rotating Oracle database log files using Unix logrotate mechanism. The below example will rotate the Oracle alert.log and listener.log files in the following way:
- Rotation is based on the file size (you can use “M” or “k” for Mb and Kb)
- Unix Logrotate utility creates a copy of the original log file, then truncates it
- The rotated files will be compressed with Unix gzip utility with the following name <logfile>-yyyymmdd.gz
- Only recent 20 rotated log files are kept
- Rotation frequency is default = weekly
- No errors generated if the log file is missing
Read more »
Issue / Oracle error
SQL*Plus: Release 10.2.0.5.0 - Production on Wed May 18 09:32:35 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ORA-12547: TNS :lost contact when try to connect to Oracle.
I saw that TNS connection issue along with ORA-12547 Oracle error several times, usually when trying to connect to Oracle database server on Unix / Linux host with an OS user that does not belong to oinstall group (Oracle binaries owner group). In this case, interesting enough that local TNS connection to database (when using tnsnames alias) works fine: Read more »
Working as Oracle DBA on HP-UX and Linux both I prefer Bash shell which is available on Linux compared to Korn shell which is default shell on HP-UX. It’s more convenient to work on Linux Bash using handy key combinations, etc. Unfortunately Bash is not installed on HP-UX by default and also not officially supported there – you will not get help from HP support if problems with it arise.
Nevertheless, I could find a way of improving environment settings on HP-UX to make the backspace and some other keys work similar to Linux and Bash shell. Read more »
In the last weeks I was involved in a series of Oracle 10gR2 and Oracle 11gR2 server installations on Linux RHEL 5/OEL 5 (x86_64).
Below I will give a quick comparison of the new installation features of Oracle 11gR2 Server to Oracle10gR2.
Read more »
This article continues my views on Open Source LAMP stack. Below I examine in particular Linux operating system in combination with Oracle database. You can read the previous post here: Towards Open Source, OSS and LAMP.
Linux went further than other “Open Sources” by providing a few popular commercial distributions in the market. If you still do not use Linux in your IT Infrastructure for production middle-ware systems, even on virtualized environments – try it. It works quite well already. Furthermore, nowadays, DBMS runs pretty stable on Linux. Oracle database on OracleVM (virtual machine) is also an option. Read more »