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
2,864 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
8 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 250 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
Technology Partners: 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!

 
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

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

740 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