Oracle in World: You must have CREATE TARGET privilege to perform this operation

Problem Description
In the Enterprise Manager main page (connected with SYS as SYSDBA or as SYSTEM), when I click on performance tab, it gives me following notification.

MemberShip Configuration
The membership configured for the cluster database does not match the instance list of the database. Please update your configuration from the following link:

Database Configuration

And when I click on Database Configuration link, it drops the following error:
Error
You must have CREATE TARGET privilege to perform this operation.

Cause of the Problem
The error may mislead you and you may wonder your login user has not proper privilege and it might need CREATE TARGET privilege. But in fact the problem happens if you configure dbconsole of your RAC cluster database instance for a single database, not for cluster daratabase.

Solution of the Problem
You need to configure your RAC database dbconcole with the -cluster keyword. So rerun the following command in your RAC database instance. One thing you should keep you in mind that your unique database name would be RAC database, it does not indicate any single instance of the RAC database.
$emca -config dbcontrol db -repos recreate -cluster
STARTED EMCA at Dec 1, 2009 10:08:50 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: EAIAPP
Database Control is already configured for the database EAIAPP
You have chosen to configure Database Control for managing the database EAIAPP
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]:

Listener port number: 1522
Cluster name: EAIAPP

You have specified the following settings

Database ORACLE_HOME ................ /opt/oracle/product/dbs

Database instance hostname ................ db1-eai.prod.stl.cw.intraisp.com
Listener port number ................ 1522
Cluster name ................ EAIAPP
Database unique name ................ EAIAPP
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /opt/oracle/product/asm
ASM port ................ 1522
ASM user role ................ SYSDBA
ASM username ................ SYS

Do you wish to continue? [yes(Y)/no(N)]: yes
Dec 1, 2009 10:17:00 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /opt/oracle/product/dbs/cfgtoollogs/emca/EAIAPP/emca_2009-12-01_10-10-40-AM.log.
Dec 1, 2009 10:17:01 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Dec 1, 2009 10:17:05 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Dec 1, 2009 10:18:08 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Dec 1, 2009 10:18:08 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 1, 2009 10:19:36 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Dec 1, 2009 10:19:38 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /opt/oracle/product/dbs/oc4j/j2ee/OC4J_DBConsole_db1-eai_EAIAPP1 to remote nodes ...
Dec 1, 2009 10:19:38 AM oracle.sysman.emcp.EMDBCConfig instantiateOC4JConfigFiles
INFO: Propagating /opt/oracle/product/dbs/oc4j/j2ee/OC4J_DBConsole_db2-eai_EAIAPP2 to remote nodes ...
Dec 1, 2009 10:19:38 AM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating /opt/oracle/product/dbs/oc4j/j2ee/isqlplus_db1-eai.prod.stl.cw.intraisp.com to remote nodes ...
Dec 1, 2009 10:19:39 AM oracle.sysman.emcp.EMDBCConfig copyAndPropagateOC4JDir
INFO: Propagating /opt/oracle/product/dbs/oc4j/j2ee/isqlplus_db2-eai.prod.stl.cw.intraisp.com to remote nodes ...
Dec 1, 2009 10:19:41 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /opt/oracle/product/dbs/db1-eai_EAIAPP1 to remote nodes ...
Dec 1, 2009 10:19:42 AM oracle.sysman.emcp.EMAgentConfig deployStateDirs
INFO: Propagating /opt/oracle/product/dbs/db2-eai_EAIAPP2 to remote nodes ...
Dec 1, 2009 10:19:43 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...

Dec 1, 2009 10:57:56 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Dec 1, 2009 10:57:56 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://db1-eai.prod.stl.cw.intrais.com:1158/em <<<<<<<<<<<
Dec 1, 2009 10:57:57 AM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

EAIAPP1 db1-eai db1-eai.prod.stl.cw.intrais.com
EAIAPP2 db2-eai db1-eai.prod.stl.cw.intrais.com

Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 1, 2009 10:57:57 AM

And you are done.

Related Documents

http://arjudba.blogspot.com/2008/04/troubleshooting-dbconsole-error-oc4j.html
http://arjudba.blogspot.com/2008/04/how-to-drop-create-and-recreate-db.html
http://arjudba.blogspot.com/2008/04/stack-of-problems-while-creating.html

http://arjudba.blogspot.com/2008/09/em-daemon-is-not-running.html

In EM connection fails with ERROR: NMO not setuid-root (Unix-only)

http://arjudba.blogspot.com/2008/04/how-to-change-db-control-http-port.html

http://arjudba.blogspot.com/2008/04/stop-alert-notification-for-specified.html

How to Notify or send email Event in Oracle from EM

http://arjudba.blogspot.com/2008/04/running-emca-fails-to-accept-sysman.html

http://arjudba.blogspot.com/2008/04/how-to-access-database-using-database.html