2016-4-26 16:51:15 oracle.sysman.emcp.util.FileUtil getProperties
配置: 读取文件 D:\app\Administrator\product\11.2.0\dbhome_1\install\staticports.ini 时出错
2016-4-26 16:51:15 oracle.sysman.emcp.util.PortManager getFreePorts
配置: D:\app\Administrator\product\11.2.0\dbhome_1:WIN-2V7V5SRTMR9:null:orcl:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 AGENT_PORT_WIN-2V7V5SRTMR9 的值。
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: AGENT_PORT_WIN-2V7V5SRTMR9 value: 3938
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 DBCONTROL_HTTP_PORT_WIN-2V7V5SRTMR9 的值。
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: DBCONTROL_HTTP_PORT_WIN-2V7V5SRTMR9 value: 1158
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 JMS_PORT_WIN-2V7V5SRTMR9 的值。
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: JMS_PORT_WIN-2V7V5SRTMR9 value: 5540
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 RMI_PORT_WIN-2V7V5SRTMR9 的值。
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: RMI_PORT_WIN-2V7V5SRTMR9 value: 5520
2016-4-26 16:51:15 oracle.sysman.emcp.EMDBPreConfig getFreePorts
配置: Ports assigned for Node: WIN-2V7V5SRTMR9 : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2016-4-26 16:51:15 oracle.sysman.emcp.util.ClusterUtil getLocalNode
配置: isLocalNodeDone: true localNode: null
2016-4-26 16:51:15 oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
配置: File: D:\app\Administrator\product\11.2.0\dbhome_1\WIN-2V7V5SRTMR9_orcl\sysman\emd\agntstmp.txt:WIN-2V7V5SRTMR9 does not exists.
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager getHost
配置: Host having instnces running for database orcl : WIN-2V7V5SRTMR9
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: REP_DB_RUNNING_HOST value: WIN-2V7V5SRTMR9
2016-4-26 16:51:15 oracle.sysman.emcp.ParamsManager getRepDbPort
配置: Listener Port: 1521
2016-4-26 16:51:15 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
配置: isLocalConnectionRequired: true
2016-4-26 16:51:15 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: isLocalConnectionRequired: true. Connecting to database instance locally.
2016-4-26 16:51:15 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
2016-4-26 16:51:15 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine created successfully and connected
2016-4-26 16:51:15 oracle.sysman.emcp.EMReposConfig createRepository
配置: Spooling to D:\app\Administrator\cfgtoollogs\emca\orcl\emca_repos_create_2016_04_26_16_51_15.log
2016-4-26 16:51:15 oracle.sysman.emcp.EMReposConfig createRepository
信息: 正在创建 EM 资料档案库 (此操作可能需要一段时间)...
2016-4-26 16:56:00 oracle.sysman.emcp.EMReposConfig invoke
信息: 已成功创建资料档案库
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 EMAIL_ADDRESS 的值。
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MAIL_SERVER_NAME 的值。
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MAIL_SERVER_SENDER_NAME 的值。
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 MAIL_SERVER_SENDER_ADDR 的值。
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getHost
配置: Host having instnces running for database orcl : WIN-2V7V5SRTMR9
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: REP_DB_RUNNING_HOST value: WIN-2V7V5SRTMR9
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getRepDbPort
配置: Listener Port: 1521
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
配置: isLocalConnectionRequired: true
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: isLocalConnectionRequired: true. Connecting to database instance locally.
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine created successfully and connected
2016-4-26 16:56:00 oracle.sysman.emcp.EMReposConfig unlockAccounts
配置: Unlocking dbsnmp and sysman
2016-4-26 16:56:00 oracle.sysman.emcp.EMReposConfig invoke
配置: Successfully unlocked relevant accounts
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getHost
配置: Host having instnces running for database orcl : WIN-2V7V5SRTMR9
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: REP_DB_RUNNING_HOST value: WIN-2V7V5SRTMR9
2016-4-26 16:56:00 oracle.sysman.emcp.ParamsManager getRepDbPort
配置: Listener Port: 1521
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
配置: isLocalConnectionRequired: true
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: isLocalConnectionRequired: true. Connecting to database instance locally.
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
2016-4-26 16:56:00 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine created successfully and connected
2016-4-26 16:56:02 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
配置: Finished executing emreposoutofbox.sql
2016-4-26 16:56:02 oracle.sysman.emcp.ParamsManager getHost
配置: Host having instnces running for database orcl : WIN-2V7V5SRTMR9
2016-4-26 16:56:02 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: REP_DB_RUNNING_HOST value: WIN-2V7V5SRTMR9
2016-4-26 16:56:02 oracle.sysman.emcp.ParamsManager getRepDbPort
配置: Listener Port: 1521
2016-4-26 16:56:02 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
配置: isLocalConnectionRequired: true
2016-4-26 16:56:02 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: isLocalConnectionRequired: true. Connecting to database instance locally.
2016-4-26 16:56:02 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\app\Administrator\product\11.2.0\dbhome_1, and user: SYSMAN
2016-4-26 16:56:03 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine created successfully and connected
2016-4-26 16:56:03 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
配置: Submitting dbms job: D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\admin\admin_submit_dbms_jobs.sql
2016-4-26 16:56:03 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
配置: Successfully submitted dbms job
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
配置: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-2V7V5SRTMR9)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager getHost
配置: Host having instnces running for database orcl : WIN-2V7V5SRTMR9
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager setParam
配置: Setting param: REP_DB_RUNNING_HOST value: WIN-2V7V5SRTMR9
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager getRepDbPort
配置: Listener Port: 1521
2016-4-26 16:56:03 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
配置: isLocalConnectionRequired: true
2016-4-26 16:56:03 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
配置: isLocalConnectionRequired: true. Connecting to database instance locally.
2016-4-26 16:56:03 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine connecting with SID: orcl, oracleHome: D:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
2016-4-26 16:56:03 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
配置: SQLEngine created successfully and connected
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
配置: Passed listener validation check.Listener is up and running.
2016-4-26 16:56:03 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
配置: Unlocking mgmt view user account
2016-4-26 16:56:03 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
配置: view user sql: declare repos_pwd varchar2(30); view_user varchar2(30); view_user_pwd varchar2(30); view_user_acc_status varchar2(30); begin repos_pwd := ?; sysman.mgmt_view_priv.get_view_user(view_user); select account_status into view_user_acc_status from sys.dba_users where upper(username) = upper ( view_user ); IF view_user_acc_status like '%LOCKED%' THEN execute immediate 'alter user ' || view_user || ' account unlock'; END IF; IF view_user_acc_status like '%EXPIRED%' THEN sysman.mgmt_view_priv.set_view_user_creds ( repos_pwd ); sysman.mgmt_view_priv.GET_VIEW_USER_CREDS ( view_user, view_user_pwd ); execute immediate 'alter user ' || view_user || ' identified by ' || view_user_pwd || ''; END IF; end;
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
解决方案 »
- 如何编写oracle的存储过程实现数据库备份,求代码
- 新建的用户应该授什么权
- oracle 9.2.0.7 exp时出错,急啊
- 服务器不能监听
- 执行计划中每一项的所反映含义 哪里有介绍的
- 急:PL/SQL 登陆 Oracle 10g 提示 ORA-12154:TNS:无法解析指定的连接标识符
- 初学疑问
- oracle有没有类似sqlserver的企业管理器?
- sys用户为什么不能连接呢?
- 有谁知道ORACLE的保存插入的数据临时表的位置.
- oracle中between..and..的非常容易错误的使用点:字符串,数字的区间比较
- oracle数据库在官网下载只下载了file1文件 导致数据库没有scott用户
2016-4-26 16:56:03 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
配置: Unlocked mgmt_view account
2016-4-26 16:56:03 oracle.sysman.emcp.EMReposConfig invoke
配置: Successfully unlocked mgmt_view account
2016-4-26 16:56:03 oracle.sysman.emcp.ParamsManager getParam
配置: 未设置参数 ORACLE_HOSTNAME 的值。
2016-4-26 16:56:03 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
信息: 正在将配置数据上载到 EM 资料档案库 (此操作可能需要一段时间)...
2016-4-26 16:59:05 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
配置: 将配置数据上载到资料档案库时出错
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
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)
2016-4-26 16:59:05 oracle.sysman.emcp.EMReposConfig invoke
信息: 有关详细资料, 请参阅 D:\app\Administrator\cfgtoollogs\emca\orcl\emca_repos_config_<日期>.log 中的日志文件。
2016-4-26 16:59:05 oracle.sysman.emcp.EMReposConfig invoke
严重: 将配置数据上载到资料档案库时出错
2016-4-26 16:59:05 oracle.sysman.emcp.EMConfig perform
严重: 将配置数据上载到资料档案库时出错
有关详细资料, 请参阅 D:\app\Administrator\cfgtoollogs\emca\orcl\emca_2016_04_26_16_50_31.log 中的日志文件。
2016-4-26 16:59:05 oracle.sysman.emcp.EMConfig perform
配置: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: 将配置数据上载到资料档案库时出错
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:397)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
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)
2016-4-26 16:59:05 oracle.sysman.emcp.EMConfig restoreOuiLoc
配置: Restoring oracle.installer.oui_loc to D:\app\Administrator\product\11.2.0\dbhome_1\oui
应该是一些对象已经存在了,创建失败;