CentOSOracle报EnvironmentvariableORACLE_UNQNAMEnotdefined错误的解决办法 - 数据库编程

录密码，最后输入 Y 进行确认，如：

STARTED EMCA at Mar 10, 2015 10:03:17 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Listener ORACLE_HOME [ /opt/oracle/11g ]: 
Password for SYS user:  
Password for DBSNMP user:  
Password for SYSMAN user:  
Email address for notifications (optional): 
Outgoing Mail (SMTP) server for notifications (optional):

12. 检查 em 的状态

$ emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://hemw-pc:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running. 
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/11g/hemw-pc_orcl/sysman/log

至此，问题已经解决完毕。

附：emca 常用命令

创建一个 em 资料库：emca -repos create
重建一个 em 资料库：emca -repos recreate
删除一个 em 资料库：emca -repos drop

配置数据库的 Database Control：emca -config dbcontrol db
删除数据库的 Database Control配置：emca -deconfig dbcontrol db

重新配置db control的端口，默认端口在1158
emca -reconfig ports
emca -reconfig ports -dbcontrol_http_port 1160
emca -reconfig ports -agent_port 3940

先设置 ORACLE_SID 环境变量后,启动 em console服务：emctl start dbconsole
先设置 ORACLE_SID 环境变量后,停止em console服务：emctl stop dbconsole
先设置 ORACLE_SID 环境变量后,查看 em console服务的状态：emctl status dbconsole

配置 dbconsole 的步骤
emca -repos create
emca -config dbcontrol db
emctl start dbconsole

重新配置 dbconsole 的步骤
emca -repos drop
emca -repos create
emca -config dbcontrol db

emctl start dbconsole

CentOSOracle报EnvironmentvariableORACLE_UNQNAMEnotdefined错误的解决办法(二)

附：emca 常用命令