Writing Your Own Infrastructure Repository Log Scripts - Oracle

If you need to handle the administration and management of Oracle Application Server 10g, this article covers the metadata repository (iasdb), the Single Sign-On (SSO) security framework, and the Oracle Application Server 10g Management Services. It is excerpted from chapter 2 of the book, Oracle Application Server 10g Administration Handbook, written by John Garmany and Donald Burleson (McGraw-Hill/Osborne, 2004; ISBN: 0072229586).

TABLE OF CONTENTS:

By: McGraw-Hill/Osborne

Poor Best

Rating:

/ 12

May 05, 2005

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

As we just noted, the OEM viewer is great for quick online queries, but most administrators write SQL*Plus scripts to directly extract the repository log message, often e-mailing it to the desktop.

Figure 2-3. The OEM infrastructure repository log viewer

To see how this works, here is a sample Korn shell script that will extract the online repository logs for SSO and mail them to the Application Server 10g administrator:

mail_logs.ksh

#!/bin/ksh
# First, we must set the environment . . . .
ORACLE_SID=iasdb
   export ORACLE_SID
   ORACLE_HOME=`cat /etc/oratab|grep $ORACLE_SID:|cut -f2 -
':'`
   export ORACLE_HOME
   PATH=$ORACLE_HOME/bin:$PATH
   export PATH
   # Get the server name
  host=`uname -a|awk '{ print $2 }'`
${ORACLE_HOME}/bin/sqlplus system/`cat password.txt`<<!
spool log_rpt_mgt.1st
   @sso_audit_log.sq l
spool off
exit;
!
#************************************
# Filter only error messages #************************************
grep –i error log_rpt_mgt.lst > errors_log.lst

#************************************
# Mail the Object Statistics Reports #************************************
cat error_rpt_mgt.lst|mailx -s "Oracle AS 10g Repository SSO Messages" \
   larry_lizard@us.oracle.com \
   raham_cracker@oracle.com \
   bob_white@oracle.com

Note the password security in the SQL*Plus invocation line. You can save the SYSTEM password on your server in a file called password.txt and protect it by setting the file permissions such that only the Oracle user may view the password:

oracle> chmod 700 password.txt
oracle> ls -al *.txt
-rwx------ 1 oracle oracle 13 Aug 18 05:35 password.txt

Now that you’ve seen how easy it is to write SQL*Plus scripts against the iasdb instance, let’s take a look at the log tables and see which are the most important to the Application Server 10g administrator.

Viewing the Repository Log Tables

Because Oracle has been very careful to use uniform table naming conventions, you can write a simple SQL*Plus query to see the Application Server 10g log tables. In the following listing, we select all iasdb tables that contain the string LOG.

select owner, table_name
from dba_tables
where table_name like '%LOG%';
WIRELESS                 PTG_LBS_LOG
                               PTG_DEBUG_LOG
                               PTG_SERVICE_LOG
                                PTG_SESSION_LOG
                                TRANS_REQUEST_LOG
                                TRANS_HANDLE_LOG
                                TRANS_PROCESS_LOG
                                TRANS_ENQUEUE_LOG
                                TRANS_DEQUEUE_LOG
                                ASYNC_STATISTICS_LOG
                                MESSAGING_OUTGOING_LOG
                                LBEVENT_ENQUEUE_LOG
                                LBEVENT_DEQUEUE_LOG
                                LBEVENT_MSG_LOG
                               LBEVENT_ACTIVATION_LOG
                                STUDIO_LOG MESSAGES
                               PROVISIONING_TRANSACTION_LOG
                                BILLING_SDR_LOG
                                SYS_LOGGER_TABLE
                               WWSEC_SSO_LOG$
OWF_MGR                    ECX_OUTBOUND_LOGS
                               ECX_DOCLOGS
                               ECX_EXTERNAL_LOGS
                               ECX_OXTA_LOGMSG
                               ECX_INBOUND_LOGS
                               ECX_MSG_LOGS
IP                 TIP_ERRORLOGINSTANCE_T_AUD
                   ERRORLOGRECORDDATA_AUD
                              TIP_ERRORLOGINSTANCE_RT
                              TIP_ERRORLOGRECORDDATAINSTA_RT
                              TIP_RTLOG
                              B2BERROR_LOG

The output shows each of the iasdb schemas and their associated log tables. Remember, not all of the log tables are populated with meaningful information, so you must carefully examine each log file to see the contents.

Next: Infrastructure Log Reports >>