oracle数数据库MDL脚本,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]$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29119536/viewspace-1301416/，如需转载，请注明出处，否则将追究法律责任。