急求大神帮助,,,Oracle数据库问题,EM在将配置数据上载到资料档案库时出错
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 的值。