Applies to Oracle Database, Web Logic, Wallet, Oracle Wallet Manager.
Understanding is that you already have Oracle Wallet Manager installed, this is part of full Oracle Database installation.
1.1. Enter a new password as part of wallet creation.
[youros]/testcases/mydir> mkstore -wrl /testcases/mydir/mytest -create
Enter password: mytest123
Enter password again: mytest123
Upon created of wallet you will find files like cwallet.sso, ewallet.p12 in your directory where the wallets were created:
[youros]/testcases/mydir> cd mytest
[youros]/testcases/mydir/mytest> ls
cwallet.sso ewallet.p12
Syntax: mkstore -wrl <wallet_location> -createCredential <alias> <user_name> <password>
Enter wallet password: <password that was previously used for wallet creation>
[youros]/testcases/mydir/mytest> mkstore -wrl /testcases/mydir/mytest/ -createCredential SHIVAV1024U.yours.mine.com scott tiger
Enter wallet password: mytest123
Create credential oracle.security.client.connect_string1
Now you have both wallet and wallet credential ready.
You can use Oracle server side packages like utl_http to request external site. You may need to use proxy servers if you are behind proxy.
Case 1: To make utl_http.request call using Proxy Server
Syntax:
SELECT utl_http.request('<url>', '<proxy server:port>') FROM DUAL;
Example:
SQL> SELECT utl_http.request('http://www.formsite.com', 'www-proxy.yours.mine.com') from dual;
UTL_HTTP.REQUEST('HTTP://WWW.FORMSITE.COM','WWW-PROXY.YOURS.MINE.COM')
--------------------------------------------------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/x
html1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><!-- Instance
Begin template="/Templates/Full.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
...
<removed rest of the contents>
Case 2: To make utl_http.request call using Proxy Server with Wallet
Syntax:
SELECT utl_http.request('<url>', '<proxy server:port>', 'file:<wallet directory reference>', '<wallet password>') FROM DUAL;
Example:
SELECT utl_http.request('http://www.formsite.com', 'www-proxy.yours.mine.com','file:/testcases/mydir/mytest/','mytest123') FROM DUAL;
UTL_HTTP.REQUEST('HTTP://WWW.FORMSITE.COM','WWW-PROXY.YOURS.MINE.COM','FILE:/TEST
--------------------------------------------------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/x
html1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><!-- Instance
Begin template="/Templates/Full.dwt" codeOutsideHTMLIsLocked="false" -->
...
<removed rest of the contents>
If the call fails, you might get errors like:
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-29024: Certificate validation failure
ORA-06512: at line 1
1. Oracle Fusion Middleware Administrator's Guide
11g Release 1 (11.1.1)
Part Number E10105-13
Chapter 8 Managing Keystores, Wallets, and Certificates
URL: http://docs.oracle.com/cd/E23943_01/core.1111/e10105/wallets.htm#CIHIHGJG
2. Oracle Database Advanced Security Administrator's Guide
11g Release 2 (11.2)
E40393-02
Section F orapki Utility
URL: http://docs.oracle.com/cd/E11882_01/network.112/e10746/asoappf.htm
Understanding is that you already have Oracle Wallet Manager installed, this is part of full Oracle Database installation.
1. To create wallet:
1.1. Enter a new password as part of wallet creation.
[youros]/testcases/mydir> mkstore -wrl /testcases/mydir/mytest -create
Enter password: mytest123
Enter password again: mytest123
2. Wallet Created Directory:
Upon created of wallet you will find files like cwallet.sso, ewallet.p12 in your directory where the wallets were created:
[youros]/testcases/mydir> cd mytest
[youros]/testcases/mydir/mytest> ls
cwallet.sso ewallet.p12
3. To create wallet credential:
Syntax: mkstore -wrl <wallet_location> -createCredential <alias> <user_name> <password>
Enter wallet password: <password that was previously used for wallet creation>
[youros]/testcases/mydir/mytest> mkstore -wrl /testcases/mydir/mytest/ -createCredential SHIVAV1024U.yours.mine.com scott tiger
Enter wallet password: mytest123
Create credential oracle.security.client.connect_string1
Now you have both wallet and wallet credential ready.
4. To Test Wallet:
You can use Oracle server side packages like utl_http to request external site. You may need to use proxy servers if you are behind proxy.
Case 1: To make utl_http.request call using Proxy Server
Syntax:
SELECT utl_http.request('<url>', '<proxy server:port>') FROM DUAL;
Example:
SQL> SELECT utl_http.request('http://www.formsite.com', 'www-proxy.yours.mine.com') from dual;
UTL_HTTP.REQUEST('HTTP://WWW.FORMSITE.COM','WWW-PROXY.YOURS.MINE.COM')
--------------------------------------------------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/x
html1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><!-- Instance
Begin template="/Templates/Full.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
...
<removed rest of the contents>
Case 2: To make utl_http.request call using Proxy Server with Wallet
Syntax:
SELECT utl_http.request('<url>', '<proxy server:port>', 'file:<wallet directory reference>', '<wallet password>') FROM DUAL;
UTL_HTTP.REQUEST('HTTP://WWW.FORMSITE.COM','WWW-PROXY.YOURS.MINE.COM','FILE:/TEST
--------------------------------------------------------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/x
html1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><!-- Instance
Begin template="/Templates/Full.dwt" codeOutsideHTMLIsLocked="false" -->
...
<removed rest of the contents>
If the call fails, you might get errors like:
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1577
ORA-29024: Certificate validation failure
ORA-06512: at line 1
Reference / Read More
1. Oracle Fusion Middleware Administrator's Guide
11g Release 1 (11.1.1)
Part Number E10105-13
Chapter 8 Managing Keystores, Wallets, and Certificates
URL: http://docs.oracle.com/cd/E23943_01/core.1111/e10105/wallets.htm#CIHIHGJG
2. Oracle Database Advanced Security Administrator's Guide
11g Release 2 (11.2)
E40393-02
Section F orapki Utility
URL: http://docs.oracle.com/cd/E11882_01/network.112/e10746/asoappf.htm
No comments:
Post a Comment