Home arrow Oracle arrow Page 5 - The Oracle Application Server 10g Infrastructure

The Infrastructure Log Tables - 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).

  1. The Oracle Application Server 10g Infrastructure
  2. The Infrastructure Repository
  3. Workflow iasdb Schemas
  4. Viewing the Whole iasdb Instance
  5. The Infrastructure Log Tables
  6. Writing Your Own Infrastructure Repository Log Scripts
  7. Infrastructure Log Reports
  8. Repository Administration and Management
  9. Single Sign-On (SSO)
  10. Using the SSO Audit Log Tables
  11. SSO Administration Using the mod_osso Utility
By: McGraw-Hill/Osborne
Rating: starstarstarstarstar / 12
May 05, 2005

print this article



The Application Server 10g system contains numerous log files, some of which are stored in flat files while others are stored inside the iasdb instance. Remember that log files and audit trails may exist in many places, and you must become accustomed to looking for error messages and audits in the proper places.

In practice, administrators use shell scripts with SQL*Plus to automate this task, and filter out unwanted messages so they can see only those messages that are germane to their current needs. When the iasdb database is initially loaded, log files are created in the $ORACLE_HOME/config directory. These include the following files:

  • schemaload.log This file reports on the iasdb load process.

  • useinfratool.log This file reports on all tools whose definitions have been loaded into the iasdb instance.

  • infratool_instance_jazn.log This reports on the Java Authorization (JAZN) install using Oracleís Java Authentication and Authorization Service (JAAS).

  • infratool_mod_osso.log This file reports on the mod_osso load process.

After the iasdb initial load, it is a good idea to check these files for errors. Application Server 10g will report on all successful component installations in these logs, and you can easily check the status with a single command:

root> grep -i succeeded $ORACLE_HOME/config/*.log
infratool_instance_jazn.log:Configuration succeeded for IASProperty
infratool_instance_jazn.log:Configuration succeeded for IAS infratool_instance_jazn.log:Configuration succeeded for LDAP
infratool_mod_osso.log:Configuration succeeded for JAZN infratool_mod_osso.log:Configuration succeeded for HTTPD

infratool_mod_osso.log:Configuration succeeded for MODOSSO schemaload.log:Configuration succeeded for SchemaLoad

Of course, there are many other flat files for logs within Application Server 10g, and they are fully discussed in later chapters. Next letís look at the OEM console interface for displaying Application Server 10g  log messages.

Using the OEM Console to View Application Server 10g Logs

The Oracle Enterprise Manager console contains a graphical log viewer that can be used to display some of the log files, as shown in Figure 2-1. From this screen you can choose any Application Server 10g component and view some of the associated log files. In the example shown in Figure 2-2, we chose Wireless and selected the Search button. Here you see server-side error log messages associated with Oracle Portal. However, this screen can be misleading because the infrastructure database also contains repository logs.

Figure 2-1.  The OEM log file viewer

Figure 2-2.  The OEM Wireless log file viewer 

Using the OEM Repository Log Viewer

The repository log viewer is easy to use, and you can select any Application Server 10g component and view the associated repository log messages (Figure 2-3). From this screen you can choose the repository components and specify filter conditions. This OEM screen then generates the SQL statements to query the native iasdb database log tables. In the example in Figure 2-3, we selected the OC4J wireless logs.

When you click the Search button, you see the error messages associated with the OC4J Wireless component displayed in HTML format. Although the OEM console GUI is great for ad hoc queries, administrators often supplement this GUI with custom scripts to extract and e-mail important error messages. Letís take a closer look at how this works.

>>> More Oracle Articles          >>> More By McGraw-Hill/Osborne

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: