HTTP to HTTPS (SSL - Connection APEX/ORDS-Tomcat)

-

 


HTTP to HTTPS (Tomcat)



1) Get the Secure Certificate first



https://www.digicert.com/util/



https://support.code42.com/Administrator/6/Configuring/Install_a_CA-signed_SSL_certificate_for_HTTPS_console_access



http://certificate.fyicenter.com/97_JDK_Keytool_How_to_Find_the_Java_Keytool_on_Windows.html




https://support.code42.com/Administrator/6/Configuring/Install_a_CA-signed_SSL_certificate_for_HTTPS_console_access



2) Do the following step 



keytool -genkey -alias APEX -keyalg RSA -keystore "C:\apex_way2cis_keystore.jks" -ext SAN=dns:apex.way2cis.com,ip:208.93.232.133



Keystore Password: Way2Cis@2020!!


keytool -genkeypair -alias apex.way2cis.com -storetype jks -keystore apex.way2cis.com.jks -validity 366 -keyalg RSA -keysize 4096


keytool -certreq -alias apex.way2cis.com -file apex_way2cis.csr -keystore apex.way2cis.com.jks -ext san=dns:apex.way2cis.com


keytool -importcert -alias apex.way2cis.com -file CAreply.p7b -keystore apex.way2cis.com.jks -trustcacerts



keytool -importkeystore -srckeystore apex_way2cis_com.pfx -srcstoretype PKCS12 -destkeystore apex.way2cis.com.jks -deststoretype jks


keytool -importkeystore -srckeystore apex.way2cis.com.jks -destkeystore apex.way2cis.com.jks -deststoretype pkcs12


=================================================================

3 Go to C:\Program Files\Apache Software Foundation\Tomcat 9.0\conf\service.xml

=============================================================


<Connector port="8443" 

maxThreads="150" scheme="https" secure="true" 

SSLEngine="on" 

SSLCertificateFile="C:\Users\jignesh\Documents\SSL Certificate\apex_way2cis_com.crt" 

SSLCertificateKeyFile="C:\Users\jignesh\Documents\SSL Certificate\apex_way2cis_com.key" 

SSLPassword="Way2Cis@2020!!" 

clientAuth="false" sslProtocol="TLS"/>


select utl_http.request ('https://<URL>',null,'file:/tmp/test_wallet') from dual;



=================

useful URL

================


https://docs.oracle.com/en/java/javase/11/tools/keytool.html


https://documentation.commvault.com/commvault/v11/article?p=50497.htm

-


https://www.journaldev.com/160/steps-to-configure-ssl-on-tomcat-and-setup-auto-redirect-from-http-to-https


Comments

Post a Comment

Popular posts from this blog

Telegram Integration with Oracle

-
 How to Integrate Telegram with Oracle Apex 1) create Telegram Account in your Mobile like whatsapp 2) Ones you register in telegram apps serach for BotFather 3) To Create New Bot u need to enter below command  /newbot  Alright, a new bot. How are we going to call it? Please choose a name for your bot. Macsbot Good. Now let's choose a username for your bot. It must end in `bot`. Like this, for example: TetrisBot or tetris_bot. MacsOmanBot Done! Congratulations on your new bot. You will find it at t.me/MacsOmanBot. You can now add a description, about section and profile picture for your bot, see /help for a list of commands. By the way, when you've finished creating your cool bot, ping our Bot Support if you want a better username for it. Just make sure the bot is fully operational before you do this. Use this token to access the HTTP API:<Here you will prompt with your api> 4) /mybots (this command will return the list of bots which you have created) ...
Read more

The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked

-
  1. Execute the following command from SQL Plus as the SYS user:  Conn sys/Pass@xe as sysdba  (connect as container if 12c then  ALTER SESSION SET container = CDB$ROOT;) Alter user ords_public_user identified by xxxx; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; Connect as PDB Conn sys/Pass@xepdb1 as sysdba (if 12c  ALTER SESSION SET container = PDB1;) Alter user APEX_PUBLIC_USER identified by xxxx; Alter user APEX_REST_PUBLIC_USER identified by xxxx; Alter user APEX_LISTENER identified by xxxx; 2. Unlock the users: ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_LISTENER ACCOUNT UNLOCK; ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK; 3. Now create a profile for the APEX related users: Create profile apex_public_profile limit password_life_time unlimited; 4. Assign the profile to the APEX users: alter user apex_public_user profile apex_public_profile; alter user apex_rest_public_user profile apex_public_pr...
Read more

Enabled SQL Developer Web (SDW) & ORDS Database API ORDS 19.4

-
SQL Developer Web (SDW)  ORDS 19.2 to 19.4 Migration /  Basic Setup to Enable ORDS Database API Bsic Information  Installing Oracle REST Data Services https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-673D35DD-9811-42F8-A500-4F494F79C470 https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/19.4/aelig/installing-REST-data-services.html#GUID-2C42D982-BF08-48E3-A4C6-3FE1A78287E3 Using Oracle® SQL Developer Web https://docs.oracle.com/en/database/oracle/sql-developer-web/19.2.1/sdweb/about-sdw.html#GUID-AF7601F9-7713-4ECC-8EC9-FB0296002C69 How to Configure / Run ORDS for SQL Developer Web and APEX in Standalone Mode: ORDS 19.4 + (Doc ID 2628004.1) GOAL This document is an overview on how to configure and run ORDS standalone for SQL Developer Web using the command line interface. It also includes the steps related to setting up APEX, since the ability to run APEX as well as SQL Develo...
Read more