Reconfigure Oracle EM
One mistake can lead to a lot of work. When you’ve installed Oracle Database 11g, you can’t change the Windows Hostname without reinstalling Oracle Enterprise Manager.
These are the steps:
1. Change the %ORACLE_HOME%\network\admin\listener.ora file from an IP number to machine name.
2. Change the %ORACLE_HOME%\network\admin\tnsnames.ora file from an IP number to a machine name.
3. Change the C:\WINDOWS\System32\drivers\etc\hosts file by adding this line beneath the default localhost line (for the new Hostname value):
127.0.0.1 localhost 172.16.113.128 mclaughlin11g mclaughlin11g.techtinker.com
4. Change the Windows hostname by navigating: Start > Control Panel > System (classic view) from the random assignment of VMWare Fusion.
5. Reboot the machine, and then drop the em configuration with the following commands:
C:\Data> set ORACLE_SID=orcl C:\Data> emca -deconfig dbcontrol db -repos drop
6. You’ll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):
STARTED EMCA at Jul 13, 2008 8:26:42 AM EM Configuration Assistant, Version 11.1.0.5.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: orcl Listener port number: 1521 Password for SYS user: Password for SYSMAN user: Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: y
7. You should then drop the SYSMAN user manually because it doesn’t happen without your assistance (or, it didn’t happen when I did it). If you don’t drop the SYSMAN schema, you’ll raise an error when you try to recreate it:
CONFIG: ORA-20001: SYSMAN already EXISTS.. ORA-06512: at line 17 oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already EXISTS.. ORA-06512: at line 17
The Java stack trace will look like this, more or less based on version and release:
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530) at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880) at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218) at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147) at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222) at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535) at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215) at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519) at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
Drop the user and dependent on version a few other objects, like:
DROP USER sysman CASCADE; DROP PUBLIC SYNONYM setemviewusercontext; DROP ROLE mgmt_user; DROP PUBLIC SYNONYM mgmt_target_blackouts; DROP USER mgmt_view;
8. You can then create the em environment with the following syntax:
C:\Data> emca -config dbcontrol db -repos create
9. Again, you’ll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):
STARTED EMCA at Jul 13, 2008 8:28:48 AM EM Configuration Assistant, Version 11.1.0.5.0 Production Copyright (c) 2003, 2005, Oracle. ALL rights reserved. Enter the following information: DATABASE SID: orcl Listener port number: 1521 Password FOR SYS user: Password FOR DBSNMP user: Password FOR SYSMAN 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 ................ C:\app\Administrator\product\11.1.0\db_1 LOCAL hostname ................ mclaughlin11g Listener port number ................ 1521 DATABASE SID ................ orcl Email address FOR notifications ............... Outgoing Mail (SMTP) server FOR notifications ............... ----------------------------------------------------------------- Do you wish TO continue? [yes(Y)/no(N)]: y
A note to me, remember haste makes waste. I’m just glad that rebuilding the MarkLogic server was easy.
Subscribe via RSS
Great, this works fine for me. Thanks a lot
Shahul
13 Jan 09 at 4:15 am
Thanks for this post! It helped me a lot!
Rob Cilissen
16 Jan 09 at 8:18 am
[...] Dank aan: MacLochlainns Weblog [...]
ROB CILISSEN » Oracle EM (Enterprise Manager / Database control) opnieuw installeren
16 Jan 09 at 8:38 am
Thank you so much. It worked for me.
Mohammed Yehia
1 Feb 09 at 1:44 am
[...] Another method from MacLochLainns Weblog: [...]
Reconfiguring Oracle EM « Mohib Alvi
27 Feb 09 at 12:48 am
I followed the steps but the EM is still not configured.
Server: error creating the repository
When I see the log i got this error:
Oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
Waqas
6 May 09 at 2:37 am
I’d need to know what OS, what database version, et cetera to try and help you. Can you send that information?
maclochlainn
6 May 09 at 11:32 am
Dear Sir,
I followed your steps as described above, but no succes. I am running Oracle EBS R12 on a Windows XP plattform, I am able to drop the repository succesfully but when I try to create is gives the following error:
Check if repos user already exists.
old 6: WHERE username=UPPER(‘&EM_REPOS_USER’);
new 6: WHERE username=UPPER(‘SYSMAN’);
old 8: IF ( ‘&EM_CHECK_TYPE’ = ‘EXISTS’) THEN
new 8: IF ( ‘NOT_EXISTS’ = ‘EXISTS’) THEN
old 11: raise_application_error(-20000, ‘&EM_REPOS_USER does not exists..’);
new 11: raise_application_error(-20000, ‘SYSMAN does not exists..’);
old 14: ELSIF ( ‘&EM_CHECK_TYPE’ = ‘NOT_EXISTS’ ) THEN
new 14: ELSIF ( ‘NOT_EXISTS’ = ‘NOT_EXISTS’ ) THEN
old 17: raise_application_error(-20001, ‘&EM_REPOS_USER already exists..’);
new 17: raise_application_error(-20001, ‘SYSMAN already exists..’);
old 21: raise_application_error(-20002, ‘Invalid Check type &EM_CHECK_TYPE’);
new 21: raise_application_error(-20002, ‘Invalid Check type NOT_EXISTS’);
DECLARE
*
ERROR at line 1:
ORA-20001: SYSMAN already exists..
ORA-06512: at line 17
When i try to launch EM (knowing dat the repository is dropped) the following happens:
G:\oracle\PROD\db\tech_st\10.2.0\BIN>emctl start dbconsole
OC4J Configuration issue. G:\oracle\PROD\db\tech_st\10.2.0/oc4j/j2ee/OC4J_DBCons
ole_EEBSE01_PROD not found.
But as I said if I try to create the repository is doens’t work.
Could you probaly point out what’s wrong?
Best regard ans thanx in advance,
Yours sincerely Maruti Bhanot
Maruti Bhanot
16 May 09 at 1:06 pm
You’re not working with OEM. When you’ve installed the Oracle EBS R12, it’s the Oracle Applications Enterprise Manager (OAEM). It has different dependencies because it often leverages Java repackaged by the Oracle Applications development group. It appears that you might need some grants between scheme, but I’m not sure which ones. I’ve got this in a test plan for a situation like that but the project’s not scheduled until June.
maclochlainn
16 May 09 at 3:33 pm
Thanx for your relpy!
Yours sincerely Maruti Bhanot
Maruti Bhanot
18 May 09 at 3:01 pm
Hi,
I have oracle 10g installed on my system, but due to some IT policies they, IT, changed the computer host name!! I changed the host name in listener.ora and tnsnames.ora, and thereby SQL*Plus works. Unfortunately, I am not able to run enterprise database manager control when following the steps in the post above.
Milind Pangarkar
5 Jun 09 at 5:16 am
There’s really not a lot of information to go on in your comment. However, based on the fact that the IT department changed the machine hostname, I’ll make some assumptions. Assuming that you have an account that has administrative rights on the local machine but not within the Windows domain, Oracle may have been installed using the Administrator account rather than yours. You can confirm if this or similar problems exist by attempting to log in as the privileged user:
If it says that you lack permissions to run that command, then your account doesn’t have adequate permissions. By the way, the single quotes aren’t necessary on newer releases of Oracle.
Second assumption, the IT department has a license monitoring software installed on your PC. This is frequently the case with IT governance policies. I’d suggest that you disable the software because they interfere with Oracle’s operation on Windows. Hope this helps, but if not could you provide some more detail?
maclochlainn
7 Jun 09 at 4:17 pm
I have 2 network cards in use on my server. The server belongs to a workgroup, but the 2nd network connection connects to a different network. When I run this procedure the local hostname returned to me is the ip address of the 2nd network card, but I desire the ip address of the 1st network card or either the alias I created in the hosts file.
The line in my hosts file is this
150.1.1.50 SPM2_L2_ONLINE APPSERVER
In my listener.ora and my tnsnames.ora my alias APPSERVER is used. There is no entry in the hosts file for the ip address belonging to the 2nd network card. What am I doind wrong?
P Hunt
22 Jun 09 at 3:36 pm
I was able to get the correct ip address to be listed as the local hostname, but now I have a new error. Here is the part of my error log where things appear to start going wrong
Any help would be appreciated.
P Hunt
23 Jun 09 at 7:36 am
The errors in general, and the log throwing an
ORA-00955error may indicate that you neeed to manually drop theSYSMANschema after deconfiguring Oracle EM. Have you tried a manual drop of theSYSMANschema (step #7)?The other error that’s interesting is the concurrency control lock. Is it possible that you’ve two domains on the single box? I ask because Oracle lives in a single domain on Windows, and when you’ve two or more domains permissions and access to components differ substantially. Can you let me know if you’ve got two domains on that server?
maclochlainn
23 Jun 09 at 9:43 am
I did do the manual drop of sysman. I looked at the emca_repos_create… file and saw that it was complaining about some MGMT% synonyms already existing so it could not create the synonym. I have been dropping these synonyms one by one to see if I can get somewhere. I saw a solution on another website where all the synonyms had to be dropped manually in addition to the sysman user. I do not know if I have 2 domains on the server. What I do know is the server belongs to a workgroup. The ip address for the 1st network card corresponds to this workgroup. The 2nd network card is used for level 3 access. It’s ip address belongs to the level 3 network which I assume is part of a domain.
P Hunt
23 Jun 09 at 1:38 pm
Which NIC does 150.1.1.50 belong to, the primary or secondary? Which NIC should the EM run on?
You’re installing as the Administrator user account from the logs, but just want to confirm that?
Synonyms creation failure shouldn’t cause a fatal failure because they’re created to mirror the old ones, they just won’t translate in between rebuilding SYSMAN. Did you’re log indicate that the process stopped completed at those synonym creation statements?
What’s in this or a more recent equivalent log file: D:\app\Administrator\cfgtoollogs\emca\orcl\emca_2009_06_22_17_50_34.log?
maclochlainn
23 Jun 09 at 10:49 pm
150.1.1.50 belongs to network connection 1. This is where the EM should run. Yes the install is being done as administrator. Here is the last line of file emca_repos_create_2009_06_23_16_29_17.log
I have a concern that if I do get this working, my dual network cards will cause me a problem. When I try to use the emctl start command, it constructs a folder name with the ip address of network connection 2. Perhaps I’ll address this if I get to this point.
P Hunt
24 Jun 09 at 7:39 am
Worked perfectly for me !!
(was necessary after 10g XE upgraded to full version 10g 10.2.0.4 on another machine)
Reinhold Seifert
29 Jun 09 at 5:50 am
I have recreated OEM configuration. Oracle 11g dbconsole is running. OEM is running but when I am trying to open database control on internet explorer, it is not displaying the page.
Rajiv
9 Jul 09 at 4:37 pm
Have you tried Firefox? What’s your URL that;s failing?
maclochlainn
9 Jul 09 at 6:08 pm
Hello,
I posted a while ago about EM on Windows enviroment which wasn’t working for me, I switched to CentOS 5.3 running my R12 and the following steps worked for me:
Configure OEM Database Control on R12
Source enviroment the of the database tier. Env. file location is in my case /ERP/db/tech_st/11.1.0/
Afterwards, open a browser and enter:
Accept te certificate and there you go….
I got the main info of this site:
http://orafin.blogspot.com/2008/09/enable-database-enterprise-manager.html
So it is working now fine for me, perhaps on a Windows enviroment if you use de Windows commands it should perhaps work, not tried still…
Regards,
Maruti
Maruti Bhanot
14 Aug 09 at 4:02 am
This was a neat and clear help. thanks a lot.
Rakesh Vyas
22 Sep 09 at 1:10 am
Thanks !!!
I didn’t see see the forest for the trees.
ETC/host is the solution for my challenges with the console.
This article is short and to the point
great
Gerd
28 Sep 09 at 1:48 am
thanks for your help!
but i have another error after the reconfiguration of em: Unable to determine local host from URL REPOSITORY_URL=http://ORACLE-LAPTOP:%EM_UPLOAD_PORT%/em/upload/
could you help me again please!!!!!!
Patricia
21 Oct 09 at 8:13 am
The public synonym for
SYSMANobjects will not be dropped although the user is drooped by using the command:DROP USER sysman CASCADE;After user is dropped, all the public synonyms that tie to it hv to be dropped manually.
yapkang
7 Jan 10 at 9:53 pm
I have a problem about reconfiguration of ports
When I execute emca -config dbcontrol db, the password of SYS is accepted.
When I execute emca -reconfig ports -…… the password of SYS (the same as before of course) is rejected.
Could you help me with this issue? I’m installing Oracle 11g on Windows 7 (32bit).
Thanks a lot.
Marcela
10 Jan 10 at 5:36 pm
Thanks you too much sir its really help full, long live DBA
saif
16 Jan 10 at 11:56 pm
Thank you, thank you, thank you.
dto
22 Jan 10 at 9:09 am
Marcela, What’s the exact error message that you get?
maclochlainn
22 Jan 10 at 10:35 am
Hi;
Thanks for sharing this information! I was struggling to reconfigure em control and this has helped me make some progress.
I was able to deconfigure using emca.
The sysman user and other ‘residuals’ were also all gone. (maybe this got more thorough in 11.2.0).
I am having no luck when I try to reconfigure however. Despite the Java exception messages you’ll see below, the database is happily up and running. Any ideas would be appreciated.
Thank you, Jack
Jack
6 May 10 at 8:46 pm
thank you very much. It did not require me to drop any users/schemas.
sushant
9 May 10 at 8:43 pm
Hi Maclochlainn,
Because of some replication problem my production server has gone to hanging mode, so, I force to restart my production server. After restarting every thing working fine except my OEM unable to restart. I followed your steps, but at the end I am getting “SEVERE: Error starting Database Control”. Checked the log file, repository created successfully, but unable to start the repository. mailing you end part of the log file. Please help me to start the OEM.
Sfi
28 May 10 at 9:51 pm
Hi,
in step 3 you suggets adding a new line in etc/hosts file.
Is this the new hostname with current IP address, or old hostname with current IP address?
Christos
1 Jun 10 at 4:18 am
Yes, it’s the new
hostnamevalue.maclochlainn
1 Jun 10 at 9:43 am
It appears that the Windows Service is corrupted. Have you tried dropping it and recreating it?
maclochlainn
2 Jun 10 at 1:29 am
Excellent post, it worked for me. Thank you very much. I highly recommend it.
Hugo Mendoza
4 Jun 10 at 10:22 am
I think that dropping/recreating the Windows Service would help. Would you give me an idea of where that is documented?
I have hunted through the Utilities doc but don’t see it in there. (But I wouldn’t be surprised to find that my interpretation of what Oracle’s trying to tell me is wrong either.)
Thank you, Jack
Jack
13 Jun 10 at 1:10 pm
The
ORADIMutility creates, maintains, and deletes Windows services for the database.Create an instance by specifying the following options:
Edit an instance by specifying the following options:
Delete instances by specifying the following options:
Startup services and instance by specifying the following options:
Shutdown service and instance by specifying the following options:
Query for help by specifying the following parameters:
maclochlainn
13 Jun 10 at 2:02 pm
This is a very helpfull article.
But I am still not able to configure em
I followed the given steps.
Here is the error that i get.
Contents of log file are as below:
INFO: [D:\app\324923\product\11.1.0\db_3\sysman\admin\emdrep\sql\core\configuration.xml] Jun 16, 2010 3:31:30 AM oracle.sysman.emdrep.config.EMSchemaConfiguration getConfigIntegrations INFO: Number of Configuration Instances:1 Jun 16, 2010 3:31:30 AM oracle.sysman.emdrep.config.EMSchemaConfiguration getConfigIntegrations INFO: oracle.sysman.emdrep.util.TransxWrapper D:\app\324923\product\11.1.0\db_3\jlib/transx.zip D:\app\324923\product\11.1.0\db_3\xdk/lib/transx.zip D:\app\324923\product\11.1.0\db_3\lib/transx.zip D:\app\324923\product\11.1.0\db_3\lib/xmlparserv2.jar D:\app\324923\product\11.1.0\db_3\lib/xsu12.jar D:\app\324923\product\11.1.0\db_3\jlib/xdb.jar D:\app\324923\product\11.1.0\db_3\rdbms/jlib/xdb.jar D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/orai18n.jar D:\app\324923\product\11.1.0\db_3\jdbc/lib/ojdbc14.jar D:\app\324923\product\11.1.0\db_3\sysman/jlib/emCORE.jar D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/ojdbc14.jar D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/ojdbc14dms.jar D:\app\324923\product\11.1.0\db_3\jdbc/lib/ojdbc5.jar D:\app\324923\product\11.1.0\db_3\jdbc/lib/ojdbc5dms.jar D:\app\324923\product\11.1.0\db_3\oc4j/lib/dms.jar D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/dms.jar D:\app\324923\product\11.1.0\db_3\dms/lib/dms.jar Jun 16, 2010 3:31:31 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection INFO: jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis))) Jun 16, 2010 3:31:32 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection INFO: jdbcUrl = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis))) Jun 16, 2010 3:31:32 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection INFO: jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis))) Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection INFO: jdbcUrl = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis))) Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance run SEVERE: null java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:469) at java.lang.Thread.run(Thread.java:595) Caused by: oracle.sysman.emdrep.config.ConfigurationException: Cannot Create Connection:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis))) SYSMAN normal ORA-01017: invalid username/password; logon denied java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:693) at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:338) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508) at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:133) at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:140) at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:201) at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:240) at oracle.sysman.emdrep.config.IConfigurationContext.getConnection(IConfigurationContext.java:194) at oracle.sysman.emdrep.config.IConfigurationContext.init(IConfigurationContext.java:98) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:469) at java.lang.Thread.run(Thread.java:595) at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:245) at oracle.sysman.emdrep.config.IConfigurationContext.getConnection(IConfigurationContext.java:194) at oracle.sysman.emdrep.config.IConfigurationContext.init(IConfigurationContext.java:98) ... 6 more Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:693) at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:338) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508) at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:133) at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510) at java.sql.DriverManager.getConnection(DriverManager.java:525) at java.sql.DriverManager.getConnection(DriverManager.java:140) at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:201) at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:240) ... 8 more Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.EMSchemaConfiguration perform WARNING: Exception Occured during Execution of oracle.sysman.emdrep.util.TransxWrapper Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.EMSchemaConfiguration perform SEVERE: FATAL EXCEPTIONS: FATAL Configuration ExceptionsRegards,
prabhjot
prabhjot
16 Jun 10 at 4:40 am
The log is truncated in length. If you open it in an editor, could you re-paste it. It appears that the error occurs trying to
createConnection, the initial question becomes was your %TNS_ADMIN% set in your session, and is the listener running?maclochlainn
17 Jun 10 at 9:25 pm
maclochlainn;
Thank you! Deleting/re-creating the Windows service through ORADIM allowed me to run EMCA successfully to recreate the DBConsole service.
I appreciate you sharing your expertise.
Jack ‘donnachaich’
Jack
19 Jun 10 at 1:26 pm