DBCA Silent Building and deleting libraries

DBCA View Help:

[Email protected] ~]$ Dbca-help

1), run the Silent Build database statement

[Email protected] ~]$ dbca-silent-clonetemplate-gdbname wen-sid wen-syspassword Oracle-systempassword Oracle-emcon figuration Local-dbsnmppassword Oracle-sysmanpassword ORACLE-RESPONSEFILE/HOME/ORACLE/DBCA.RSP

Copying Database files

1% Complete

3% Complete

11% Complete

18% Complete

26% Complete

37% Complete

Creating and Starting Oracle instance

40% Complete

45% Complete

50% Complete

55% Complete

56% Complete

60% Complete

62% Complete

Completing Database Creation

66% Complete

70% Complete

73% Complete

85% Complete

96% Complete

100% Complete

Look at the log file '/u01/app/oracle/cfgtoollogs/dbca/wen/wen.log ' for further details.

Rename the users who are running the Wen library:

Sql> Select Username,account_status from dba_users where account_status= ' OPEN ';

USERNAME Account_status

------------------------------ --------------------------------

SYSTEM OPEN

SYS OPEN

Sysman OPEN

Dbsnmp OPEN

Mgmt_view OPEN

2) using a template to build a library

Template location:

[[email protected] ~]$ ls $ORACLE _home/assistants/dbca/templates/

Data_warehouse.dbc example.dmp NEW_DATABASE.DBT SEED_DATABASE.DFB

EXAMPLE01.DFB General_purpose.dbc Seed_database.ctl

To build a library statement:

[Email protected] ~]$ dbca-silent-createdatabase-templatename $ORACLE _home/assistants/dbca/templates/general_ Purpose.dbc-gdbname wcw-sid wcw-responsefile no_value-characterset al32utf8-nationalcharacterset al16utf16

Or

[Email protected] oradata]$ dbca-silent-createdatabase-templatename $ORACLE _home/assistants/dbca/templates/ General_purpose.dbc-gdbname wcw-sid wcw-responsefile no_value-characterset al32utf8-nationalcharacterset al16utf16- Emconfiguration Local-dbsnmppassword Oracle-sysmanpassword Oracle

To silently delete a database:

[Email protected] oradata]$ Dbca-silent-deletedatabase-sourcedb Wen

Connecting to Database

4% Complete

9% Complete

14% Complete

19% Complete

23% Complete

28% Complete

47% Complete

Updating Network configuration Files

48% Complete

52% Complete

Deleting instance and datafiles

76% Complete

100% Complete

Look at the log file '/u01/app/oracle/cfgtoollogs/dbca/wen.log ' for further details.

[Email protected] oradata]$

DBCA Silent Building and deleting libraries