When reinstalling the Oracle Enterpreise Manager reporsitory (oracel 11.2 64bit) using the command

emca -config dbcontrol db -repos recreate -silent   ... lots parameter

I am presented with the followin error message:

Package body created.
No errors.    
Package body created.
No errors.
CREATE OR REPLACE TRIGGER MGMT_DB_HDM_METRIC_TR
                          *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "FORMSPIDER.BDF_DBOBJECT_QRY", line 318
ORA-06512: at "FORMSPIDER.API_VERSIONCONTROL", line 219
ORA-06512: at line 7

Which is insofar weird as apparently ORACLE Code seems to call objects owned by schema formspider. Any idea what to do? (Formspider 1.8 is installed under schema FORMSPIDER, FS 1.9 ist installed under schema FORMSPIDER19)

asked 25 Sep '15, 05:26

dipr's gravatar image

dipr
1561325
accept rate: 0%


Hi Paul,

I guess the Formspider database level triggers which are used for version control are the source of your problem. I suggest you disable them temporarily during the installation. The two trigger are named:

BDF_SOURCECONTROL_AC
BDF_SOURCECONTROL_AD

Kind Regards,
Yalim

link

answered 28 Sep '15, 05:00

Yalim's gravatar image

Yalim ♦♦
2.8k5
accept rate: 22%

Perfect! issue is fixed.

(28 Sep '15, 12:12) dipr
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×1
×1
×1
×1
×1

Asked: 25 Sep '15, 05:26

Seen: 3,322 times

Last updated: 28 Sep '15, 12:12

Related questions


© Copyright Gerger 2017