PLS-00201: identifier 'DBMS_XSTREAM_GG_ADM' must be declared - GoldenGate

 

Grant the below privileges to gguser -

exec dbms_goldengate_auth.grant_admin_privilege('<ogg_user>');
grant select any dictionary to <ogg_user>;
grant insert any table to <ogg_user>;
grant update any table to <ogg_user>;
grant delete any table to <ogg_user>;

Comments

Post a Comment

Popular posts from this blog

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more

OAM 11.1.2.3 - Bad Oracle Access Manager Request Error After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717

After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717, when accessing the http resource then it was giving Bad Oracle Access Manager Like when accessing "http://hostname.domain:7779/index.html" we get following message in the logfile "diagnostics/logs/OHS/ohs1/oblog.log" 2018/10/26@15:29:46.68427       1890    1950    WEB     ERROR   0x0000151F      /ade/aime_ngamac_748106/ngamac/src/palantir/commonlib/src/apache2_req_info.cpp:294     ecid^005UIDZfNp87U8ups^h8iX0000SX00001w  rid^0   "WebGate Error Report"  Message^Unable to process the request due to unexpected error.  ReqReq^GET /public/index.html HTTP/1.1  ReqProto^HTTP/1.1       ReqHost^bdrvl-pd-oid01  ReqStatLine^    ReqStatus^200   ReqRawUri^/public/index.html    ReqUri^/public/index.html       ReqFilename^...
Read more