Aix 下 Oracle em的调试

uye01->lsnrctl status（查看监听状态）

LSNRCTL for IBM/AIX RISC System/6000:Version 11.2.0.3.0 - Production on 19-FEB-2014 20:55:32

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.177.100.13)(PORT=1521)))

STATUS of theLISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for IBM/AIX RISCSystem/6000: Version 11.2.0.3.0 - Production

Start Date                25-JAN-2014 00:26:55

Uptime                    25 days 20 hr. 28 min. 38sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      ON

Listener Parameter File   /oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File        /oracle/diag/tnslsnr/wuye01/listener/alert/log.xml

Listening Endpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.177.100.13)(PORT=1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "housewy" has 1instance(s).

 Instance "housewy", status UNKNOWN, has 1 handler(s) for thisservice...

The command completed successfully

 

wuye01->export ORACLE_HOSTNAME=10.177.100.13    （设置 ORACLE_HOSTNAME）

wuye01-> emca-deconfig dbcontrol db -repos drop   （删除现有的em配置）

 

STARTED EMCA atFeb 19, 2014 9:02:53 PM

EM Configuration Assistant, Version11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle.  All rights reserved.

 

Enter the following information:

Database SID:housewy

Listener portnumber: 1521

Password for SYSuser: 

Password forSYSMAN user: 

 

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

WARNING : While repository is dropped thedatabase will be put in quiesce mode.

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

Do you wish to continue? [yes(Y)/no(N)]: y

Feb 19, 2014 9:03:23 PMoracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at/oracle/cfgtoollogs/emca/housewy/emca_2014_02_19_21_02_52.log.

Feb 19, 2014 9:03:23PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration

WARNING: EM is not configured for thisdatabase. No EM-specific actions can be performed. Some of the possible reasonsmay be:

 1)EM is configured with different hostname then physical host. Set environmentvariable ORACLE_HOSTNAME=<hostname> and re-run EMCA script

 2)ORACLE_HOSTNAME is set. Unset it and re-run EMCA script

Feb 19, 2014 9:03:23 PMoracle.sysman.emcp.EMReposConfig invoke

INFO: Dropping the EM repository (this maytake a while) ...

Feb 19, 2014 9:04:41 PMoracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully dropped

Enterprise Manager configuration completedsuccessfully

FINISHED EMCA at Feb 19, 2014 9:04:41 PM

wuye01->emctl status dbconsole

Environment variable ORACLE_UNQNAME notdefined. Please set ORACLE_UNQNAME to database unique name.

wuye01->export ORACLE_UNQNAME=houswy

wuye01->emctl status dbconsole

OC4J Configuration issue./oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_10.177.100.13_houswynot found.

wuye01-> cd/oracle/product/11.2.0/dbhome_1/oc4j/j2ee

wuye01-> ls

OC4J_DBConsole                      home

OC4J_Workflow_Component_Container   oc4j_applications

OC4J_Workflow_Management_Container  utilities

deploy_db_wf.ini

wuye01-> pwd

/oracle/product/11.2.0/dbhome_1/oc4j/j2ee

wuye01-> emca-config dbcontrol db -repos create

 

STARTED EMCA atFeb 19, 2014 9:11:17 PM

EM Configuration Assistant, Version11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle.  All rights reserved.

 

Enter the following information:

Database SID:housewy

Listener portnumber: 1521

ListenerORACLE_HOME [ /oracle/product/11.2.0/dbhome_1 ]:

Password for SYSuser: 

Password forDBSNMP user: 

Password forSYSMAN user: 

Email addressfor notifications (optional):

Outgoing Mail(SMTP) server for notifications (optional):

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

 

You havespecified the following settings

 

DatabaseORACLE_HOME ................ /oracle/product/11.2.0/dbhome_1

 

Local hostname................ 10.177.100.13

Listener ORACLE_HOME ................/oracle/product/11.2.0/dbhome_1

Listener port number ................ 1521

Database SID ................ housewy

Email address for notifications...............

Outgoing Mail (SMTP) server fornotifications ...............

 

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

Do you wish to continue? [yes(Y)/no(N)]: y

Feb 19, 2014 9:12:03 PMoracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at/oracle/cfgtoollogs/emca/housewy/emca_2014_02_19_21_11_17.log.

Feb 19, 20149:12:05 PM oracle.sysman.emcp.EMReposConfig createRepository

INFO: Creating the EM repository (this maytake a while) ...

Feb 19, 2014 9:15:50 PMoracle.sysman.emcp.EMReposConfig invoke

INFO: Repository successfully created

Feb 19, 2014 9:15:52 PMoracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository

INFO: Uploading configuration data to EMrepository (this may take a while) ...

Feb 19, 2014 9:17:11 PM oracle.sysman.emcp.EMReposConfiginvoke

INFO: Uploaded configuration datasuccessfully

Feb 19, 2014 9:17:12 PMoracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Securing Database Control (this maytake a while) ...

Feb 19, 20149:17:19 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole

INFO: Database Control securedsuccessfully.

Feb 19, 20149:17:19 PM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this maytake a while) ...

Feb 19, 20149:17:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully

Feb 19, 20149:17:35 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO:>>>>>>>>>>> The Database Control URL ishttps://10.177.100.13:1158/em <<<<<<<<<<<

Feb 19, 20149:17:38 PM oracle.sysman.emcp.EMDBPostConfig invoke

WARNING:

************************  WARNING ************************

 

Management Repository has been placed insecure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in thefile:/oracle/product/11.2.0/dbhome_1/10.177.100.13_housewy/sysman/config/emkey.ora.Ensure this file is backed up as the encrypted data will become unusable ifthis file is lost.

 

***********************************************************

EnterpriseManager configuration completed successfully

FINISHED EMCA at Feb 19, 2014 9:17:38 PM

wuye01->