操作系统:Windows 7旗舰版 Service Pack1
IE版本:
Oracle database版本
C:\Users\Administrator>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期四 2月 12 00:26:27 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect sys/orcl@ORCL as sysdba
已连接。
SQL> select * from v$version;
BANNER
----------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
IE浏览器地址输入:https://oracledba68:1158/em
提示错误:
检查em状态,提示如下
C:\Users\Administrator>emctl status dbconosle
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da
tabase unique name.
C:\Users\Administrator>
配置环境变量
C:\Users\Administrator>set ORACLE_UQNAME=ORCL
如上命令不能创建系统的环境变量,只能手工去创建环境变量并重新启动PC。查看em状态就正常如下
C:\Users\Administrator>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
https://OracleDBA68:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory d:\app\Administrator\product\11.2.0\dbhome_1/Ora
cleDBA68_ORCL/sysman/log
重启服务OracleDBconosle<sid>。但是,em还是无法访问。
根据Oracle 11g重建em步骤:
1.删除em配置(emca -repos drop)
2.增加em(emca -repos create)
3.配置em(emca -config dbcontrol db)
em 用IE仍然无法访问。不知道为什么?查看log也没有什么问题。
设置em地址为IE可信站点,仍然无法访问。
解决方法:安装Firefox浏览器输入em地址就正常可以访问。