Archive

Archive for June, 2009

Invalid Objects after wrong utlrp.sql

June 24th, 2009 Comments off

Be extra careful with the location of your utlrp.sql script when you decide to recompile the invalid objects for the entire database as sys.
The utlrp.sql script resides in the ORACLE_HOME/rdbms/admin and in CLIENT_HOME/rdbms/admin folders.
It is utterly wrong to use and recompile with the script in the client home folder.
After such a mistake of me the SYSMAN schema got completely corrupt.
I restored the SYSMAN using the steps described in my previous post OracleDBControl .

The remaining invalid objects are as follows:

select owner, object_name from all_objects where status='INVALID';

Read more...

Categories: Oracle Tags:

OracleDBControl

June 24th, 2009 Comments off

If you have ever exported and imported complete databases and moved them around from one server to another, you have probably noticed the issues that might occur with the EM repository. During the last delivery project that I worked on I had to import two databases in two Oracle servers (10.2.0.4) installed on Microsoft Windows 2003 x64. Everything was going smooth with the DBCA during the creation of the new database. I have selected the database to be manager using Enterprise Manager so the EM repository was being installed. Unfortunately it errored out. The logs are stored in the following location:

D:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\instance_name (ORACLE_HOME\cfgtoollogs\emca\instance_name)

I found out that everything with the creation of the EM repository has been successful except the actual start of the windows service. In the log files I found the following trace:

24.06.2009 10:11:50 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
24.06.2009 10:14:32 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
24.06.2009 10:14:42 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
24.06.2009 10:15:08 oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
24.06.2009 10:19:48 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
24.06.2009 10:21:13 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
24.06.2009 10:25:08 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
24.06.2009 10:24:08 oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...

Read more…

Categories: Oracle Tags: