Db version: 22.214.171.124 in RAC on ODA X5-2 and Singletenant and VPD.
Test case query:
SELECT CLIENT_CODE, CONS_CODE, RES_DATE, NAV_BEGIN, NAV_END, LEV1_NAME, LEV2_NAME, LEV3_NAME, INSTR_NAME, ASSET_CODE, GR_RESULT, MARK_RESULT, FOREX_RESULT, FEE_RESULT, EXPOS_BEGIN, EXPOS_END FROM USER_XXX.DATAM_DAILY_INS where PER = 'E20D0A1159BC4627B1BE9EDAEAE42802';
Connected to cusarprd pdb using default service cusarprd.customer.com with user “myuser” gives me datas.
Whatever the value of optimizer_adaptive_features.
Connected to cusarprd pdb using cusar_readwrite.customer.com with user “myuser” gives NO data.
With optimizer_adaptive_features = false -> no data
With optimizer_adaptive_features = true -> data
The service cusarprd.customer.com is the default PDB service not created with grid infrastructure
alter session set container=cusarprd; Session altered. select name from dba_services; NAME ---------------------------------------------------------------- cusarprd.customer.com cusar_readwrite.customer.com cusar_readonly.customer.com cusar_snapshot.customer.com
The service cusar_readwrite.customer.com is the PDB service created with grid infrastructure
[oracle@cusoda01n1 ~]$ srvctl status service -d arprd Service cus_cdb_ar_readonly.customer.com is not running. Service cus_cdb_ar_readwrite.customer.com is running on instance(s) carprd1,carprd2 Service cus_cdb_ar_snapshot.customer.com is not running. Service cusar_readonly.customer.com is not running. Service cusar_readwrite.customer.com is running on instance(s) carprd1,carprd2 Service cusar_snapshot.customer.com is not running.The following two tabs change content below.
JacquesI am Oracle Certified Master 11g & 12c database architect with significant experience in heterogeneous environments, and strong ability to lead complex and critical projects requiring multiple technical implementations. at Trivadis SA
Latest posts by Jacques (see all)
- 8 Nodes Cluster Upgrade from 126.96.36.199 to 188.8.131.52 - May 12, 2019
- RAC Database upgrade from 184.108.40.206 to 220.127.116.11 - May 12, 2019
- Managing Standby RedoLogs - May 12, 2019
- Cannot create database on ODA X6-2m after changing default port from 1521 to 13200 - January 8, 2018
- Setting up TAF with Data Guard: news from error ORA-16456 - December 13, 2016