Re: AWR in OCI ATP

Yes I have mentioned proxy host and port as well in sqlnet.ora file.

Are there any other settings that needs to be done, tmsping or sqlplus connection just hangs without giving any error message.

On Fri 24 Jan, 2020, 1:04 PM Ghassan Salem, <salem.ghassan_at_gmail.com> wrote:

> Hi,
> For option 2, are you behind a firewall? If so try setting the sqlnet.ora
> and tnsnames.ora to go through an http proxy.
>
> Rgds
>
> On Fri, Jan 24, 2020, 08:11 Arpit Aggarwal <arpitdba2019_at_gmail.com> wrote:
>
>> Hi Friends,
>>
>> Has anyone tried generating a AWR report in OCI ATP database ,
>> considering we don't have physical host access.
>> I tried 2 options but had hit a blocker for both, if anyone else came
>> across same, kindly assist.
>>
>> Option#1 ,
>>
>> I logged in to ATP sql developer as ADMIN user and executed below query
>> to get a list of available snapshots,
>>
>> select SNAP_ID,DBID,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from
>> dba_hist_snapshot where INSTANCE_NUMBER=1 order by SNAP_ID ;
>>
>> And further executed below query to generate AWR in html format,
>>
>> SELECT output FROM TABLE
>> (dbms_workload_repository.awr_report_html(&dbid,&instnum,&beginsnap,&endsnap
>> ));
>>
>> The only problem with above was that the resulted AWR html report when
>> exported from sql developer does not converts into an easy readable format.
>>
>> Option#2,
>>
>> The other approach that I tried is by connecting to ATP database from my
>> local machine but for some reasons the ATP host is not resolvable from my
>> local machine though I have modified sqlnet.ora and tnsnames.ora
>> accordingly.
>>
>> The benefit of this approach would be that we can just spool the html o/p
>> of above query of AWR repository and can view it easily on our local
>> machine.
>>
>> Reference -
>> https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-preparing.html#GUID-6F118C83-5BD2-4C10-88F2-B7A6280D1EE1
>>
>> https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-sqlplus.html#GUID-A3005A6E-9ECF-40CB-8EFC-D1CFF664EC5A
>>
>> My tnsnames.ora and sqlnet.ora has been modified based on oracle doc.
>>
>>
>> Thanks,
>> Arpit
>>
>

--
http://www.freelists.org/webpage/oracle-l