下面是测试一下Oracle 10g中怎么配置DB CONSOLE,EM这个东西平时用得太多了,一点不熟悉
测试环境:OS:SOLARIS 10,DB :10.2.0.1
1,EMCA创建
$ emca -config dbcontrol db -repos create
STARTED EMCA atDec 22, 2012 12:30:09 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: htz
Listener port number: 1521
Passwordfor SYS user:
Passwordfor DBSNMP user:
Passwordfor SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
Database hostname ................ 10rac1
Listener port number ................ 1521
Database SID ................ htz
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish tocontinue? [yes(Y)/no(N)]: Y
Dec 22, 2012 12:31:12 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log.
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_repos_create_.log for more details.
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details
晕,报错了,数据库是新创建的,查看一下原因。
2,日志查看
$ cd $ORACLE_HOME/cfgtool*/
$ ls
cfgfw configToolAllCommands dbca emca netca oui
$ cd emca/htz
$ vi emca_2012-12-22_12-30-09-PM.log
CONFIG: No value was setfor the parameter SYS_PWD.
Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: htz, oracleHome: /u01/app/oracle/product/11.2.0/db_1, anduser:
Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db'settofalse
Dec 22, 2012 12:31:01 PM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db'settofalse
Dec 22, 2012 12:31:03 PM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: PORT value: 1521
Dec 22, 2012 12:31:05 PM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was setfor the parameter SYS_PWD.
Dec 22, 2012 12:31:05 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: htz, oracleHome: /u01/app/oracle/product/11.2.0/db_1, anduser: SYS
Dec 22, 2012 12:31:05 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
"emca_2012-12-22_12-30-09-PM.log" 370 lines, 26004 characters
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:306)
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:360)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:182)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_repos_create_.log for more details.
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/emca/htz/emca_2012-12-22_12-30-09-PM.log for more details.
Dec 22, 2012 12:31:13 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:194)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:124)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)
再看另一个日志
$ vi emca_repos_create_2012-12-22_12-31-13-PM.log
"emca_repos_create_2012-12-22_12-31-13-PM.log" 21 lines, 911 characters
Check if repos user already exists.
old 6: WHERE username=UPPER('&EM_REPOS_USER');
new 6: WHERE username=UPPER('SYSMAN');
old 8: IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
new 8: IF ( 'NOT_EXISTS' = 'EXISTS') THEN
old 11: raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
new 11: raise_application_error(-20000, 'SYSMAN does not exists..');
old 14: ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
new 14: ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
old 17: raise_application_error(-20001, '&EM_REPOS_USER already exists..');
new 17: raise_application_error(-20001, 'SYSMAN already exists..');
old 21: raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
new 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
DECLARE
*
ERROR at line 1:
ORA-20001: SYSMAN already exists..
ORA-06512: at line 17
报用户已经存在,原来没有创建过EM,DBCA创建数据库的时候也没有勾上。
- 大小: 34.5 KB
分享到:
相关推荐
oracle10g pl/sql完备教程,供初学者学习与开发者参考
Linux安装Oracle 10g完整配置文档 在本文档中,我们将详细介绍如何在 Linux 操作系统中安装 Oracle 10g 数据库。安装 Oracle 10g 需要满足一定的前提条件,并需要对 Linux 系统的内核参数进行修改。 安装前的准备...
Oracle10g EM Console配置
oracle 11g for win32位下载地址:http://download.oracle.com/otn/nt/oracle11g/xe/OracleXE112_Win32.zip 适合Win7系统。 直接在迅雷或其它下载工具里新建任务,复制地址上去就可以下载了。本人已经下载成功!
oracle10g数据库教程之OEM的配置
oracle 10g 数据库免费 安装版,这个是一个百度云的下载地址,有需要的自己下载,这个oracle数据库有600多m,本人觉得挺好用的,希望能帮助到你们
Oracle CDC 数据同步9i/10GOracle CDC 数据同步9i/10GOracle CDC 数据同步9i/10G
在安装了Oracle11g的环境下配置plsql developer
oracle10g pl/sql编程是PDF格式的电子书
database 11g r2: http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_1of2.zip http://download.oracle.com/otn/solaris/oracle11g/R2/solaris.sparc64_11gR2_database_2of2.zip...
Tom经典大作,Oracle Database 9i/10g/11g编程艺术深入数据库体系结构中文版
[root@dbserver ~]# cd /opt/oracle/product/11.2.0/dbhome_1/bin/ [root@dbserver bin]# ./sqlplus sys AS SYSDBA …… Enter password: //输入管理密码 Connected to: Oracle Database 11g Enterprise Edition ...
linux环境下oracle10g安装 1.连接putty 2.用root登录后建立用户和组 新增oinstall、dba用户组,oracle用户 [root@oracle10g /]# groupadd oinstall [root@oracle10g /]# groupadd dba [root@oracle10g /]# useradd ...
Oracle Database 9i/10g/11g编程艺术深入数据库体系结构中文版
文档包含Oracle数据库11g安装过程/配置权限过程/卸载数据库过程.亲身实验总结,教你玩转数据库
part2 本工具提取自 oracle 10gR2 Java 版的 OEM Console 解压后,看使用说明,很简单!
本文详细介绍了 Linux 中安装 ORACLE10g 数据库的步骤,包括安装前准备、配置 ORACLE 安装环境、配置内核参数、创建 ORACLE 安装目录和安装 ORACLE10g 数据库等。通过遵循这些步骤,可以成功安装 ORACLE10g 数据库在...
数据库驱动包,包括MySQL/Oracle9i/10g/MSSQL2000/2005
英文版Oracle Database 9i/10g/11g编程艺术:深入数据库体系结构(第2版)
sql是关系数据库的基本操作语言 它是应用程序与数据库进行交互操作的接口 pl/sql是oracle特有的编程语言 它不仅具有过程编程语言的基本特征 循环 条件分支等 而且还具有对象编程语言的高级特征 重载 继承等 ...