Immutable Iasdb Schemas

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.



Read more here:

http://www.dba-oracle.com/application_server/t_app_server_iasdb.htm

 

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training. 

Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf