Monday, March 18, 2019

Generate Trace file in Oracle 12c (Windows Platform)

C:\WINDOWS\system32>sqlplus sys as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Mon Mar 18 17:01:38 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter session set tracefile_identifier='SRDC_10937';

Session altered.

SQL> alter session set events '10937 trace name context forever, level 4';

Session altered.

SQL> SELECT UTL_HTTP.request (
  2            url               => 'https://ws.xxx.com/cxfws2/services/Ping',
  3            proxy             => 'http://www-proxy.com:80',
  4            wallet_path       => 'file:C:\app\rajam\product\12.1.0\dbhome_1\owm\wallet_53',
  5            wallet_password   => 'xxxxxxxxxxx')
  6    FROM DUAL;
SELECT UTL_HTTP.request (
       *
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-29263: HTTP protocol error
ORA-06512: at line 1


SQL> alter system set events '10937 trace name context off';

System altered.

SQL>

Below Trace files will be generated in the path C:\app\rajam\diag\rdbms\orcl\orcl\trace
orcl_ora_18972_SRDC_10937.trc
orcl_ora_18972_SRDC_10937.trm

No comments:

Post a Comment

Delete Row Button to all records of Interactive Report in Oracle Apex

 1. add 'Delete' Del column to Report Query 2. Set the Following Properties for the DEL Column Type: Link Heading: Delete Targ...