RE: EMCA Setup Bug
Date: Mon, 6 Apr 2009 09:07:45 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB06750410C47D_at_mds3aex08.USIEXCHANGE.COM>
Make sure that accounts sysman and dbsnmp are available (account unlocked) and correct passwords. Although you are specifying the SID, make sure your environment points to that SID before starting. If DBcontrol already exists for that cluster, consider dropping it first (or just dropping the config).
Metalink note 278100.1 "How To Drop, Create And Recreate DB Control In A 10g Database" is one of my favorites.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stuart Blackburn
Sent: Friday, April 03, 2009 1:54 PM
To: oracle-l_at_freelists.org
Subject: EMCA Setup Bug
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(DatabaseCh
ecks.java:134)
at
oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks
.java:100)
at
oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.jav
a:146)
at oracle.sysman.emcp.DatabaseChecks.isASMDb(DatabaseChecks.java:718)
at
oracle.sysman.emcp.EMConfigAssistant.getParamsWarnsList(EMConfigAssistan
t.java:1812)
at
oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMCon
figAssistant.java:2295)
at
oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssist
ant.java:947)
at
oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:4
70)
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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 06 2009 - 08:07:45 CDT