Skip to Main Content
Forums

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Refresh From Metalink Job

430785Mar 15 2005 — edited Sep 7 2005
The "Refresh From Metalink" patch advisory job fails. Contents of the output log are as below. Note open cursors is set to 3000. Anybody else experienced this?
_________________________________________________________
Checking Oracle MetaLink authorization.

MetaLink Username: keith.bines@am-beo
MetaLink Password: **********
Patch Search URL: http://updates.oracle.com

Updating OEM repository with latest release table data from Oracle MetaLink.

- Exception trying to access the repository. java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Comments

440365
You need to increase number of open cursors for this to work. By default it's set to 300 in spfile
*.open_cursors=300 (maybe its 300 not 3000 )

In my case bumping it up to 2000 did the trick

ALTER SESSION or ALTER SYSTEM - system wide or session wide
*.OPEN_CURSORS=2000 - database global
MY_INSTANCE.OPEN_CURSORS=2000 - only for the given instance
430785
nope - open cursors is set to 3000
440365
ALTER SYSTEM SET *.OPEN_CURSORS=2000 SID='SOMESID' SCOPE='SPFILE';
440365
Bump it to 5000
user148120
How about solving the problem rather than avoiding it ;-)
When you are running the job, go check to see what all the open cursors are
select * from v$open_cursor, I believe. Then if
it looks wrong, then file a bug report to get it fixed.
No way should it open that many cursors .. something is broken.
Let us know what you find..
vhbtech
any news on this subject ?

i also had exactly the same problem as in the first posting.
so i boosted the cursors to 65535 and that did the job:
____________________________________________________
Oracle MetaLink-Autorisierung wird geprüft.

MetaLink-Benutzername: xxxxx
MetaLink-Kennwort: **********
URL für Patch-Suche: http://updates.oracle.com

OEM-Repository wird mit neuesten Release-Tabellendaten aus Oracle MetaLink aktualisiert.

OK
_______________________________________________________

I changed the value back to 300 and another update went fine with this standard value. Perhaps it just needed the high cursor value for the initial building of the repository. My version/patch number is 10.1.0.2.0 PatchUpdate 6.
257424
In version 10.1.0.2 this is a known problem
Metalink doc = Note:309155.1
EM patchset = Patch 3731593

I just ran into this on a 10.1.0.2. I tried increasing the cursors but it didn't work for me.
vhbtech
i now updated to 10.1.0.4 Patch4 and it seems to work now
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 5 2005
Added on Mar 15 2005
8 comments
1,186 views