Looks like bequeath connection issue on DR

Hi Experts,

Wanted to understand what is wrong here.

On my PROD Primary:

I connect as a non-oracle OS user that doesn't belong to dba group and then I connect to the database with some user and run the following query and get the desired output:

SQL> !id

uid=2001(datprd) gid=141(dbs) groups=141(dbs)

SQL> select used_percent from dba_tablespace_usage_metrics where tablespace_name='CMSP1TB01';

USED_PERCENT

------------

  82.1571402

On my PROD Standby:

I connect as a non-oracle OS user that doesn't belong to dba group and then I connect to the database with some user and run the following query and I DO NOT get the desired output: