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@xxxxxxxxx> 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@xxxxxxxxx> 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
