Hi trying connect oracle db and executing below commands but getting this error can some help to fix this.
SELECT to_char(SYSDATE,'DD-MON-YYYY HH12:MI:SS AM') Report_Generate_AT FROM DUAL;
SELECT NAME,OPEN_MODE FROM V$DATABASE;
SELECT INST_ID,INSTANCE_NAME,HOST_NAME FROM GV$INSTANCE;
SELECT COUNT(*),USERNAME,INST_ID FROM GV$SESSION WHERE USERNAME IS NOT NULL GROUP BY USERNAME,INST_ID ORDER BY INST_ID;
SHOW PARAMETER AUDIT;
SELECT * FROM DBA_USERS ORDER BY USERNAME;
select PROFILE,RESOURCE_NAME,RESOURCE_TYPE,LIMIT from dba_profiles where RESOURCE_TYPE like 'PASSWORD%' order by PROFILE;
select DBMS_METADATA.GET_DDL('FUNCTION','XXX_DC_PASSWD_VERIFY_FUNCTION','SYS') from DUAL;
SELECT * FROM DBA_SYS_PRIVS ORDER BY GRANTEE;
SELECT * FROM DBA_ROLE_PRIVS ORDER BY GRANTEE;
SELECT * FROM DBA_TAB_PRIVS where GRANTEE in (select username from dba_users where profile in ('XXX_DC_SUPPORT_PROFILE','XXX_DC_USER_PROFILE')) ORDER BY GRANTEE;