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,857 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 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
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 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

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

Suggested Solutions

Title # Comments Views Activity
Retreiving column names in Windows but not in Unix 11 58
ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword 2 63
Fill Null values 5 28
Fill Date time Field 12 23
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
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 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…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

861 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