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