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