Immutable Iasdb Schemas Oracle Application Server Tips by Burleson Consulting

Some of the schema components are immutable and the passwords and data structures must never be changed.  This is especially true for this group of Iasdb schema:

Schema Name	Used By	Default Password
CTXSYS	Intermedia Text option	change_on_install
MDSYS	Spatial Data option	mdsys
OLAPDBA	OLAP Services option	olapdba
OLAPSVR	OLAP Services option	instance
OLAPSYS	OLAP Services option	manager
ORDPLUGINS	InterMedia Audio option	ordplugins
ORDSYS	InterMedia Audio option	ordsys
OUTLN	Stored Outlines	outln

Workflow Iasdb schemas

The following Iasdb schemas are used by the Oracle workflow component and the passwords may be changed as desired

Schema Name	Used By	Default Password
BLEWIS	Workflow component	blewis
CDOUGLAS	Workflow component	cdouglas
KWALKER	Workflow component	kwalker
SPIERSON	Workflow component	spierson

 Schemas registered in the OID

This group of Iasdb schemas includes those schemas that are registered in OID.  Because the OID manages the passwords for these schemas, you should never attempt to alter any of these schema owner passwords with the alter user command.  Instead, you should use the OEM facility for changing these passwords.  When using OEM to alter these passwords, OEM will change the password inside the Iasdb database and also updated the appropriate OID system tables.

OID Schema Name	Used By
DISCOVERER5	Discoverer
DSGATEWAY	Syndication Server
DSSYS	Web Services
ODS	Internet Directory
ODSCOMMON	Internet Directory
ORASSO	Single Sign-On
ORASSO_DS	Single Sign-On
ORASSO_PA	Single Sign-On
ORASSO_PS	Single Sign-On
ORASSO_PUBLIC	Single Sign-On
PORTAL	Portal
PORTAL_APP	Portal
PORTAL_DEMO	Portal
PORTAL_PUBLIC	Portal
WIRELESS	Wireless

Now that we have a brief tour of the schema components, let?s dive deeper and explore SQL*Plus scripts that allow us to see the individual schema components in greater detail.

Viewing the whole Iasdb instance

The entire Iasdb instance is very complex and contains more than 10,000 database objects and more than 1,800 tables.  The following script can be run to show the counts for each object type within Iasdb.

iasdb_component_count.sql
set lines 60
set pages 999

 ttitle 'OracleAS iasdb|Object Report' 

 spool obj_count.lst 

 col c1 heading 'Owner' format a30
 col c2 heading 'Object|Type' format a15
 col c3 heading 'Object|Count' format 99,999 

 break on c1 skip 2 

 compute sum of c3 on c1 

 select
    owner c1,
    object_type c2,
    count(*) c3
 from
 dba_objects
 where
 owner in (
 'OSE$HTTP$ADMIN',
 'DCM',
 'DISCOVERER5',
 'ORASSO_PS',
 'ORASSO_PUBLIC',
 'ORASSO',
 'ODS',
 'ORAOCA_PUBLIC',
 'UDDISYS',
 'WCRSYS',
 'OCA',
 'IP',
 'OWF_MGR',
 'WIRELESS',
 'DSGATEWAY',
 'PORTAL_APP',
 'PORTAL_PUBLIC',
 'PORTAL',
 'ORASSO_PA',
 'ORASSO_DS',
 'WKPROXY',
 'INTERNET_APPSERVER_REGISTRY',
 'SPIERSON',
 'SYSADMIN',
 'WFADMIN',
 'ORDPLUGINS'
 )
 group by
    owner,
    object_type
 order by
   c1,
   c3 desc
 ;
 
 spool off

The following reports show the output from this script. (Listing 2.1).  Even though there are more than 10,000 objects in the Iasdb database, when we break them down into their components, we see that IP is the largest schema with 400+ tables, followed by PORTAL with 350+ tables, and WIRELESS and OWF_MGR with over 200 tables each. 

  

Listing 2.1: The Iasdb schema components

It should come as no surprise that the Iasdb database contains complex data structures and stored packages, but it is important for the Oracle9iAS administrator to understand how these database components are used by the Oracle9iAS application components.  Of course, the Iasdb schema components should never be altered or directly manipulated, but there are some very important logging components within Iasdb.  Let?s take a close look at some of the Oracle9iAS infrastructure log tables.

This is an excerpt from "Oracle 10g Application Server Administration Handbook" by Don Burleson and John Garmany.