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