| Mandalika's scratchpad | [ Work blog @Oracle | Stock Market Notes | My Music Compositions ] |
Old Posts:
09.04
10.04
11.04
12.04
01.05
02.05
03.05
04.05
05.05
06.05
07.05
08.05
09.05
10.05
11.05
12.05
01.06
02.06
03.06
04.06
05.06
06.06
07.06
08.06
09.06
10.06
11.06
12.06
01.07
02.07
03.07
04.07
05.07
06.07
08.07
09.07
10.07
11.07
12.07
01.08
02.08
03.08
04.08
05.08
06.08
07.08
08.08
09.08
10.08
11.08
12.08
01.09
02.09
03.09
04.09
05.09
06.09
07.09
08.09
09.09
10.09
11.09
12.09
01.10
02.10
03.10
04.10
05.10
06.10
07.10
08.10
09.10
10.10
11.10
12.10
01.11
02.11
03.11
04.11
05.11
07.11
08.11
09.11
10.11
11.11
12.11
01.12
02.12
03.12
04.12
05.12
06.12
07.12
08.12
09.12
10.12
11.12
12.12
01.13
02.13
03.13
04.13
05.13
06.13
07.13
08.13
09.13
10.13
11.13
12.13
01.14
02.14
03.14
04.14
05.14
06.14
07.14
09.14
10.14
11.14
12.14
01.15
02.15
03.15
04.15
06.15
09.15
12.15
01.16
03.16
04.16
05.16
Thursday, August 28, 2008
Re-creating Oracle Enterprise Manager's Console Repository
An earlier blog post, Oracle 10g: Setting up The Oracle Enterprise Manager Console, has the detailed instructions for setting up the Oracle 10g
OEM console. However if the database along with the RDBMS server was
moved (copied over) to a different host, Oracle Enterprise Manager (OEM)
refuses to start. In such cases, the error message will be similar to
the following.
One simple solution (there might be many) to fix this issue is to re-create the repository for the OEM console. The steps are as follows.
You are done. As simple as that.
_______________
% emctl start dbconsole
OC4J Configuration issue. /export/pspp/oracle/oc4j/j2ee/OC4J_DBConsole_localhost_test not found.
One simple solution (there might be many) to fix this issue is to re-create the repository for the OEM console. The steps are as follows.
- Make sure the database instance and the listener are up.
- Unlock
sysmanandsysuser accounts if not unlocked already.
eg.,% sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 27 23:42:24 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> alter user sysman identified by manager account unlock; User altered. SQL> alter user sys identified by manager account unlock; User altered. SQL> quit
- Re-create the repository.
eg.,% emca -config dbcontrol db -repos recreate STARTED EMCA at Aug 27, 2008 11:43:09 PM EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: test Listener port number: 1521 Password for SYS user: manager Password for DBSNMP user: dbsnmp Password for SYSMAN user: manager Email address for notifications (optional): Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /export/pspp/oracle Database hostname ................ matrix Listener port number ................ 1521 Database SID ................ test Email address for notifications ............... Outgoing Mail (SMTP) server for notifications ............... ----------------------------------------------------------------- Do you wish to continue? [yes(Y)/no(N)]: Y Aug 27, 2008 11:43:28 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /export/pspp/oracle/cfgtoollogs/emca/test/emca_2008-08-27_11-43-09-PM.log. Aug 27, 2008 11:43:31 PM oracle.sysman.emcp.EMReposConfig dropRepository INFO: Dropping the EM repository (this may take a while) ... ... ...
You are done. As simple as that.
_______________
| 2004-2016 |  |
No comments:
Post a Comment