Oracle使用DBCA建立資料庫指令碼追蹤學習案例(二)

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected to an idle instance.
SQL> startup ;
ORACLE instance started.

Total System Global Area 1185853440 bytes
Fixed Size                  2212776 bytes
Variable Size             335547480 bytes
Database Buffers          838860800 bytes
Redo Buffers                9232384 bytes
Database mounted.
Database opened.
SQL> host /u01/app/oracle/product/11.2.0/db_1/bin/emca -config dbcontrol db -silent -DB_UNIQUE_NAME taxi -PORT 1521 -EM_HOME /u01/app/oracle/product/11.2.0/db_1 -LISTENER LISTENER -SERVICE_NAME taxi -SID taxi -ORACLE_HOME /u01/app/oracle/product/11.2.0/db_1 -HOST 192.168.11.112 -LISTENER_OH /u01/app/oracle/product/11.2.0/db_1 -LOG_FILE /u01/app/oracle/admin/taxi/scripts/emConfig.log;

STARTED EMCA at Oct 16, 2014 5:08:31 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Database Control is already configured for the database taxi
You have chosen to configure Database Control for managing the database taxi
This will remove the existing configuration and the default settings and perform a fresh configuration

Password for SYS user:  

Password for DBSNMP user:   
Password for SYSMAN user:  
Password for SYSMAN user:
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1

Local hostname ................ dg.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
Listener port number ................ 1521
Database SID ................ taxi
Email address for notifications ............... null
Outgoing Mail (SMTP) server for notifications ............... null

-----------------------------------------------------------------
Oct 16, 2014 5:11:13 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/admin/taxi/scripts/emConfig.log.
Oct 16, 2014 5:11:20 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Oct 16, 2014 5:12:22 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Oct 16, 2014 5:13:13 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Oct 16, 2014 5:13:30 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Oct 16, 2014 5:13:30 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Oct 16, 2014 5:17:11 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Oct 16, 2014 5:17:11 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Oct 16, 2014 5:17:49 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Oct 16, 2014 5:17:50 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Oct 16, 2014 5:19:47 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Oct 16, 2014 5:19:47 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is <<<<<<<<<<<
Oct 16, 2014 5:19:57 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/db_1/dg.com_taxi/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Oct 16, 2014 5:19:57 PM

SQL> spool off
SQL> select instane^H ce_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
taxi             OPEN

1 row selected.

SQL> select * from scott.dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

4 rows selected.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dg scripts]$