Sometimes you can get this error:
[bash]
[oracle@oratest03 scripts]$ emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
[oracle@oratest03 scripts]$
[oracle@oratest03 scripts]$ export ORACLE_UNQNAME=T11R2
[oracle@oratest03 scripts]$ emctl start dbconsole
OC4J Configuration issue. /app/oracle/product/11.2.0.1/oc4j/j2ee/OC4J_DBConsole_oratest03_T11R2 not found.
[/bash]
This is due to a misconfiguration of dbconsole during database setup. The fastest solution is usually to recreate repository and configuration.
First, deconfigure dbconsole:
[bash]
[oracle@oratest03 bin]$ ./emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Dec 28, 2009 12:15:33 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: T11R2
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 28, 2009 12:15:44 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /app/oracle/cfgtoollogs/emca/T11R2/emca_2009_12_28_12_15_32.log.
Dec 28, 2009 12:15:44 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Dec 28, 2009 12:15:45 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 28, 2009 12:17:33 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 28, 2009 12:17:33 PM
[/bash]
Now, let's configure it again
[bash]
[oracle@oratest03 bin]$ ./emca -config dbcontrol db -repos create
STARTED EMCA at Dec 28, 2009 12:17:43 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: T11R2
Listener port number: 1521
Listener ORACLE_HOME [ /app/oracle/product/11.2.0.1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /app/oracle/product/11.2.0.1
Local hostname ................ oratest03
Listener ORACLE_HOME ................ /app/oracle/product/11.2.0.1
Listener port number ................ 1521
Database SID ................ T11R2
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 28, 2009 12:17:58 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /app/oracle/cfgtoollogs/emca/T11R2/emca_2009_12_28_12_17_43.log.
Dec 28, 2009 12:17:59 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 28, 2009 12:23:44 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Dec 28, 2009 12:23:47 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Dec 28, 2009 12:24:41 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Dec 28, 2009 12:24:43 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Dec 28, 2009 12:24:43 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Dec 28, 2009 12:25:13 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Dec 28, 2009 12:25:13 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Dec 28, 2009 12:25:54 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Dec 28, 2009 12:25:54 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Dec 28, 2009 12:26:19 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Dec 28, 2009 12:26:19 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://oratest03:1158/em <<<<<<<<<<<
Dec 28, 2009 12:26:25 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************ WARNING ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: /app/oracle/product/11.2.0.1/oratest03_T11R2/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 28, 2009 12:26:25 PM
[/bash]
That's all. Remember, if you want or need, to backup you encryption key.
9 comments:
Thanksssssssss!
I get a
ORA-20001: SYSMAN already exists..
error while recreating the repos. Have you seen that one before? Complete logfile:
"Check if repos user already exists.
oud 6: WHERE username=UPPER('&EM_REPOS_USER');
nieuw 6: WHERE username=UPPER('SYSMAN');
oud 8: IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
nieuw 8: IF ( 'NOT_EXISTS' = 'EXISTS') THEN
oud 11: raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
nieuw 11: raise_application_error(-20000, 'SYSMAN does not exists..');
oud 14: ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
nieuw 14: ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
oud 17: raise_application_error(-20001, '&EM_REPOS_USER already exists..');
nieuw 17: raise_application_error(-20001, 'SYSMAN already exists..');
oud 21: raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
nieuw 21: raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
DECLARE
*
FOUT in regel 1:
.ORA-20001: SYSMAN already exists..
ORA-06512: in regel 17"
Hi Jasna,
I also got the exact same problem.If you found any solution could you please share it here.Thanks in advance.
Try reboot after install. Sometime that works as well.
@paco
Hi,
I installed the oracle db on a xp virtual machine. I also got the two messages when installing:
1)set the environmental variable ORACLE_UNQNAME......
2)emctl start dbconsole
It seems that the problem in my case was that oracle created the folders with name localhost instead of ip, so what i did is to copy paste the folders and rename it with the ip number_mydatabasename. Initially i tried to rename the original folders but it doesn't let me. My database works just fine now.
Hope it helps.
Cheers,
Eliza
Thanks. it works!!!!
The fix seems unbelievable but here goes:
While installing oracle 11gr, i removed the pre-populated entry for the global database name (which is the fully qualified host name of your machine) and replaced it with just "oradb".
This caused my em instance to be configured under "C:\oracle11gR2\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_localhost_oradb"
Now when i tried to start emctl, i got the error message ORACLE_UNQNAME not defined. So I defined it as follows:
SET ORACLE_UNQNAME=oradb
and tried it again but no luck. Seems like the emctl startup scripts always expect the folder to be in the hostname format, i.e. it expected the properly configured EM Application to be in "C:\oracle11gR2\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole__oradb"
So i debugged the perl scripts and found something useful, if you set the env var "ORACLE_HOSTNAME" then you can override the incorrect value that the scripts generate for the path to EM application.
so defined a environment var as follows:
SET ORACLE_HOSTNAME=localhost
This fixed this startup error. But wait, there was another one that came up after this:
#######
The agentTZRegion value in C:\oracle11gR2\product\11.2.0\dbhome_1\localhost_oradb/sysman/config/emd.properties is not in agreement with what agent thinks it should be.Please verify your environment to make sure that TZ setting has not changed since the last start of the agent.
If you modified the timezone setting in the environment, please stop the agent and exectute 'emctl resetTZ agent' and also execute the script mgmt_target.set_agent_tzrgn(, ) to get the value propagated to repository.
######
The above error was logged in C:\oracle11gR2\product\11.2.0\dbhome_1\localhost_oradb\sysman\log\agabend.log file.
I fixed it be changing the file "C:\oracle11gR2\product\11.2.0\dbhome_1\localhost_oradb\sysman\config\emd.properties" as follows:
Replace the line (the property value may be different in your case):
agentTZRegion=-4:00
With:
agentTZRegion=Asia/Karachi
Ofcourse you would write your machine's timezone. To determine the exact name you can search oracle webpages, you'll find a link where all these zones are listed.
After these three fixes, EM starts to work.
thank you very much....
hi
thanks for the doc.good explanation.it helped me installing OEM in 11g.
thanks
Post a Comment