post stopped due to error ORA-28100 (4220149)

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

post stopped due to error ORA-28100
Beschreibung

Post stopped due to ORA-28100 policy function schema string is invalid
Ursache

Oracle schema is dropped after the policy associated with the function is added to the object. Oracle's reccommendation is to drop the policy and re-create it with a policy function owned by valid user or re-create the user and policy function under the new user
Lösung

Workaround:
Login as SYSDBA and Grant "EXEMPT ACCESS POLICY" to the SharePlex user .

SQL> Grant EXEMPT ACCESS POLICY to <SharePlex Oracle User>;
OR can skip the error.
1. Added 28100 error to the $SP_SYS_VARDIR/data/oramsglist and increment the error count value on first line and saved changes
2. instructed post to continue on error by sp_ctrl> set param SP_OPO_CONT_ON_ERR 1
3. Start post

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Produkt(e):: SharePlex
9.2.10, 10.0, 9.2.9, 9.4.0, 9.2.8, 9.2.7, 9.2.6, 9.2.5, 9.2.4, 8.6, 8.5, 8.0, 7.6

Titel