安装时按照默认配置一路“下一步”,创建了个数据库orcl。
访问EM时发现竟然没有,于是手动安装。
以管理员方式运行命令行窗口,执行下面的命令:
1、删除配置
emca -deconfig dbcontrol db
2、删除repository
emca -repos drop
3、创建新配置
emca -repos create
4、配置
emca -config dbcontrol db
访问EM地址:https://localhost:1158/em
安装过程中遇到的问题是:
配置: ORA-12541: TNS: 无监听程序
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS: 无监听程序
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)
at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1001)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:346)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:583)
at oracle.sysman.assistants.util.em.EMConfigStep.executeImpl(EMConfigStep.java:139)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.BasicStep.callStep(BasicStep.java:251)
at oracle.sysman.assistants.dbca.backend.PostDBConfigureStep.executeImpl(PostDBConfigureStep.java:269)
at oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
at oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2667)
at java.lang.Thread.run(Thread.java:595)
解决办法是启动Oracle Net Manager程序,在监听程序的LISTENER添加地址,主机名即机器名,端口为1521。
原因是默认只创建了localhost的监听,而有些配置中用了机器名的则不能监听到。
2013-4-28 11:38:39 oracle.sysman.emcp.util.FileUtil copyFile
配置: exception caught in copyFile:
oracle.sysman.emcp.exception.FileUtilException: 正在将文件 H:\app\dell\product\11.2.0\dbhome_1\sysman\config\emd.properties 复制到 H:\app\dell\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp
at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
at oracle.sysman.emcp.util.FileUtil.backupFile(FileUtil.java:1264)
at oracle.sysman.emcp.EMDBPreConfig.backupSharedFiles(EMDBPreConfig.java:1247)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:251)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
Caused by: java.io.FileNotFoundException: H:\app\dell\product\11.2.0\dbhome_1\sysman\config\emd.properties.emca.tmp (拒绝访问。)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
... 11 more
2013-4-28 11:38:39 oracle.sysman.emcp.util.FileUtil backupFile
....
2013-4-28 11:41:58 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
配置: Failed to unlock mgmt_view account
2013-4-28 11:41:58 oracle.sysman.emcp.EMReposConfig invoke
严重: 无法对所有 EM 相关帐户解锁
2013-4-28 11:41:58 oracle.sysman.emcp.EMConfig perform
严重: 无法对所有 EM 相关帐户解锁
....
是由于命令窗口没有管理员的权限,不能拷贝配置文件等,导致后面的脚本执行出错所致。
参考文献
[1] 手动安装em(redhat 5/oracle 11g).http://blog.sina.com.cn/s/blog_3eb222740100jk97.html
[2] OracleDBConsoleorcl 服务无法启动如何解决??.http://www.itpub.net/thread-950860-1-1.html