ebrain

Thanks for posting.

I followed the same as per your previous reply dropping and recreating the repository but it didn't work. Dropping was successful but while creating it could not I am posting the results I got so that guyz on the forum can help me better.


When I was recreating I ended up with an saying

CONFIG: PRKC-1125 : Failed to start service "OracleDBConsolePRODFIN2" on node "sis-prod-db-4", [null]


where sis-prod-db-4 is my remotenode (second node) in the cluster of 2 nodes

FYI this is cluster installation on WINDOWS SERVER 2003 64-bit
ebrain if you have noticed from my first post

INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

PRODFIN1 sis-prod-db-3 sis-prod-db-3-priv.apu.edu
PRODFIN2 sis-prod-db-4 SIS-PROD-DB-4.fs.apu.edu

DBCONTROL_UPLOAD_HOST for instance one that is PRODFIN1 is on the private and

DBCONTROL_UPLOAD_HOST for instance 2 that is PRODFIN2 is on the public

I see there is something worng there ..i guess the DBCONTROL_UPLOAD_HOST should be public host for both the instances but I am not sure why is that its picking up private host auomatically....do u think my network connection are messed or what I have no idea why is picking up private...




these are the results of dropping and recreate the repository


DROPING

D:\oracle\product\10.2.0\prodcrm\BIN>emca -deconfig dbcontrol db -repos drop -cl
uster

STARTED EMCA at Mar 14, 2008 9:14:43 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database unique name: PRODFIN
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: y
Mar 14, 2008 9:16:13 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\prodcrm\cfgtool
logs\emca\PRODFIN\emca_2008-03-14_09-14-43-AM.log.
Mar 14, 2008 9:16:16 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 14, 2008 9:16:49 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Mar 14, 2008 9:36:13 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 14, 2008 9:36:13 AM


RECREATING

D:\oracle\product\10.2.0\prodcrm\BIN>emca -config dbcontrol db -repos create -cl
uster

STARTED EMCA at Mar 14, 2008 9:39:06 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database unique name: PRODFIN
Listener port number: 1521
Cluster name: PROD
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ D:\oracle\product\10.2.0\prodcrm ]: d:\oracle\product\10.2.0\a
sm
Invalid ORACLE_HOME.
ASM ORACLE_HOME [ D:\oracle\product\10.2.0\prodcrm ]: d:\oracle\product\100.2.0\
prodcrm
Invalid ORACLE_HOME.
ASM ORACLE_HOME [ D:\oracle\product\10.2.0\prodcrm ]: D:\oracle\product\10.2.0\p
rodcrm
ASM port [ 1521 ]: 1521
ASM user role [ SYSDBA ]: SYSDBA
ASM username [ SYS ]: SYS
ASM user password:
ASM user password: -------------------------------------------------------------
----

You have specified the following settings

Database ORACLE_HOME ................ D:\oracle\product\10.2.0\prodcrm

Database instance hostname ................ sis-prod-db-3-priv.apu.edu
Listener port number ................ 1521
Cluster name ................ PROD
Database unique name ................ PRODFIN
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ D:\oracle\product\10.2.0\prodcrm
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ SYS

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Mar 14, 2008 9:41:49 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\oracle\product\10.2.0\prodcrm\cfgtool
logs\emca\PRODFIN\emca_2008-03-14_09-39-06-AM.log.
Mar 14, 2008 9:41:57 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 14, 2008 9:55:57 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Mar 14, 2008 9:56:02 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFile
s
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\oc4j\j2ee\OC4J_DBConsole_sis-
prod-db-3_PRODFIN1 to remote nodes ...
Mar 14, 2008 9:56:02 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFile
s
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\oc4j\j2ee\OC4J_DBConsole_sis-
prod-db-4_PRODFIN2 to remote nodes ...
Mar 14, 2008 9:56:03 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\sis-prod-db-3_PRODFIN1 to rem
ote nodes ...
Mar 14, 2008 9:56:04 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating D:\oracle\product\10.2.0\prodcrm\sis-prod-db-4_PRODFIN2 to rem
ote nodes ...
Mar 14, 2008 9:56:04 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 14, 2008 9:57:28 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at D:\oracle\product\10.2.0\prodcrm\cfgtoollogs\emca\PRODF
IN\emca_2008-03-14_09-39-06-AM.log for more details.
Could not complete the configuration. Refer to the log file at D:\oracle\product
\10.2.0\prodcrm\cfgtoollogs\emca\PRODFIN\emca_2008-03-14_09-39-06-AM.log for mor
e details.




Its sort or urgent if anyone can help its I'll greatly appreaciate it.

Thanks in Advance.
padma