Notes

Outline

Database internals and Federation Database administration

Db & account management tools Use dbca to create/drop a database and register it with the ASTRO-WISE LDAP server. Use oemapp to Create/drop/alter users Create/drop/grant/revoke roles Grant/revoke privileges

Db & network management tools netmgr – enterprise manager tool to administrate db network connections Listener – makes the database visible to the network lsnrctl – starts, stops and checks the status of the listener process netca – tool to configure listeners

Oracle Internet Directory The internet directory provides a network lookup facility for resources, e.g. users, dbs, hardware, … oidadmin tool LDAP protocol Centralized administration of users, databases, network, roles, etc.

ASTRO-WISE Database Administration Organization and maintenance of the database federation

Naming conventions SID.machine.organization.aw SID – database name machine – hostname running SID organization – ESO, IAP, NOVA, OAC, USM, … Users .dbf files Tablespaces Tables, types and views

Tools (1) Adding partitions to tables Changing the “CONTEXT” of data Adding tablespaces Create/drop/update indexes Analyze Check logs

Tools (2) Clean up garbage Moving user and federation data while maintaining referential integrity Checking network integrity Checking (FITS)data integrity ???

Stored procedures Stored procedures – groups of SQL, PL/SQL, and also Java statements – enable you to move code from your application to the database. PL/SQL is a Pascal&ADA like language that is SQL-aware

Recommended documentation Always have the on-line documentation available that comes with the Oracle installation Oracle9i SQL Reference On-line SQL syntax & examples