Home » RDBMS Server » Enterprise Manager » Cannot connect to Database Control-orcl (Oracle 10g Enterprise Edition 10.2.0.4 64 bit; Vista 64 bit)
Cannot connect to Database Control-orcl [message #396734] Tue, 07 April 2009 20:37 Go to next message
jsresume74
Messages: 5
Registered: April 2009
Junior Member
I can't seem to connect, using my browser, to the Database Control-orcl after installing Oracle 10g Enterprise Edition 10.2.0.4 64 bit

I have Windows Vista 64 Home Premium SP1.
I installed 10g, then uninstalled( later realizing that it was an unclean uninstall, then re-installed successfully.


I try to connect to https://<<my_pc_ip>>:1158/em but the page cannot be displayed.
After "Diagnose Connection Problems" I get "<<my_pc_ip>>" is not set up to establish a connection on port 1158 with this computer.

I've looked at many threads and I've run >emca -config dbcontrol db -repos recreate several times as well as the emca -reconfig dbcontrol drop ....

>emca -config dbcontrol db -repos recreate
got error in emca_repos_create_20090407.....

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


I'm quite lost.
Thanks,
Jeff
Re: Cannot connect to Database Control-orcl [message #396864 is a reply to message #396734] Wed, 08 April 2009 03:39 Go to previous messageGo to next message
babuknb
Messages: 1733
Registered: December 2005
Location: NJ
Senior Member


Try

Set ORACLE_SID & ORACLE_HOME

1/ emca -deconfig dbcontrol db -repos drop

2/ emca -config dbcontrol db -repos create


Babu
Re: Cannot connect to Database Control-orcl [message #396924 is a reply to message #396864] Wed, 08 April 2009 07:10 Go to previous messageGo to next message
jsresume74
Messages: 5
Registered: April 2009
Junior Member
>set ORACLE_SID=orcl

> emca -deconfig dbcontrol db -repos drop
INFO: Repository successfully dropped

> emca -config dbcontrol db -repos create
INFO: Repository successfully createdApr 8, 2009 7:39:14 AM oracle.sysman.emcp.util.PlatformInterface executeCommandWARNING: 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\xxx.xxx.0.3_orcl xxx.xxx.0.3:3938 xxx.xxx.0.3 orclApr 8, 2009 7:39:14 AM oracle.sysman.emcp.EMConfig performSEVERE: Error instantiating EM configuration filesRefer to the log file at C:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-04-08_07-36-16-AM.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\orcl\emca_2009-04-08_07-36-16-AM.log for more details.

Here is emca_2009-04-08_07-36-16-AM.log: Last few lines before error:

Creating directories...
Setting console properties ...
Setting log and trace files locations for Console ...
Setting log and trace files locations for Agent ...
Apr 8, 2009 7:39:14 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: OpenSCManager FAILED: Access is denied.

Service creation failed. Aborting...

Apr 8, 2009 7:39:14 AM 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\xxx.xxx.0.3_orcl xxx.xxx.0.3:3938 xxx.xxx.0.3 orcl Apr 8, 2009 7:39:14 AM oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFilesCONFIG: Failed to deploy state dirsApr 8, 2009 7:39:14 AM 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\orcl\emca_2009-04-08_07-36-16-AM.log for more details.Apr 8, 2009 7:39:14 AM oracle.sysman.emcp.EMConfig performCONFIG: 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)

Re: Cannot connect to Database Control-orcl [message #396929 is a reply to message #396924] Wed, 08 April 2009 07:17 Go to previous messageGo to next message
babuknb
Messages: 1733
Registered: December 2005
Location: NJ
Senior Member

Thanks.

Can you post complete log message using the "CODE" tag.

PS: In feature you need to follow OraFaq rules.
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Babu
Re: Cannot connect to Database Control-orcl [message #396978 is a reply to message #396734] Wed, 08 April 2009 09:32 Go to previous messageGo to next message
jsresume74
Messages: 5
Registered: April 2009
Junior Member
Here is entire contents of emca_2009-04-08_07-36-16-AM
Thanks,
Jeff

<code>
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag '-config' set to true
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'UPDATE_EMAIL' set to true
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'dbcontrol' set to true
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'create' set to true
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: ORACLE_HOME value: C:\oracle\product\10.2.0\db_1
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:36:16 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EM_HOME value: C:\oracle\product\10.2.0\db_1
Apr 8, 2009 7:36:20 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID value: orcl
Apr 8, 2009 7:36:20 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: orcl Host: 192.168.0.3 Node: null OH: C:\oracle\product\10.2.0\db_1 isDBC: false
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: orcl Host: 192.168.0.3 Node: null OH: C:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: orcl Host: 192.168.0.3 Node: null OH: C:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Apr 8, 2009 7:36:21 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user:
Apr 8, 2009 7:36:22 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:36:22 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
Apr 8, 2009 7:36:22 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
Apr 8, 2009 7:36:26 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: PORT value: 1521
Apr 8, 2009 7:36:29 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Apr 8, 2009 7:36:29 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:36:30 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:36:33 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: DBSNMP
Apr 8, 2009 7:36:34 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:36:46 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: EMAIL_ADDRESS value:
Apr 8, 2009 7:36:49 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: MAIL_SERVER_NAME value:
Apr 8, 2009 7:36:49 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:36:49 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value:
Apr 8, 2009 7:36:59 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: CONFIRMATION ANSWER value: yes
Apr 8, 2009 7:36:59 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LOG_FILE.
Apr 8, 2009 7:36:59 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Apr 8, 2009 7:36:59 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Apr 8, 2009 7:36:59 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:00 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:00 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
Apr 8, 2009 7:37:00 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
Apr 8, 2009 7:37:00 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2009-04-08_07-36-16-AM.log.
Apr 8, 2009 7:37:00 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'CHECK_CONFIG' set to true
Apr 8, 2009 7:37:00 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:01 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:01 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: DBSNMP
Apr 8, 2009 7:37:02 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:02 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Apr 8, 2009 7:37:02 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:03 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:03 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'asm_db' set to false
Apr 8, 2009 7:37:03 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Apr 8, 2009 7:37:03 AM oracle.sysman.emcp.DatabaseChecks getDbServiceName
CONFIG: No service name available. Will try to set db_unique_name.db_domain
Apr 8, 2009 7:37:03 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value:
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: orcl
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBID.
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.DatabaseChecks getDbid
CONFIG: No dbid available. Will query db to extract it.
Apr 8, 2009 7:37:04 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBID value: 1210929979
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'db' set to true
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.DatabaseChecks getDbServiceName
CONFIG: No service name available. Will try to set db_unique_name.db_domain
Apr 8, 2009 7:37:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value:
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
CONFIG: No Database unique name available. Will try to retrieve it from DB itself
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DB_UNIQUE_NAME value: orcl
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SERVICE_NAME value: orcl
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
Apr 8, 2009 7:37:06 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:07 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:07 AM oracle.sysman.emcp.EMDBPreConfig invoke
CONFIG: Passed repository configuration check
Apr 8, 2009 7:37:07 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Apr 8, 2009 7:37:07 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MODIFY_SID.
Apr 8, 2009 7:37:07 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
Apr 8, 2009 7:37:07 AM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
Apr 8, 2009 7:37:07 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DB_DOMAIN.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.DatabaseChecks getDbDomain
CONFIG: No db domain available. Will query db for db_domain parameter
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: orcl
Apr 8, 2009 7:37:08 AM 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
Apr 8, 2009 7:37:08 AM 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
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file C:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties to C:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca.tmp
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.FileUtil backupFile
CONFIG: The original file C:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties has been copied to C:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties.emca.tmp
Apr 8, 2009 7:37:08 AM 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
Apr 8, 2009 7:37:08 AM 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
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_RECONFIG' set to false
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
CONFIG: Sid: orcl Host: 192.168.0.3 Node: null OH: C:\oracle\product\10.2.0\db_1 agentHome: null isCentral: false
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: orcl Host: 192.168.0.3 Node: null OH: C:\oracle\product\10.2.0\db_1 isDBC: false
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setFlag
CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to false
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
CONFIG: Sid: orcl Host: 192.168.0.3 Node: null OH: C:\oracle\product\10.2.0\db_1 isDBC: false
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter PORTS_FILE.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to C:\oracle\product\10.2.0\db_1\oui
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
CONFIG: Setting oracle.installer.oui_loc to C:\oracle\product\10.2.0\db_1\oui
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.OUIInventoryUtil isValidOH
CONFIG: Invalid oracleHome: C:\oracle\product\10.2.0\db_2
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Homes to scan for used ports: [C:\oracle\product\10.2.0\db_1]
Apr 8, 2009 7:37:08 AM 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
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking JMS port: null from C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking RMI port: null from C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking HTTP port: null from C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager getAgentPort
CONFIG: Cannot parse EMD_URL correctly. No port identified
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Marking Agent port: null from C:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager markAllUsedPorts
CONFIG: Cannnot parse EMD_URL correctly. No port identified
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.FileUtil getProperties
CONFIG: Error reading file C:\oracle\product\10.2.0\db_1\install\staticports.ini
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.PortManager getFreePorts
CONFIG: C:\oracle\product\10.2.0\db_1:192.168.0.3:null:orcl:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter AGENT_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: AGENT_PORT_orcl value: 3938
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: DBCONTROL_HTTP_PORT_orcl value: 1158
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter JMS_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: JMS_PORT_orcl value: 5540
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter RMI_PORT_orcl.
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: RMI_PORT_orcl value: 5520
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.EMDBPreConfig getFreePorts
CONFIG: Ports assigned for SID: orcl : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
Apr 8, 2009 7:37:08 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:37:09 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:37:09 AM oracle.sysman.emcp.EMReposConfig createRepository
CONFIG: Spooling to C:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_repos_create_2009-04-08_07-37-09-AM.log
Apr 8, 2009 7:37:09 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 8, 2009 7:39:05 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 8, 2009 7:39:05 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:39:06 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:39:06 AM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully granted priviliges to dbsnmp.
Apr 8, 2009 7:39:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
Apr 8, 2009 7:39:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
Apr 8, 2009 7:39:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_NAME.
Apr 8, 2009 7:39:06 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_ADDR.
Apr 8, 2009 7:39:06 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYS
Apr 8, 2009 7:39:07 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:39:07 AM oracle.sysman.emcp.EMReposConfig unlockAccounts
CONFIG: Unlocking dbsnmp and sysman
Apr 8, 2009 7:39:07 AM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked relevant accounts
Apr 8, 2009 7:39:07 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYSMAN
Apr 8, 2009 7:39:08 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:39:10 AM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Finished executing emreposoutofbox.sql
Apr 8, 2009 7:39:10 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\oracle\product\10.2.0\db_1, and user: SYSMAN
Apr 8, 2009 7:39:11 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: SQLEngine created successfully and connected
Apr 8, 2009 7:39:11 AM 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
Apr 8, 2009 7:39:11 AM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
CONFIG: Successfully submitted dbms job
Apr 8, 2009 7:39:11 AM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocking mgmt view user account
Apr 8, 2009 7:39:11 AM 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;
Apr 8, 2009 7:39:11 AM 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-x64-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 orcl 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
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 0
Apr 8, 2009 7:39:12 AM 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-x64-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 orcl 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
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Arguments passed C:\oracle\product\10.2.0\db_1 orcl 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 orcl 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.

Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.EMReposConfig unlockMGMTAccount
CONFIG: Unlocked mgmt_view account
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.EMReposConfig invoke
CONFIG: Successfully unlocked mgmt_view account
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.EMDBCConfig updateEmomsProps
CONFIG: Updating file C:\oracle\product\10.2.0\db_1\sysman\config\emoms.properties ...
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:12 AM 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
Apr 8, 2009 7:39:12 AM 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
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:12 AM 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
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Apr 8, 2009 7:39:12 AM 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_192.168.0.3_orcl
Apr 8, 2009 7:39:12 AM oracle.sysman.emcp.util.FileUtil _makeDirectory
CONFIG: Create directory C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\config
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\application.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\data-sources.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\global-web-application.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\http-web-site.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\internal-settings.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\java2.policy
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\jazn-data.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\jazn.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\jms.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\mime.types
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\oc4j-connectors.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\principals.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\rmi.xml
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\config\server.xml
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.FileUtil _makeDirectory
CONFIG: Create directory C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\META-INF
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\META-INF\MANIFEST.MF
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.FileUtil _makeDirectory
CONFIG: Create directory C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\application-deployments\default\defaultWebApp
Apr 8, 2009 7:39:13 AM 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_192.168.0.3_orcl\application-deployments\default\defaultWebApp\orion-web.xml
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.EMDBCConfig copyOC4JDir
CONFIG: Finished copying OC4J config files
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\config\jms.xml.emca.util.tmp to C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\config\jms.xml
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\config\rmi.xml.emca.util.tmp to C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\config\rmi.xml
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.FileUtil _copyFile
CONFIG: Completed copying file C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\config\http-web-site.xml.emca.util.tmp to C:\oracle\product\10.2.0\db_1\oc4j\j2ee\OC4J_DBConsole_192.168.0.3_orcl\config\http-web-site.xml
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_SENDER_NAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter EMAIL_ADDRESS.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter MAIL_SERVER_NAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.EMAgentConfig updateEmdProps
CONFIG: Updating file C:\oracle\product\10.2.0\db_1\sysman\config\emd.properties ...
Apr 8, 2009 7:39:13 AM 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
Apr 8, 2009 7:39:13 AM 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
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.EMAgentConfig updateAgentConfigFiles
CONFIG: Updating file C:\oracle\product\10.2.0\db_1\sysman\config\emd.properties ...
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.EMAgentConfig updateTargets
CONFIG: value for use102tgt: false
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.target.TargetManager removeAllTargets
CONFIG: Failed to remove all the necessary targets from targets.xml
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER_OH.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getListenerHome
CONFIG: LISTENER_OH not set. Using ORACLE_HOME as listener's home.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER_OH.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getListenerHome
CONFIG: LISTENER_OH not set. Using ORACLE_HOME as listener's home.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter LISTENER_OH.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getListenerHome
CONFIG: LISTENER_OH not set. Using ORACLE_HOME as listener's home.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getLocalListener
CONFIG: Found listener named: LISTENER
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.EMAgentConfig updateAgentConfigFiles
CONFIG: Updating file C:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml ...
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFiles
CONFIG: Local host name: 192.168.0.3
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
CONFIG: Value for env var 'TZ' is '', discarding the same
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList
CONFIG: Value for env var 'ORACLE_HOSTNAME' is '', discarding the same
Apr 8, 2009 7:39:13 AM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
CONFIG: New Env List: [
ALLUSERSPROFILE=C:\ProgramData,
APPDATA=C:\Users\Jeff Schaffner\AppData\Roaming,
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\produ ct\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\pr oduct\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\ass istantsCommon.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:\ora cle\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\prod uct\10.2.0\db_1\oui\jlib\OraPrereqChecks.jar;,
COMMONPROGRAMFILES=C:\Program Files\Common Files,
COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files,
COMPUTERNAME=HP-JRS-90,
COMSPEC=C:\Windows\system32\cmd.exe,
DFSTRACINGON=FALSE,
EMCA_JAR=C:\oracle\product\10.2.0\db_1\jlib\emca.jar,
FP_NO_HOST_CHECK=NO,
HOMEDRIVE=C:,
HOMEPATH=\Users\Jeff Schaffner,
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,
LOCALAPPDATA=C:\Users\Jeff Schaffner\AppData\Local,
LOGONSERVER=\\HP-JRS-90,
NEED_EXIT_CODE=1,
NUMBER_OF_PROCESSORS=2,
OH=C:\oracle\product\10.2.0\db_1,
ONLINESERVICES=Online Services,
ORACLE_SID=orcl,
OS=Windows_NT,
PATH=C:\oracle\product\10.2.0\db_1\jdk\jre\bin\server;C:\oracle\product\10.2.0\db_1\bin;C:\oracle\product\10.2.0\db_2\bin;C:\Windows\ system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\CyberLink\Power2Go;c:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PCBRAND=Pavilion, PERL5LIB=C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x64;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-x64;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;C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x64;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-x64;C:\oracle\product\10.2.0\db_1\perl\site\5.8.3;C:\oracle\pr oduct\10.2.0\db_1\perl\site\5.8.3\lib;C:\oracle\product\10.2.0\db_1\sysman\admin\scripts, PLATFORM=MCD, PROCESSOR_ARCHITECTURE=AMD64,
PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 23 Stepping 10, GenuineIntel,
PROCESSOR_LEVEL=6,
PROCESSOR_REVISION=170a,
PROGRAMDATA=C:\ProgramData,
PROGRAMFILES=C:\Program Files,
PROGRAMFILES(X86)=C:\Program Files (x86),
PROMPT=$P$G,
PUBLIC=C:\Users\Public,
SESSIONNAME=Console,
SYSTEMDRIVE=C:,
SYSTEMROOT=C:\Windows,
TEMP=C:\Users\JEFFSC~1\AppData\Local\Temp,
TMP=C:\Users\JEFFSC~1\AppData\Local\Temp,
TRACE_FORMAT_SEARCH_PATH=\\NTREL202.ntdev.corp.microsoft.com\34FB5F65-FFEB-4B61-BF0E-A6A76C450FAA\TraceFormat,
USERDOMAIN=HP-JRS-90,
USERNAME=Jeff Schaffner,
USERPROFILE=C:\Users\Jeff Schaffner,
WINDIR=C:\Windows]
Apr 8, 2009 7:39:13 AM 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\192.168.0.3_orcl 192.168.0.3:3938 192.168.0.3 orcl
Apr 8, 2009 7:39:14 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 255
Apr 8, 2009 7:39:14 AM 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\192.168.0.3_orcl
DeployMode : dbconsole

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

Apr 8, 2009 7:39:14 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: OpenSCManager FAILED: Access is denied.


Service creation failed. Aborting...

Apr 8, 2009 7:39:14 AM 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\192.168.0.3_orcl 192.168.0.3:3938 192.168.0.3 orcl
Apr 8, 2009 7:39:14 AM oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFiles
CONFIG: Failed to deploy state dirs
Apr 8, 2009 7:39:14 AM 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\orcl\emca_2009-04-08_07-36-16-AM.log for more details.
Apr 8, 2009 7:39:14 AM 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)
</code>
Re: Cannot connect to Database Control-orcl [message #397010 is a reply to message #396978] Wed, 08 April 2009 11:01 Go to previous messageGo to next message
babuknb
Messages: 1733
Registered: December 2005
Location: NJ
Senior Member

Apr 8, 2009 7:39:14 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: OpenSCManager FAILED: Access is denied.



Do you have admin access??
Re: Cannot connect to Database Control-orcl [message #397015 is a reply to message #397010] Wed, 08 April 2009 11:21 Go to previous messageGo to next message
jsresume74
Messages: 5
Registered: April 2009
Junior Member
Yes, I do have administrator privelidges on this laptop.
My user is an administrator. I personally own the laptop. I've noticed that on Windows vista some programs have to be set to run as administrator before they can launch. This may be one case.
Babu, can you tell what program is failing because of insufficient privs?
Thanks,
Jeff
Re: Cannot connect to Database Control-orcl [message #397023 is a reply to message #397015] Wed, 08 April 2009 12:05 Go to previous messageGo to next message
babuknb
Messages: 1733
Registered: December 2005
Location: NJ
Senior Member

In your local users and groups add adminrights to ORA_DBA group.

and then try to create.
Re: Cannot connect to Database Control-orcl [message #397043 is a reply to message #397023] Wed, 08 April 2009 13:05 Go to previous messageGo to next message
jsresume74
Messages: 5
Registered: April 2009
Junior Member
Babu,

The windows help file says:
To create a user group
Note:



    These steps cannot be completed on Windows Vista Starter, Windows Vista Home Basic, and Windows Vista Home Premium.


I have windows Vista Home Premuim, so this setting can't be done.


Re: Cannot connect to Database Control-orcl [message #397047 is a reply to message #397043] Wed, 08 April 2009 13:18 Go to previous message
babuknb
Messages: 1733
Registered: December 2005
Location: NJ
Senior Member

>>I've noticed that on Windows vista some programs have to be set to run as administrator before they can launch

ASAIK; If you have admin rights in vista also; Before doing any activity vista ask permission to execute.

May be this is also problem.

I recommend to you;

1/ You need migrate your OS from vista to XP Or Win 2000 Or
2/ Try to contact oracle support

I'm sure; This is not related to oracle problem.

Babu

[Updated on: Wed, 08 April 2009 13:19]

Report message to a moderator

Previous Topic: Grid control agent not starting
Next Topic: Generating AWR report in $ORACLE-HOME dir
Goto Forum:
  


Current Time: Fri Oct 24 14:17:29 CDT 2014

Total time taken to generate the page: 0.26196 seconds