ORA-01950: no privileges on tablespace 'SYSAUX' when adding REDO collector
Hi all
This error has eaten up my day with pain. Only REDO collector is refusing other collectors I have added, started and running. I am using audit vault 10.3 in Linux
Adding at first time
[oracle@avsrv ~]$ avorcldb add_collector -srcname ORCL -agentname avagent01 -colltype REDO -collname REDO_coll -av avsrv:1521:av.avsrv
source ORCL verified for REDO Log Audit Collector collector
Adding collector...
Collector added successfully.
remember the following information for use in avctl
Collector name (collname): REDO_coll
initializing REDO Collector
setting up APPLY process on Audit Vault server
ERROR: ORA-01950: no privileges on tablespace 'SYSAUX'
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 746
This error has eaten up my day with pain. Only REDO collector is refusing other collectors I have added, started and running. I am using audit vault 10.3 in Linux
Adding at first time
[oracle@avsrv ~]$ avorcldb add_collector -srcname ORCL -agentname avagent01 -colltype REDO -collname REDO_coll -av avsrv:1521:av.avsrv
source ORCL verified for REDO Log Audit Collector collector
Adding collector...
Collector added successfully.
remember the following information for use in avctl
Collector name (collname): REDO_coll
initializing REDO Collector
setting up APPLY process on Audit Vault server
ERROR: ORA-01950: no privileges on tablespace 'SYSAUX'
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 746
1