| configuring EM failure after applying patches [message #595764] |
Fri, 13 September 2013 06:15  |
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 #595807 is a reply to message #595791] |
Fri, 13 September 2013 23:35  |
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 #595838 is a reply to message #595817] |
Sat, 14 September 2013 07:25 |
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 #595907 is a reply to message #595840] |
Mon, 16 September 2013 02:41 |
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
