Home » RDBMS Server » Enterprise Manager » configuring EM failure after applying patches (Oracle 10.2.0.1.0 & OEL 5 )
configuring EM failure after applying patches [message #595764] Fri, 13 September 2013 06:15 Go to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
After applying opatch on oracle 10.2.0.1.0 to 10.2.0.4.0, upgrading to 10.2.0.4.0 & compiling objects,unable to configure enterprise manager if a new oracle database created using dbca, when trying with emca also, configuration wasn't successful, what shall be done?
Re: configuring EM failure after applying patches [message #595770 is a reply to message #595764] Fri, 13 September 2013 07:25 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
Is the opatch release the latest? What is the patch number? You can query registry$history or dba_registry_history views.

I am not completely sure, but could be a probable reason.
Re: configuring EM failure after applying patches [message #595791 is a reply to message #595764] Fri, 13 September 2013 10:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what does mean "configuration wasn't successful"?
Power went off?

Regards
Michel
Re: configuring EM failure after applying patches [message #595807 is a reply to message #595791] Fri, 13 September 2013 23:35 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
no, not yet, i'll show the output screen, when executing $ EMCA -config dbcontrol db -repos recreate

[oracle@oraclehost2 ~]$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Sep 14, 2013 9:47:38 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: orcl
Listener port number: 1521
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 ................ /u01/app/oracle/product/10.2.0/db_1

Database hostname ................ oraclehost2.localdomain
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
Sep 14, 2013 9:55:55 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-09-14_09-47-38-AM.log.
Sep 14, 2013 9:55:58 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclehost2.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2013-09-14_09-55-58-AM.log
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_<date>.log for more details.
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error dropping the repository
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-09-14_09-47-38-AM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-09-14_09-47-38-AM.log for more details.

even the listener was successfully up, what shall be the reason?
Re: configuring EM failure after applying patches [message #595809 is a reply to message #595807] Fri, 13 September 2013 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>even the listener was successfully up, what shall be the reason?
SEVERE: Error dropping the repository
Re: configuring EM failure after applying patches [message #595817 is a reply to message #595809] Sat, 14 September 2013 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And
Quote:
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-09-14_09-47-38-AM.log for more details.


Regards
Michel
Re: configuring EM failure after applying patches [message #595838 is a reply to message #595817] Sat, 14 September 2013 07:25 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Iam also sending the log (/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-09-14_09-47-38-AM.log), for you reference, check below,


stty: standard input: Invalid argument
stty: standard input: Invalid argument

Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /u01/app/oracle/product/10.2.0/db_1/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclehost2.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) -repos_user SYSMAN -action drop -verbose -output_file /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2013-09-14_09-55-58-AM.log
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_<date>.log for more details.
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error dropping the repository
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2013-09-14_09-47-38-AM.log for more details.
Sep 14, 2013 9:55:59 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:183)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)
391,2-9 Bot

Re: configuring EM failure after applying patches [message #595840 is a reply to message #595838] Sat, 14 September 2013 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
INFO: Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_<date>.log for more details.


Regards
Michel
Re: configuring EM failure after applying patches [message #595907 is a reply to message #595840] Mon, 16 September 2013 02:41 Go to previous messageGo to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Michael, Checked with the following error as you said,

Checked with the error log,
[oracle@oraclehost2 ~]$ vi /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_repos_drop_2013-09-14_11-04-50-AM.log


[14-09-2013 11:04:50] Enter SYS user's password :
[14-09-2013 11:04:50]
[14-09-2013 11:04:50] Enter repository user password :
[14-09-2013 11:04:50]
[14-09-2013 11:04:50] Getting temporary tablespace from database...
[14-09-2013 11:04:50] Database does not have any temporary tablespaces ONLINE.

what shall i do? whether to increase the size of the temporary tablespace?

Re: configuring EM failure after applying patches [message #595912 is a reply to message #595907] Mon, 16 September 2013 03:20 Go to previous message
Michel Cadot
Messages: 68617
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a temporary tablespace or add a file if the tablespace exists with no file or make it ONLINE if it is OFFLINE.

Regards
Michel
Previous Topic: DBMS_ SCHEDULER ISSUE
Next Topic: Server Connection Failed
Goto Forum:
  


Current Time: Tue Mar 19 00:28:43 CDT 2024