AtgOracleSchema

AtgOracleSchema: Represents an database schema

Super Type: AtgRdbSchema

Role	Abstract. (Objects cannot be created.)
Instance Names	Unique
Notification	false
Template Directory
Data View	Children, proximity: 1
Logger Name

Allowed Child Dependencies

AtgRdbData ¹
AtgRdbDataSourceName¹
AtgRdbMaxPoolSize¹
AtgRdbMinPoolSize¹
AtgRdbSchemaName¹
AtgRdbSchemaPassword¹
AtgRdbSchemaTransactionIsolation¹
AtgRdbSchemaUserName¹
AtgSwitchingDatasource¹

¹: These types have a Singleton constraint. Only one instance may be added as a resource.

Allowed Parent Dependencies

AtgOracleRdb

Defaults for Imported Attributes

Name	Default
atgRdbSchemaTransactionIsolation	TRANSACTION_READ_COMMITTED
rdbMaxPoolSize	30
rdbMinPoolSize	5

Note

Commandline options displayed in square brackets "[]" are optional. If an option expects arguments, then angle brackets are shown after the option "<>". Any default value is shown within the brackets.

export

export the schema

Usage: export -buildstamp <> [-pass <>] [-rdb_home <>] [-rdbinstance <>] [-user <>]

Execution	bash
Arguments	export ORACLE_SID=${opts.rdbinstance} ORACLE_HOME=${opts.rdb_home} ORA_NLS33=/${opts.rdb_home}/ocommon/nls/admin/data/ TNS_ADMIN=/${opts.rdb_home}/network/admin/ && $ORACLE_HOME/bin/exp ${opts.user}/${opts.pass}@${opts.rdbinstance} PARFILE=${user.home}/bin/data_export/export_schema.par FILE=${entity.instance.dir}/var/${context.name}-${opts.buildstamp}.dmp

Options

Option	Description
buildstamp	build stamp
pass	pass phrase
rdb_home	path to oracle install
rdbinstance	db instance
user	user name

Packages-Install

installs all the package dependencies

Usage: Packages-Install

import

imports the schema

Usage: import -dmp_file <> [-from_user <>] [-pass <>] [-rdb_home <>] -rdbinstance <> [-user <>]

Execution	bash
Arguments	export ORACLE_SID=${opts.rdbinstance} ORACLE_HOME=${opts.rdb_home} && sh ${user.home}/bin/data_import/import_schema.sh ${opts.dmp_file} ${opts.user} ${opts.pass} ${opts.from_user}

Options

Option	Description
dmp_file	dump file to import
from_user	from user
pass	password
rdb_home	oracle basedir
rdbinstance	database instance
user	user name

ImportDmp

Imports the dmp file

Usage: ImportDmp -rdbinstance <>

Workflow

installDmps

Options

Option	Description
rdbinstance	oracle instance id

Status

Gets the status of the service

Usage: Status

Workflow

upSchema

installDmps

wrapper around Packages-Install

Usage: installDmps [-data_dir </export/home/build/data/current>] [-package_type <AtgRdbData_.*>] -rdbinstance <> [-removeafterimport <true>]

Options

Option	Description
data_dir	import command looks for dmps here
package_type	dump file package type
rdbinstance	database rdbinstance
removeafterimport	removes the dmp file after import

ExportDmp

exports and uploads a dump

Usage: ExportDmp -buildstamp <> -rdbinstance <>

Workflow

Error Handler

Notify

Email: ${framework.admin.email}

Subject

File

Options

Option	Description
buildstamp	buildstamp
rdbinstance	database instance

registerDmp

registers the dump file as an object

Usage: registerDmp [-buildstamp <>] [-dmp_file <>] [-packagetype <AtgRdbData>] [-rdbinstance <>] [-release <>] [-tstampformat <yyyymmddhhmm>] [-version <>]

Options

Option	Description
buildstamp	package build timestamp
dmp_file	dumpfile
packagetype	type name
rdbinstance	database rdbinstance
release	version release
tstampformat	build timestamp format
version	package version

upSchema

checks schema

Usage: upSchema [-pass <>] -rdbinstance <> [-user <>]

Execution	bash
Arguments	sqlplus ${opts.user}/${opts.pass}@${opts.rdbinstance} <<EOF SHOW USER EOF

Options

Option	Description
pass	user pass
rdbinstance	oracle instance
user	user name

runSqlplus

runs sqlplus command

Usage: runSqlplus -file <> [-pass <>] [-rdb_home <>] -rdbinstance <> [-user <>]

Execution	bash
Arguments	export ORACLE_HOME=${opts.rdb_home}; ${opts.rdb_home}/bin/sqlplus ${opts.user}/${opts.pass}@${opts.rdbinstance} @${opts.file}

Options

Option	Description
file	sql script to run
pass	password
rdb_home	install dir
rdbinstance	oracle rdbinstance
user	user name

The following types are defined for use with AtgOracleSchema.