Re: Create repository in Enterprise Manager

Try to create a new database and put OEM repository on it.

"Dirk Maiwert" <maiwert_at_t-online.de> wrote in message news:<9hss1d$gve$06$1_at_news.t-online.com>...
> Hello,
>
> i try to create a new repository in enterprise Manager.
> Oracle Agent and database are running...
> After all Steps the configuration assistant sums up, for example:
>
> User: myuser
> In DB: node1:1521:mydb
> create user: yes
> standard tablespace: OEM_REPOSITORY
> temp tablespace: TEMP
> update OMS config: yes
>
> I click on finish and it creates the user, but in the second step (create
> repository) following error comes up:
> -----------------------------------------------
> SQL Exception:
> ORA-06553: PLS-707: Nicht unterstütztes Konstrukt oder interner Fehler[2603]
>
> /* OracleOEM */ create trigger SMP_VDU_PRIV_OBJECT_TRIG before delete
> on smp_vdu_objects_table for each row
> BEGIN
> DELETE from SMP_VDU_PRIVILEGE_TABLE where OBJECT_OID = :old.OBJECT_ID;
> END;
> -------------------------------------------------
>
>
> How can I prevent this and can create a repository for my database?
> Thank you in advance!
> Dirk
Received on Thu Jul 26 2001 - 17:46:28 CDT