07.07.2009 15:04
Arsen
 
Цитата:
ReDHawK Если пересоздавать репозиторий для БД созданной на этой же машине, то проблем нет, если для перенесенной с другой тачки, то да, проблемки с ним. Так что в след. раз для перенесенной попробую твой способ.
правильно если база перенесена с другой машины то в репозитории остаются прописки рослушивателя другой машины.
07.07.2009 16:35
ReDHawK
 
Цитата:
Arsen правильно если база перенесена с другой машины то в репозитории остаются прописки рослушивателя другой машины.
так не часто репозиторий пересоздается, у меня просто ноут, и в разных сетях приходиться тыкаться, IP вечно разный, так что для меня мой способ самый быстрый, пока был. :) вот Олегу Ораклоиды подогнали скриптики, думаю буду пользоваться ими, если все будет пучком $-)
09.07.2009 12:23
OlegON
 
Для особо запущенных случаев:
Цитата:
1. Please set the following environment variables
ORACLE_SID
ORACLE_HOSTNAME

2.Delete DB Control Configuration Files Manually:
- Remove the following directories from your filesystem:
<ORACLE_HOME>/<hostname_sid>
<ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname>_<sid>


3. Delete DB Control Repository Objects Manually

Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and management
objects:
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP RESTRICT;
SQL> EXEC sysman.emd_maintenance.remove_em_dbms_jobs;
SQL> EXEC sysman.setEMUserContext('',5);
SQL> REVOKE dba FROM sysman;
SQL> DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN';
BEGIN
FOR r1 IN c1 LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;
/
SQL> DROP USER mgmt_view CASCADE;
SQL> DROP ROLE mgmt_user;
SQL> DROP USER sysman CASCADE;
SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;

The above will completely delete the DB Control repository from the database;
under certain circumstances (e.g. you want to recreate the repository later on)
the following statements may be sufficient to remove the repository:

Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and
management objects:
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;


4.Having done the above, it is recommended that you reboot the machine once.
This step is often skiped but many times we have found that in Windows systems,
a reboot becomes essential.

5. Create the DB Control Repository Objects and Configuration Files
<ORACLE_HOME>bin/emca -config dbcontrol db -repos drop
<ORACLE_HOME>bin/emca -config dbcontrol db -repos create

6. Then check the following:
6.1 emctl start dbconsole (any errors?)
6.2 emctl status dnconsole
6.3 emctl status agent
6.4 emctl upload
19.01.2011 13:25
AirAir
 
Добрый день!
У меня используется oracle 10g 10.2.0.4.
пересоздал репозиторий так как описано в сообщении выше(Олега).
Удаление репозитория прошло хорошо, а при создании выдал ошибку
поднасрал:

C:\oracle\product\10.2.0\db_1\BIN>emca -config dbcontrol db -repos create

STARTED EMCA at 19.01.2011 13:03:59
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: tornado
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ c:\oracle\product\10.2.0\db_1

Database hostname ................ sm2000uz
Listener port number ................ 1521
Database SID ................ tornado
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
19.01.2011 13:04:22 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at c:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\tornado\emca_2011-01-19_01-03-59-PM.log.
19.01.2011 13:04:23 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
19.01.2011 13:05:54 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
19.01.2011 13:05:59 oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing CMD /C c:\oracle\product\10.2.0\db_1\bin\emctl.bat depl
oy dbconsole c:\oracle\product\10.2.0\db_1\sm2000uz_tornado sm2000uz:3938 sm2000
uz tornado
19.01.2011 13:05:59 oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at c:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\tornado\
emca_2011-01-19_01-03-59-PM.log for more details.
Could not complete the configuration. Refer to the log file at c:\oracle\product
\10.2.0\db_1\cfgtoollogs\emca\tornado\emca_2011-01-19_01-03-59-PM.log for more d
etails.
C:\oracle\product\10.2.0\db_1\BIN>


в логе написано следующее:
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-config' set to true
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'UPDATE_EMAIL' set to true
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'dbcontrol' set to true
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'create' set to true
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: ORACLE_HOME value: c:\oracle\product\10.2.0\db_1
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:03:59 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_HOME value: c:\oracle\product\10.2.0\db_1
19.01.2011 13:04:04 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID value: tornado
19.01.2011 13:04:04 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:04 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
19.01.2011 13:04:04 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
19.01.2011 13:04:04 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:04 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: tornado Host: sm2000uz Node: null OH: c:\oracle\product\10.2.0\db_1 isDBC: false
19.01.2011 13:04:04 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: tornado Host: sm2000uz Node: null OH: c:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
19.01.2011 13:04:04 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: tornado Host: sm2000uz Node: null OH: c:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
19.01.2011 13:04:04 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
19.01.2011 13:04:04 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user:
19.01.2011 13:04:04 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:04 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
19.01.2011 13:04:04 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
19.01.2011 13:04:12 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: PORT value: 1521
19.01.2011 13:04:14 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
19.01.2011 13:04:14 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:14 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:16 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: DBSNMP
19.01.2011 13:04:16 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:19 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EMAIL_ADDRESS value:
19.01.2011 13:04:20 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: MAIL_SERVER_NAME value:
19.01.2011 13:04:20 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:20 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value:
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value: yes
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LOG_FILE.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: tornado
19.01.2011 13:04:22 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at c:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\tornado\emca_2011-01-19_01-03-59-PM.log.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'CHECK_CONFIG' set to true
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: DBSNMP
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbServiceName
CONFIG: No service name available. Will try to set db_unique_name.db_domain
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value:
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: tornado
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: tornado
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: tornado
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBID.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbid
CONFIG: No dbid available. Will query db to extract it.
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBID value: 426237163
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbServiceName
CONFIG: No service name available. Will try to set db_unique_name.db_domain
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value:
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: tornado
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: tornado
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: tornado
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:22 oracle.sysman.emcp.EMDBPreConfig invoke
CONFIG: Passed repository configuration check
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
19.01.2011 13:04:22 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
19.01.2011 13:04:22 oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
19.01.2011 13:04:22 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:23 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
19.01.2011 13:04:23 oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: tornado
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties to c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca.tmp
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties has been copied to c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca.tmp
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca to c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca has been copied to c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml to c:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml.emca.tmp
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file c:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml has been copied to c:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml.emca.tmp
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:23 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:23 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
19.01.2011 13:04:23 oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: tornado Host: sm2000uz Node: null OH: c:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
19.01.2011 13:04:23 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: tornado Host: sm2000uz Node: null OH: c:\oracle\product\10.2.0\db_1 isDBC: false
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:23 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
19.01.2011 13:04:23 oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: tornado Host: sm2000uz Node: null OH: c:\oracle\product\10.2.0\db_1 isDBC: false
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter PORTS_FILE.
19.01.2011 13:04:23 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
19.01.2011 13:04:23 oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to c:\oracle\product\10.2.0\db_1\oui
19.01.2011 13:04:23 oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to c:\oracle\product\10.2.0\db_1\oui
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Homes to scan for used ports: [c:\oracle\product\10.2.0\db_1, C:\oracle\client]
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME c:\oracle\product\10.2.0\db_1
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking JMS port: null from c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking RMI port: null from c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking HTTP port: null from c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager getAgentPort
CONFIG: Cannot parse EMD_URL correctly. No port identified
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: null from c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Cannnot parse EMD_URL correctly. No port identified
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME C:\oracle\client
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil getProperties
CONFIG: Error reading file C:\oracle\client\sysman\config\emd.properties
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager getAgentPort
CONFIG: Cannot parse EMD_URL correctly. No port identified
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: null from C:\oracle\client\sysman\config\emd.properties
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Cannnot parse EMD_URL correctly. No port identified
19.01.2011 13:04:23 oracle.sysman.emcp.util.FileUtil getProperties
CONFIG: Error reading file c:\oracle\product\10.2.0\db_1\install\staticports.ini
19.01.2011 13:04:23 oracle.sysman.emcp.util.PortManager getFreePorts
CONFIG: c:\oracle\product\10.2.0\db_1:sm2000uz:null:tornado:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: AGENT_PORT_tornado value: 3938
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBCONTROL_HTTP_PORT_tornado value: 1158
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: JMS_PORT_tornado value: 5540
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_tornado.
19.01.2011 13:04:23 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: RMI_PORT_tornado value: 5520
19.01.2011 13:04:23 oracle.sysman.emcp.EMDBPreConfig getFreePorts
CONFIG: Ports assigned for SID: tornado : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
19.01.2011 13:04:23 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:04:23 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:04:23 oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: Spooling to c:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\tornado\emca_repos_create_2011-01-19_01-04-23-PM.log
19.01.2011 13:04:23 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
19.01.2011 13:05:54 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
19.01.2011 13:05:54 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:05:54 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:05:54 oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully granted priviliges to dbsnmp.
19.01.2011 13:05:54 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
19.01.2011 13:05:54 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
19.01.2011 13:05:54 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_NAME.
19.01.2011 13:05:54 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_ADDR.
19.01.2011 13:05:54 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYS
19.01.2011 13:05:54 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:05:54 oracle.sysman.emcp.EMReposConfig unlockAccounts
CONFIG: Unlocking dbsnmp and sysman
19.01.2011 13:05:54 oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked relevant accounts
19.01.2011 13:05:54 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYSMAN
19.01.2011 13:05:54 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:05:55 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Finished executing emreposoutofbox.sql
19.01.2011 13:05:55 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: tornado, oracleHome: c:\oracle\product\10.2.0\db_1, and user: SYSMAN
19.01.2011 13:05:55 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
19.01.2011 13:05:55 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Submitting dbms job: c:\oracle\product\10.2.0\db_1\sysman\admin\emdrep\sql\core\latest\admin\admin_submit_dbms_jobs.sql
19.01.2011 13:05:55 oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Successfully submitted dbms job
19.01.2011 13:05:55 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocking mgmt view user account
19.01.2011 13:05:55 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: 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;
19.01.2011 13:05:55 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Starting execution: CMD /C c:\oracle\product\10.2.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.bat "c:\oracle\product\10.2.0\db_1\sysman\admin\scripts;c:\oracle\product\10.2.0\db_1\bin;" c:/oracle/product/10.2.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe c:\oracle\product\10.2.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.pl c:\oracle\product\10.2.0\db_1 tornado SYS SYSDBA 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; 1 SYSMAN_PWD
19.01.2011 13:05:56 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 0
19.01.2011 13:05:56 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Execution of CMD /C c:\oracle\product\10.2.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.bat "c:\oracle\product\10.2.0\db_1\sysman\admin\scripts;c:\oracle\product\10.2.0\db_1\bin;" c:/oracle/product/10.2.0/db_1/perl/5.8.3/bin/MSWin32-x86-multi-thread\perl.exe c:\oracle\product\10.2.0\db_1\sysman\admin\scripts\emca\emcaDbUtil.pl c:\oracle\product\10.2.0\db_1 tornado SYS SYSDBA 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; 1 SYSMAN_PWD completed successfully
19.01.2011 13:05:56 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Arguments passed c:\oracle\product\10.2.0\db_1 tornado SYS SYSDBA 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; 1 SYSMAN_PWD

Connecting to database tornado in home c:\oracle\product\10.2.0\db_1 with user "SYS" role "SYSDBA".
connected to database.
sql to execute 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;
noOfParams to bind: 1.
sql execute successfully.

19.01.2011 13:05:56 oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
19.01.2011 13:05:56 oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:56 oracle.sysman.emcp.EMDBCConfig updateEmomsProps
CONFIG: Updating file c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties ...
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca to c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca.util.tmp to c:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\server.xml.emca.util.tmp to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\server.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
19.01.2011 13:05:56 oracle.sysman.emcp.EMDBCConfig copyOC4JDir
CONFIG: Copying OC4J config files from c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _makeDirectory
CONFIG: Create directory c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\application.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\application.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\data-sources.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\data-sources.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\global-web-application.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\global-web-application.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\http-web-site.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\http-web-site.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\internal-settings.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\internal-settings.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\java2.policy to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\java2.policy
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\jazn-data.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\jazn-data.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\jazn.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\jazn.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\jms.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\jms.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\mime.types to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\mime.types
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\oc4j-connectors.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\oc4j-connectors.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\principals.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\principals.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\rmi.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\rmi.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\config\server.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\server.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _makeDirectory
CONFIG: Create directory c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\META-INF
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\META-INF\MANIFEST.MF to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\META-INF\MANIFEST.MF
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _makeDirectory
CONFIG: Create directory c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\application-deployments\default\defaultWebApp
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole\application-deployments\default\defaultWebApp\orion-web.xml to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\application-deployments\default\defaultWebApp\orion-web.xml
19.01.2011 13:05:56 oracle.sysman.emcp.EMDBCConfig copyOC4JDir
CONFIG: Finished copying OC4J config files
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\jms.xml.emca.util.tmp to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\jms.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\rmi.xml.emca.util.tmp to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\rmi.xml
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\http-web-site.xml.emca.util.tmp to c:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_sm2000uz_tornado\config\http-web-site.xml
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_NAME.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:56 oracle.sysman.emcp.EMAgentConfig updateEmdProps
CONFIG: Updating file c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties ...
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca to c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
19.01.2011 13:05:56 oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca.util.tmp to c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
19.01.2011 13:05:56 oracle.sysman.emcp.EMAgentConfig updateAgentConfigFiles
CONFIG: Updating file c:\oracle\product\10.2.0\db_1\sysman\config\emd.properties ...
19.01.2011 13:05:56 oracle.sysman.emcp.EMAgentConfig updateTargets
CONFIG: value for use102tgt: false
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER_OH.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getListenerHome
CONFIG: LISTENER_OH not set. Using ORACLE_HOME as listener's home.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER_OH.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getListenerHome
CONFIG: LISTENER_OH not set. Using ORACLE_HOME as listener's home.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER_OH.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getListenerHome
CONFIG: LISTENER_OH not set. Using ORACLE_HOME as listener's home.
19.01.2011 13:05:56 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:57 oracle.sysman.emcp.ParamsManager getLocalListener
CONFIG: Found listener named: LISTENER
19.01.2011 13:05:57 oracle.sysman.emcp.EMAgentConfig updateAgentConfigFiles
CONFIG: Updating file c:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml ...
19.01.2011 13:05:57 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
19.01.2011 13:05:57 oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFiles
CONFIG: Local host name: sm2000uz
19.01.2011 13:05:57 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
19.01.2011 13:05:57 oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
CONFIG: Value for env var 'TZ' is '', discarding the same
19.01.2011 13:05:57 oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
CONFIG: New Env List: [ALLUSERSPROFILE=C:\Documents and Settings\All Users, APPDATA=C:\Documents and Settings\¤¬ЁЁбвав®а\Application Data, CLASSPATH=c:\oracle\product\10.2.0\db_1\jlib\emca.jar;c:\oracle\product\10.2.0\db_1\jlib\srvm.jar;c:\oracle\product\10.2.0\db_1\jlib\srvmasm.jar;c:\oracle\product\10.2.0\db_1\jlib\emConfigInstall.jar;c:\oracle\product\10.2.0\db_1\jlib\ldapjclnt10.jar;c:\oracle\product\10.2.0\db_1\jlib\ldap.jar;c:\oracle\product\10.2.0\db_1\jlib\share.jar;c:\oracle\product\10.2.0\db_1\jlib\srvmhas.jar;c:\oracle\product\10.2.0\db_1\jlib\netcfg.jar;c:\oracle\product\10.2.0\db_1\lib\xmlparserv2.jar;c:\oracle\product\10.2.0\db_1\assistants\jlib\assistantsCommon.jar;c:\oracle\product\10.2.0\db_1\sysman\jlib\emCORE.jar;c:\oracle\product\10.2.0\db_1\oui\jlib\OraInstaller.jar;c:\oracle\product\10.2.0\db_1\oui\jlib\OraPrereq.jar;c:\oracle\product\10.2.0\db_1\inventory\prereqs\oui\OraPrereqChecks.jar;c:\oracle\product\10.2.0\db_1\oui\jlib\OraPrereqChecks.jar;, CLIENTNAME=Console, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMPUTERNAME=SM2000UZ, COMSPEC=C:\WINDOWS\system32\cmd.exe, EMCA_JAR=c:\oracle\product\10.2.0\db_1\jlib\emca.jar, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Documents and Settings\¤¬ЁЁбвав®а, JRE_JAVA=c:\oracle\product\10.2.0\db_1\jdk\jre\bin\java, LIB_DIR=c:\oracle\product\10.2.0\db_1\jlib, LOGONSERVER=\\SM2000UZ, NEED_EXIT_CODE=1, NUMBER_OF_PROCESSORS=2, OH=c:\oracle\product\10.2.0\db_1, ORACLE_HOSTNAME=sm2000uz, ORACLE_SID=tornado, OS=Windows_NT, PATH=c:\oracle\product\10.2.0\db_1\jdk\jre\bin\server;C:\oracle\client\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;c:\oracle\product\10.2.0\db_1\bin;C:\orant\bin;C:\PROGRA~1\COMMON~1\BORLAN~1\BDE;C:\SM2000\Bin;, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH, PERL5LIB=c:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;c:\oracle\product\10.2.0\db_1\perl\5.8.3\lib;c:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;c:\oracle\product\10.2.0\db_1\perl\site\5.8.3;c:\oracle\product\10.2.0\db_1\perl\site\5.8.3\lib;c:\oracle\product\10.2.0\db_1\sysman\admin\scripts, PROCESSOR_ARCHITECTURE=x86, PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=0f0d, PROGRAMFILES=C:\Program Files, PROMPT=$P$G, REPORTS60_PATH=C:\SM2000\Report\, SESSIONNAME=RDP-Tcp#1, SYSTEMDRIVE=C:, SYSTEMROOT=C:\WINDOWS, TEMP=C:\DOCUME~1\9B35~1\LOCALS~1\Temp, TMP=C:\DOCUME~1\9B35~1\LOCALS~1\Temp, USERDOMAIN=SM2000UZ, USERNAME=Ђ¤¬ЁЁбвав®а, USERPROFILE=C:\Documents and Settings\¤¬ЁЁбвав®а, WINDIR=C:\WINDOWS]
19.01.2011 13:05:57 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Starting execution: CMD /C c:\oracle\product\10.2.0\db_1\bin\emctl.bat deploy dbconsole c:\oracle\product\10.2.0\db_1\sm2000uz_tornado sm2000uz:3938 sm2000uz tornado
19.01.2011 13:05:59 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 255
19.01.2011 13:05:59 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Creating shared install...
Source location: c:\oracle\product\10.2.0\db_1
Destination (shared install) : c:\oracle\product\10.2.0\db_1\sm2000uz_tornado
DeployMode : dbconsole

Creating directories...
Setting console properties ...
Setting log and trace files locations for Console ...
Setting log and trace files locations for Agent ...

19.01.2011 13:05:59 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: CreateService FAILED: Указанная служба уже существует.


Service creation failed. Aborting...

19.01.2011 13:05:59 oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing CMD /C c:\oracle\product\10.2.0\db_1\bin\emctl.bat deploy dbconsole c:\oracle\product\10.2.0\db_1\sm2000uz_tornado sm2000uz:3938 sm2000uz tornado
19.01.2011 13:05:59 oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFiles
CONFIG: Failed to deploy state dirs
19.01.2011 13:05:59 oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at c:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\tornado\emca_2011-01-19_01-03-59-PM.log for more details.
19.01.2011 13:05:59 oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error instantiating EM configuration files
at oracle.sysman.emcp.EMAgentConfig.updateAgentConfigFiles(EMAgentConfig.java:2689)
at oracle.sysman.emcp.EMAgentConfig.performConfiguration(EMAgentConfig.java:1206)
at oracle.sysman.emcp.EMAgentConfig.invoke(EMAgentConfig.java:230)
at oracle.sysman.emcp.EMAgentConfig.invoke(EMAgentConfig.java:208)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:175)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)
19.01.2011 13:34
AirAir
 
Подскажите пожалуйста что еще попробовать?
19.01.2011 13:45
AirAir
 
Если делаю так
удаляем конфиг dbcontrol'a
Код:

<ORACLE_HOME>bin/emca -deconfig dbcontrol db

2. проверяем что все удалили
Код:

SELECT user_name FROM dba_users WHERE username in ('SYSMAN', 'MGMT_VIEW ');

если что-то осталось то
Код:

drop user sysman cascade;
drop role MGMT_USER;
drop user MGMT_VIEW cascade;
drop public synonym MGMT_TARGET_BLACKOUTS;
drop public synonym SETEMVIEWUSERCONTEXT;

3. создаем конфиг и репозиторий
Код:

<ORACLE_HOME>/bin/emca -config dbcontrol db -repos recreate

Тогда
при создании пишет - служба создана, потом начинает её(службу) запускать и выдает ошибку
Do you wish to continue? [yes(Y)/no(N)]: y
19.01.2011 13:24:55 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at c:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\tornado\emca_2011-01-19_01-24-30-PM.log.
19.01.2011 13:24:56 oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
19.01.2011 13:24:56 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
19.01.2011 13:26:11 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
19.01.2011 13:26:15 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
19.01.2011 13:26:29 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
19.01.2011 13:26:29 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
19.01.2011 13:35:09 oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at c:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\tornado\
emca_2011-01-19_01-24-30-PM.log for more details.
Could not complete the configuration. Refer to the log file at c:\oracle\product
\10.2.0\db_1\cfgtoollogs\emca\tornado\emca_2011-01-19_01-24-30-PM.log for more d
etails.
19.01.2011 14:58
OlegON
 
Извини, но я этот транспарант читать не стал. Давай договоримся, что километрами логов ты больше засорять форум не будешь. В следующий раз кинь ошибку и ссылку на лог.
У меня ни разу на живой базе не было проблем после чистки для "запущенных случаев"
Но более правильно - отказаться от dbconsole навсегда. Оптимизатор рулит.
19.01.2011 15:07
AirAir
 
Понял!
Что значит запущенный случай?
Я консолью пользуюсь очень редко, не помню когда запускал её в посл.раз - у меня эта служба всегда остановлена, а тут преспичело.
Если я полностью oracle переставлю - должно заработать?
19.01.2011 15:53
OlegON
 
Для чего приспичило? Если переставишь, то может заработать, а может и нет.
Для запущенных случаев см. выше. Ни разу не подводил.
19.01.2011 16:15
AirAir
 
Иногда консолью удобно пользоваться - зашел и первые выводы о базе моно сделать - ожидания и т.д.
Часовой пояс GMT +3, время: 17:19.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.