Configuring Oracle Stage in Parallel Extender

[pcmbalaji]

Hi all,
The following error had occured while viewing the data in Oracle Stage.

Error when inserting partitioner: Prepare failed for: GenericStmt_4
>query is: select count(*) from sys.gv_$instance
>
>sqlcode is: -942
>esql complaint: ORA-00942: table or view does not exist
>
>
>##E TDOR 000508 05:47:44(001) <Oracle_0.DSLink3> Error when inserting partitioner: APT_OraInstanceSet::opsInstalled() : prepare failed for query 'select count(*) from sys.gv_$instance
>'. Please have the DBA run the following command: 'grant select on sys.gv_$instance to public;'


As per the parallel extender doc, select access on sys.gv_$instance is required only when the oracle parallel server is running. But in our case we have a normal Oracle Database running on the same unix box where DS is running. I'm not sure as why is it still looking for $instance ?

Any help on this would be appreciated.

Regards,

[ogmios]

Probably a default check, you can raise a ticket with Ascential ... grant access to the the table for now and see what that gives.

Ogmios

[ray.wurlod]

I believe the check is to determine whether the table is partitioned.

Is there any reason why your DBA won't grant SELECT privilege? It's an entirely harmless privilege.

[pcmbalaji]

yeah, It worked after giving the SELECT privilege on sys.gv_$instance but I dont understand as why Ascential had mentioned this is only for ORACLE PARALLEL SERVER ?. Anyway it is working now.


Thanks a lot

Regards

[ray.wurlod]

Because, for server jobs, it is immaterial whether the table is partitioned, so the check is not performed.