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,848 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
8 Comments
 
LVL 47

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 47

Expert Comment

by:schwertner
ID: 16968989
$ORACLE_HOME\rdbms\admin
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 47

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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

867 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now