Hi,
I'm trying to generate an AWR report from a PDB, with this error, using 12c R2 (Oracle Database 12c Enterprise Edition Release 12.2.0.1.0)
Connected to a PDB execute:
SQL> @?/rdbms/admin/awrrpt
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
AWR reports can be generated in the following formats. Please enter the
name of the format at the prompt. Default value is 'html'.
'html' HTML format (default)
'text' Text format
'active-html' Includes Performance Hub active report
Enter value for report_type: text
old 1: select 'Type Specified: ',lower(nvl('&&report_type','html')) report_type from dual
new 1: select 'Type Specified: ',lower(nvl('text','html')) report_type from dual
Type Specified: text
Specify the location of AWR Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
AWR_ROOT - Use AWR data from root (default)
AWR_PDB - Use AWR data from PDB
Enter value for awr_location: AWR_PDB
Location of AWR Data Specified: AWR_PDB
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance Container Name
-------------- -------------- -------------- -------------- --------------
2532170184 CODS2P 1 CODS2P ODS2P
Root DB Id Container DB Id AWR DB Id
--------------- --------------- ---------------
151209790 2532170184 2532170184
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
------------ ---------- --------- ---------- ------
3522870585 1 ODS2P ODS2P procasdwhx01
Using 2532170184 for database Id
Using 1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 2532170184/1 does not exist in
AWR_PDB_DATABASE_INSTANCE
ORA-06512: at line 27
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
My user has this privs and roles.
SQL> show user
USER is "DX0001"
SQL> select * from session_roleS;
ROLE
--------------------------------------------------------------------------------
SELECT_CATALOG_ROLE
HS_ADMIN_ROLE
HS_ADMIN_SELECT_ROLE
HS_ADMIN_EXECUTE_ROLE
SQL> select * from session_privs;
PRIVILEGE
----------------------------------------
CREATE SESSION
CREATE TABLE
CREATE PROCEDURE
ADVISOR
Any know hopw fix this issue?
I need some privilege?
Thanks
Arturo