EMCA ON RAC RETURNS INVALID USERNAME / PASSWORD FOR SYS , DBSMNP , SYSMAN USER When running " $./emca -config dbcontrol db -repos create "
Workaround from metalink:
When the emca command prompts for the sysman password, provide the sysman password in double quotes.
I think below steps to re-create DB control can also fix it.
and many funning problem with DB Console . (if u don't want to buy license for grid control, and want to running many instances on same server, even more complex, they are under different oracle owner id, e.g. oracle1, oracle2)
You may face the following problems:
-- port number conflict created together with dbua
-- database looks hang when re-create repository
-- can't see graphic of active session and CPU info in first page, with java error message java.lang.Exception: No Such Target
To avoid above funny problems is to re-create DB control
1. Re-config ports if conflicts exist.
-- verify this by check portlist.ini under $ORACLE_HOME/install
-- Type below magic command, it looks can take care all port at unix id group level (oracle1, oracle2 belong to same group dba).
> emca -reconfig ports
STARTED EMCA at May 9, 2008 10:10:12 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID
...
INFO: >>>>>>>>>>> The Database Control URL is http://testdb:5503/em <<<<<<<<<<<>export ORACLE_HOSTNAME (FOR using virtual hostname)
> emca -deconfig dbcontrol db
> emca -config dbcontrol db -repos create
to indicate port number for http port and agent port , use below two parameters with emca
-
-DBCONTROL_HTTP_PORT <port_number>
This port number is used in the Database Control Console URL. For example, if you set this port to 5570, you can then display the Database Control Console using the following URL:
http://host.domain:5570/em
-
-AGENT_PORT <port_number>
This port is used by the Database Control Management Agent, which is monitoring and administering the database for the Database Control.
REF:Oracle® Enterprise Manager Advanced Configuration
10g Release 2 (10.2)
