?
Solved

Installed Oracle 10g 10.1.0.2 updated to 10.1.0.4 EM came up for a bit and now unable to bring it up

Posted on 2006-06-22
8
Medium Priority
?
2,909 Views
Last Modified: 2013-12-11
I have installed 10.1.0.2 and updated to 10.1.0.4 on AIX 5.3 5300-02 . This is the error from the $ORACLE_HOME/edidev_GIS/sysman/log/emagent.trc and I am unable to bring up EM


2006-06-22 16:33:10 Thread-1290 ERROR recvlets.aq: Error enabling user dbsnmp for aq agent edidev_1830 o
n GIS.coleman.com: ORA-04063: package body "SYS.DBMS_AQADM_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
2006-06-22 16:33:10 Thread-1290 ERROR recvlets.aq: unable to create subscription on oracle_database GIS.
coleman.com
2006-06-22 16:33:14 Thread-2021 WARN  http: snmehl_connect: connect failed to (edidev:5500): Connection
refused (error = 79)
2006-06-22 16:33:14 Thread-2021 ERROR pingManager: nmepm_pingReposURL: Cannot connect to http://edidev:5
500/em/upload/: retStatus=-32
2006-06-22 16:33:14 Thread-2021 WARN  http: snmehl_connect: connect failed to (edidev:5500): Connection
refused (error = 79)
2006-06-22 16:33:14 Thread-2021 ERROR pingManager: nmepm_pingReposURL: Cannot connect to http://edidev:5
500/em/upload/: retStatus=-32
0
Comment
Question by:darchuck
  • 4
  • 2
6 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 1000 total points
ID: 16966788
Have you upgraded the software only?
After you upgrade the software you have to
upgrade the catalog using
catupgr.sql
script.
There are very important prerequsites for that -
please read carefully README.HTM of the upgrade patch:
SYSTEM tablespace at least 10 MB free space,
java_pool_size and shared_pool_size at least 150MB
etc.
0
 

Author Comment

by:darchuck
ID: 16968744
Where is the catupgr.sql located?
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16968989
$ORACLE_HOME\rdbms\admin
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 48

Expert Comment

by:schwertner
ID: 16969002
Read carefully README.HTM!!!!!!! Please!
0
 

Author Comment

by:darchuck
ID: 16969535
Yes I found the script location after I posted my comment. I started reviewing the documentation for the POST Installation and there are a few scripts to be run after. . Currently the catpatch.sql
is running through quite a few package installs.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 16969785
In short:

create init.ora from spfile:

SQL>create pfile='c:\init.ora' from spfile

Edit the init.ora --->  *.java_pool_size=151m
                               *.shared_pool_size=151m
                               *.sga_max_size=800m

Make sure that there are 10 MB free in SYSTEM tablespace.

SQL>shutdown immediate
SQL>startup pfile=c:\init.ora migrate
SQL>spool c:\upgr.log
SQL>@ ?\rdbms\admin\catpatch
SQL>spool off

SQL shutdown immediate
SQL>startup

run utlrp.sql script

Thats all
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question