EMCA Setup Bug
Date: Fri, 03 Apr 2009 13:53:46 -0400
Message-ID: <49D64D2A.1050406_at_cbnco.com>
Just wondering if anyone's ever encountered a similar problem when setting up emca on a RAC environment. Oracle was unable to find the solution and has created a bug as of today, but I still need to get this working and it's probably something in my configuration that I'm just missing.
Following command is used to setup emca:
emca -config dbcontrol db -repos create -cluster
When it prompts for the sys password it returns "invalid username/password" every time no matter what is entered. The password is clearly correct since I can login to sqlplus using the correct password. The log files state "CONFIG: Database instance unavailable.". The reason this behaviour is strange is because I've set this up on dozens of other systems and whether I enter an invalid password or the correct password it still lets me proceed past this point and will only find out about the password problems later on. It seems that no matter what is entered, emca is just ignoring it and returning the error right away. If I pass the sys password in as a command line argument of emca as -SYS_PWD it will just fail out with the same problem on the dbsnmp password so it's clearly a configuration problem and it doesn't even get to the point where it checks the passwords with the database. I cannot reproduce this on any other system either.
----emca setup
oracle_at_NCFRDATA1:/apps/oracle/product/10.2/db_1/cfgtoollogs/emca> emca
-config dbcontrol db -repos create -cluster
STARTED EMCA at Mar 17, 2009 10:27:30 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: frpca1c
Listener port number: 1521
Cluster name: frdb_cluster
Password for SYS user: <manager was entered>
Invalid username/password.
Password for SYS user: <"manager" was entered>
Invalid username/password.
Password for SYS user:
---Log
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive
CONFIG: Node: NCFRDATA1 is accessible.
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive
CONFIG: Node: NCFRDATA2 is accessible.
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.util.ClusterUtil areNodesAlive
CONFIG: Node: NCFRDATA3 is accessible.
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.ParamsManager
getInaccessibleNodeList
CONFIG: All nodes are up. Nodes: [NCFRDATA1, NCFRDATA2, NCFRDATA3]
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.ParamsManager
getInaccessibleSidList
CONFIG: All nodes are up. Nodes: [NCFRDATA1, NCFRDATA2, NCFRDATA3] Sids:
[frpca1c1, frpca1c2, frpca1c3]
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: SID_LIST value: frpca1c1,frpca1c2,frpca1c3
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: NODE_LIST value: NCFRDATA1,NCFRDATA2,NCFRDATA3
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: ncfrdata1
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: ncfrdata1
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: ncfrdata1
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.util.ClusterUtil getHostName
CONFIG: Specified node: ncfrdata1
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYS_PWD.
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.DatabaseChecks isASMDb
CONFIG: Database instance unavailable.
oracle.sysman.emcp.exception.DatabaseUnavailableException: Database
instance unavailable.
at
oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:134)
at
oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:100)
at
oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:146)
at oracle.sysman.emcp.DatabaseChecks.isASMDb(DatabaseChecks.java:718)
at
oracle.sysman.emcp.EMConfigAssistant.getParamsWarnsList(EMConfigAssistant.java:1812)
at
oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:2295)
at
oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:947)
at
oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)
Mar 17, 2009 10:27:34 AM oracle.sysman.emcp.ParamsManager setFlag
Thanks
Stuart
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 03 2009 - 12:53:46 CDT