tag:blogger.com,1999:blog-16013527312383677312024-03-05T06:36:53.776-08:00Oracle Apex RND.I, Am Muhammad Abdullah Alnoor, Chief Consultant of TrainerBD.com is willing to share knowledge on Oracle, Linux and Oracle Apex. Dial +8801790721177 to be a friend.Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-1601352731238367731.post-16834160831252191372022-06-06T07:34:00.002-07:002022-06-06T07:34:22.065-07:00Learn HTML CSS and Javascript with Anisul Islam Rubel<h3 style="text-align: left;"><b>Youtube channel of Anisul Islam Rubel : </b><br /></h3><p><a href="https://www.youtube.com/c/anisulislamrubel">https://www.youtube.com/c/anisulislamrubel</a></p><p><b>HTML CSS AND JAVASCRIPT FOR HTML REPORT (To Learn) :</b><br /><br /><b>--- DIV AND TABLE : ---</b><br /><b><br />DIV : </b><br /><br /><a href="https://www.youtube.com/watch?v=zfRv9NyIVRg&list=PLgH5QX0i9K3oHBr5dsumGwjUxByN5Lnw3&index=24">https://www.youtube.com/watch?v=zfRv9NyIVRg&list=PLgH5QX0i9K3oHBr5dsumGwjUxByN5Lnw3&index=24</a><br /> </p><p><b>TABLE: START FROM 1 : </b></p><p><br /><a href="https://www.youtube.com/watch?v=yvDlTMs5ZGc&list=PLUvx2CKOD1pllH1JY-F2GgavwYPiQWKyC&index=28">https://www.youtube.com/watch?v=yvDlTMs5ZGc&list=PLUvx2CKOD1pllH1JY-F2GgavwYPiQWKyC&index=28</a><br /><br /><br /><b>CSS: ID AND CLASS :</b><br /><br /><a href="https://www.youtube.com/watch?v=c3ha4Dq_tdA&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=8">https://www.youtube.com/watch?v=c3ha4Dq_tdA&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=8</a><br /><br /><br /><b>Layout Design :</b></p><p><br /><a href="https://www.youtube.com/watch?v=jMzHXPpy9Ts&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=39">https://www.youtube.com/watch?v=jMzHXPpy9Ts&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=39</a><br /><br /><a href="https://www.youtube.com/watch?v=1cPT8O42ts8&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=40">https://www.youtube.com/watch?v=1cPT8O42ts8&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=40</a><br /><br /><a href="https://www.youtube.com/watch?v=E9cjmQy3dEY&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=41">https://www.youtube.com/watch?v=E9cjmQy3dEY&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=41</a><br /><br /><b>How to style HTML table :</b><br /><br /><a href="https://www.youtube.com/watch?v=z9a6GjqPaAk&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=54">https://www.youtube.com/watch?v=z9a6GjqPaAk&list=PLgH5QX0i9K3qjCBXjTmv7Xeh8MDUUVJDO&index=54</a><br /><br /><b>Bootstrap:</b><br /><br /><a href="https://www.youtube.com/watch?v=R517U0dZp6g&list=PLgH5QX0i9K3oC_wmWEZa2xWxJauIRQ9kG&index=24">https://www.youtube.com/watch?v=R517U0dZp6g&list=PLgH5QX0i9K3oC_wmWEZa2xWxJauIRQ9kG&index=24</a><br /><br /><b>Table:</b><br /><br /><a href="https://www.youtube.com/watch?v=74Ge1I0FzBk&list=PLgH5QX0i9K3oC_wmWEZa2xWxJauIRQ9kG&index=18">https://www.youtube.com/watch?v=74Ge1I0FzBk&list=PLgH5QX0i9K3oC_wmWEZa2xWxJauIRQ9kG&index=18</a><br /><br /><br /></p><p> <br /></p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-4813382217238768212021-09-02T11:58:00.004-07:002021-09-02T11:58:40.751-07:00Prebuilt Applications with blogging<blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p style="text-align: left;"> https://tedstruik-oracle.nl/ords/f?p=25384:1133::::::</p></blockquote><p> </p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-84717911114881946212021-07-22T22:09:00.008-07:002021-07-22T22:09:50.196-07:00Oracle Apex Image Prefix.<p> CD APEX21.1</p><p>CD APEX</p><p>CD UTILITIES</p><p><b>----------- <u>F:\apex_21.1\apex\utilities :</u></b></p><p>SQLPLUS /NOLOG</p><p>CONN SYS/SYS@ORCLPDB2 AS SYSDBA</p><p><span style="background-color: white; color: #555a62; font-family: "Oracle Sans";"><span style="font-size: medium;">@reset_image_prefix.sql</span></span></p><p><span style="color: #555a62; font-family: Oracle Sans; font-size: medium;">Enter the Application Express image prefix [/i/] /images211/</span></p><p><span style="color: #555a62; font-family: Oracle Sans; font-size: medium;">...Changing Application Express image prefix</span></p><p><span style="color: #555a62; font-family: Oracle Sans;"><u>NEW_IMAGE_P</u></span></p><p><span style="color: #555a62; font-family: Oracle Sans;"><span style="background-color: white;"></span></span></p><p><span style="color: #555a62; font-family: Oracle Sans;">/images211/</span></p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-18769851311493848752021-06-02T10:20:00.007-07:002021-06-02T10:53:27.764-07:00The connection pool named: |apex|rt| is not correctly configured, due to the following error(s): ORA-28000: The account is locked.<p>The connection pool named: |apex|rt| is not correctly configured, due to the following error(s): ORA-28000: The account is locked.<br /><br /></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOHBPxh1m-EjMa82QSqAAFZloBxw7xxOPllPWaAk9-JZntiaaiMuYli3crwDdWOvctLYMpCI3Smr08Geces17iD0w9ykbfhimIqO3_IBOL8NefdK3ChC2iOQP6JHF97mMrFdGp07fE74na/s491/apex_pu.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="230" data-original-width="491" height="301" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOHBPxh1m-EjMa82QSqAAFZloBxw7xxOPllPWaAk9-JZntiaaiMuYli3crwDdWOvctLYMpCI3Smr08Geces17iD0w9ykbfhimIqO3_IBOL8NefdK3ChC2iOQP6JHF97mMrFdGp07fE74na/w640-h301/apex_pu.png" width="640" /></a></div><br /><p><b><br /></b></p><p><b><br /></b></p><p><b><br /></b></p><p><b><br /></b></p><p><b><br /></b></p><p><b>Check if there is any Locked User :</b></p><p>CONN SYS/SYS@ORCLPDB AS SYSDBA</p><p>select username, account_status, profile from dba_users <br /> where username in ('APEX_PUBLIC_USER','APEX_LISTENER','APEX_REST_PUBLIC_USER'); </p><p><b>Run the following :</b><br /><br /></p><p>ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Apex123 ACCOUNT UNLOCK; <br />ALTER USER APEX_LISTENER IDENTIFIED BY Apex123 ACCOUNT UNLOCK; <br />ALTER USER APEX_REST_PUBLIC_USER identified BY Apex123 ACCOUNT UNLOCK;</p><p>ALTER USER APEX_200100 IDENTIFIED BY Apex123 ACCOUNT UNLOCK; <br />ALTER USER APEX_INSTANCE_ADMIN_USER IDENTIFIED BY Apex123 ACCOUNT UNLOCK; </p><p><br /></p><p><b>Windows :</b></p><p>Go to : D:\ords\conf\ords\conf<br />Give Password at each xml file like : !Apex123 [Must add an ! exclamatory sign. before password. ]</p><p><b><u>Files are :</u></b></p><p>apex.xml<br />apex_al.xml<br />apex_pu.xml<br />apex_rt.xml<br /></p><h3 style="text-align: left;"><b><u>apex.xml :</u></b></h3><p><b><?xml version="1.0" encoding="UTF-8"?></b></p><p><!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"><br /><properties><br /><comment>Saved on Wed Jun 02 22:29:52 BDT 2021</comment><br /><entry key="db.password"><b><span style="color: red;">!Apex123</span></b></entry><br /><entry key="db.username">APEX_PUBLIC_USER</entry><br /></properties></p><h3 style="text-align: left;"><b><u>apex_al.xml :</u></b></h3><div><div><?xml version="1.0" encoding="UTF-8"?></div><div><!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"></div><div><properties></div><div><comment>Saved on Wed Jun 02 23:12:48 BDT 2021</comment></div><div><entry key="db.password"><b><span style="color: red;">!Apex123</span></b></entry></div><div><entry key="db.username">APEX_LISTENER</entry></div><div></properties></div><div style="font-weight: bold;"><br /></div></div><h3 style="text-align: left;"><b><u>apex_pu.xml</u></b></h3><div><div><?xml version="1.0" encoding="UTF-8"?></div><div><!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"></div><div><properties></div><div><comment>Saved on Wed Jun 02 23:12:48 BDT 2021</comment></div><div><entry key="db.password"><b><span style="color: red;">!Apex123</span></b></entry></div><div><entry key="db.username">ORDS_PUBLIC_USER</entry></div><div></properties></div><div style="font-weight: bold;"><br /></div></div><h3 style="text-align: left;"><b><u>apex_rt.xml :</u></b></h3><div><div><?xml version="1.0" encoding="UTF-8"?></div><div><!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"></div><div><properties></div><div><comment>Saved on Wed Jun 02 23:12:48 BDT 2021</comment></div><div><entry key="db.password"><b><span style="color: red;">!Apex123</span></b></entry></div><div><entry key="db.username">APEX_REST_PUBLIC_USER</entry></div><div></properties></div><div style="font-weight: bold; text-decoration-line: underline;"><br /></div></div><div style="font-weight: bold;">Now Uninstall ORDS with the following command :</div><div style="font-weight: bold;"><br /></div><div>D:</div><div>CD ORDS</div><div>"C:\Program Files\Java\jdk-15.0.1\bin\java" -jar ords.war uninstall</div><div><b><br /></b></div><div><b>Now Install ORDS with following command :</b></div><div><b><br /></b></div><div>"C:\Program Files\Java\jdk-15.0.1\bin\java" -jar ords.war install advanced</div><div><br /></div><div>copy ords.war from </div><div>D:\ords </div><div>and paste to </div><div>C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps</div><div><br /></div><div>Now Restart Services :</div><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2qikOFkc4egSoit2qRAzJEcgLR9J9npGDb5favfmo-A73MnbN8XV3HQltkUwAyoL6n9-eMxIEhCMHrxdRB-ZchVtvEite06SeC_GPs4HGEJ1ZJkIqLqbKL3tsqNPqHSQvJ7BMtZjTMT2E/s1087/Screenshot_5.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="609" data-original-width="1087" height="315" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2qikOFkc4egSoit2qRAzJEcgLR9J9npGDb5favfmo-A73MnbN8XV3HQltkUwAyoL6n9-eMxIEhCMHrxdRB-ZchVtvEite06SeC_GPs4HGEJ1ZJkIqLqbKL3tsqNPqHSQvJ7BMtZjTMT2E/w400-h315/Screenshot_5.png" width="400" /></a></div></blockquote><br /><div><br /><br /><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div><p><br /></p><p><b>Now Restart Tomcat.</b></p><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMkENybYmOf-2hy8QurZic-ylC41q0_mX_SkbMH7Fe7qujDyGCEI474b-Mvk56TPylSCMPqY5fdO1Z2RlMhyiyQs8Rj8wcw0lTHozy_-dPnXy_7wMzXhoR8TG2hvN2fYzi8QPL56aw0vcy/s1083/Screenshot_6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="603" data-original-width="1083" height="223" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMkENybYmOf-2hy8QurZic-ylC41q0_mX_SkbMH7Fe7qujDyGCEI474b-Mvk56TPylSCMPqY5fdO1Z2RlMhyiyQs8Rj8wcw0lTHozy_-dPnXy_7wMzXhoR8TG2hvN2fYzi8QPL56aw0vcy/w400-h223/Screenshot_6.png" width="400" /></a></div></blockquote><br /><p><b>Now run Apex with ORDS :</b><br /><br />localhost:8080/ords<br />or<br />127.0.0.1:8080/ords</p><p><br /></p><p><br /></p><div><br /></div>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-34101163057210281992021-05-30T11:29:00.002-07:002021-05-30T11:29:47.008-07:00How to Integrate Oracle 10g Reports with Oracle Apex<p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://drive.google.com/drive/folders/1cJCNLKU6PVTIL4947CXefgLnCS_HaB32?usp=sharing" rel="nofollow" style="margin-left: 1em; margin-right: 1em;" target="_blank"><img alt="" data-original-height="145" data-original-width="641" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTFo-fGpgItHnA2OpPeQUByPWoHf20JLkHUn_TkzAVEmRJhPmZh8SKpMjtAkW3FSllVI7mC7CUDBTOy-lsNjqnkZmKaMhcJekBo9bcT2asExjUCTq4tv8tEkqiV0bV3Qi8Fwe9XDZKbkjK/w632-h172/image.png" width="632" /></a></div><p></p><h2 style="text-align: left;"><b>Script 1:</b></h2><p>var r_server = "http://192.168.100.100/reports/rwservlet?server=rep_appsrv1_asbiforms10&destype=cache&desformat";</p><p>var r_branch_code = $v("P100_BRANCH");</p><p>var r_emp_id = $v("P100_emp_NO");</p><p>var r_link = ""+r_server+"=pdf&userid=HR/HR@HR&REPORT=D:/A_REPORT/FUND_REPAYMENT_LETTER.rdf&P_BRANCH_CODE="+r_branch_code+"&P_REPAYMENT_NO="+r_emp_id+"";</p><p>window.open(r_link);</p><h2 style="text-align: left;"><b>Script 2 :</b></h2><div><div><b>var serIp = $v("P14_SERIP");</b></div><div><b><br /></b></div><div><b>var catId = $v("P14_ITEM_CAT");</b></div><div><b>var scatId = $v("P14_ITEM_SUB_CAT");</b></div><div><b>var coaId = $v("P14_COA_TYPE");</b></div><div><b><br /></b></div><div><b>var reportId = '&CATID='+catId+'&SCATID='+scatId+'&COAID='+coaId;</b></div><div><b><br /></b></div><div><b><br /></b></div><div><b>if ($v("14_RG")==1)</b></div><div><b>window.open(serIp+'COMPANY_INFO.rdf&SOMID=1');</b></div><div><b>else if ($v("14_RG")==2)</b></div><div><b>window.open(serIp+'DEPT_INFO.rdf');</b></div><div><b>else if ($v("14_RG")==3)</b></div><div><b>window.open(serIp+'DESIG_INFO.rdf');</b></div><div><b>else if ($v("14_RG")==4)</b></div><div><b>window.open(serIp+'LINE_INFO.rdf');</b></div><div><b>else if ($v("14_RG")==5)</b></div><div><b>window.open(serIp+'BLOCK_INFO.rdf');</b></div><div><b>else if ($v("14_RG")==6)</b></div><div><b>window.open(serIp+'BUYER_INFO.rdf');</b></div><div><b>else if ($v("14_RG")==7)</b></div><div><b>window.open(serIp+'SUPPLIER_INFO.rdf');</b></div><div><b>else if ($v("14_RG")==8)</b></div><div><b>window.open(serIp+'ITEM_INFO.rdf'+reportId);</b></div><div><b>else if ($v("14_RG")==9)</b></div><div><b>window.open(serIp+'CHART_OF_ACCOUNTS.rdf');</b></div></div><div><b><br /></b></div><div><div><b>DECLARE</b></div><div><b>A VARCHAR2(100);</b></div><div><b>B VARCHAR2(100);</b></div><div><b>C VARCHAR2(200);</b></div><div><b>D VARCHAR2(200);</b></div><div><b>E NUMBER;</b></div><div><b>BEGIN</b></div><div><b>SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') INTO A FROM DUAL;</b></div><div><b>SELECT SUBSTR(A,0,3) INTO B FROM DUAL;</b></div><div><b>SELECT LENGTH(A) INTO E FROM DUAL;</b></div><div><b>SELECT LIC_LOCAL_IP,LIC_REAL_IP INTO C,D FROM ISP_RUNAUTO;</b></div><div><b><br /></b></div><div><b>IF E>6 THEN</b></div><div><b> IF B=192 THEN RETURN C; ELSE RETURN D; END IF;</b></div><div><b>ELSE</b></div><div><b> RETURN C;</b></div><div><b>END IF;</b></div><div><b><br /></b></div><div><b>END;</b></div><div><b><br /></b></div></div><p><br /></p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-31969766415496548862021-04-30T04:31:00.001-07:002021-09-14T05:07:25.071-07:00Oracle Apex Software Development Companies<p><b>Oracle Apex Software Development Companies (1st page on google.)</b></p><p> <br /><a href="https://adjacentsolutions.com/">https://adjacentsolutions.com/</a><br /><br /><a href="http://ogesinfotech.com/index.php">http://ogesinfotech.com/index.php</a><br /><br /><a href="https://www.insum.ca/">https://www.insum.ca/</a><br /><br /><a href="https://pretius.com/main/">https://pretius.com/main/</a><br /><br /><a href="https://www.octalsoft.com/">https://www.octalsoft.com/</a><br /><a href="https://www.foex.at"><br />https://www.foex.at<br /></a><br /><a href="https://diceus.com">https://diceus.com</a></p><p>----------------------------------------------------------------------------------------------------------------------- <br /></p><p><a href="https://abacasys.com/oracle-apex-software-development-company-india/">https://abacasys.com/oracle-apex-software-development-company-india/</a></p><p><a href="https://www.octalsoft.com/">https://www.octalsoft.com/</a></p><p><a href="https://datacons.co.uk/">https://datacons.co.uk/</a></p><p><a href="https://magia-solutions.com/oracle-solutions/oracle-application-express/">https://magia-solutions.com/oracle-solutions/oracle-application-express/</a></p><p><a href="https://spiresoftware.ca/oracle-apex-services/">https://spiresoftware.ca/oracle-apex-services/</a></p><p><a href="https://www.cisin.com/">https://www.cisin.com/</a></p><p><a href="https://www.foex.at/home/">https://www.foex.at/home/</a></p><p><a href="https://www.dsp.co.uk/">https://www.dsp.co.uk/</a></p><p><a href="https://datacons.co.uk/">https://datacons.co.uk/</a></p><p><a href="https://www.insum.ca/apex-community/about-oracle-apex/">https://www.insum.ca/apex-community/about-oracle-apex/</a></p><p><a href="https://pretius.com/technologies/oracle-apex/">https://pretius.com/technologies/oracle-apex/</a></p><p><a href="https://www.apexrnd.be/index.html">https://www.apexrnd.be/index.html</a></p><p><a href="https://itwire.com/business-software/oracle-launches-apex-application-development-service-and-oracle-database-21c.html">https://itwire.com/business-software/oracle-launches-apex-application-development-service-and-oracle-database-21c.html</a></p><p><a href="https://www.absolute-tech.com/products/oracle-apex-services/">https://www.absolute-tech.com/products/oracle-apex-services/</a></p><p><a href="https://www.techradar.com/news/oracle-wants-to-drastically-simplify-app-development-with-new-low-code-service">https://www.techradar.com/news/oracle-wants-to-drastically-simplify-app-development-with-new-low-code-service</a></p><p><a href="https://www.miroconsulting.com/blog/licensing-oracle-apex/">https://www.miroconsulting.com/blog/licensing-oracle-apex/</a></p><p><a href="https://opportunities.ledfaststart.com/global/en/job/P-100250/Oracle-APEX-Developer">https://opportunities.ledfaststart.com/global/en/job/P-100250/Oracle-APEX-Developer</a></p><p><a href="https://lsgsolutions.com/services/oracle-apex/">https://lsgsolutions.com/services/oracle-apex/</a></p><p><br /></p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-45319932902028655692021-04-19T02:58:00.006-07:002021-04-19T02:58:57.560-07:00Oracle Apex Date Picker to Text Field Dynamic Action PLsql<p> DECLARE</p><p> V VARCHAR2(10):='';</p><p> vAttdt date;</p><p>BEGIN</p><p> vAttdt := :p44_attdt;</p><p> :P44_ATTDT2:=TO_CHAR(VaTTDT,'RRRRMMDD');</p><p>END;</p><p></p><div class="separator" style="clear: both; text-align: center;"><img alt="" border="0" class="placeholder" id="03227f0c760c4" src="https://www.blogger.com/img/transparent.gif" style="background-color: #d8d8d8; background-image: url('https://fonts.gstatic.com/s/i/materialiconsextended/insert_photo/v6/grey600-24dp/1x/baseline_insert_photo_grey600_24dp.png'); background-position: center; background-repeat: no-repeat; opacity: 0.6;" /><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><br /></div><br /></div><br /><br /><p></p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-87642792184078478822021-04-19T02:53:00.002-07:002021-04-19T02:53:08.754-07:00Jasper Soft Character to Date conversion in Expression Editor<p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN9NAM681MsA0F8JlfApl6gZPi0FSUBaorAam3e3fc2vg40ahM3tT1JBqZUXCs3BUgGjhhynjM-raT52k1ejgHJrCu6THXwnozEuJo8xwnPBnaCh3m2TGeNBz77dOQ1QHLggPlRUcyQAQR/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="206" data-original-width="617" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjN9NAM681MsA0F8JlfApl6gZPi0FSUBaorAam3e3fc2vg40ahM3tT1JBqZUXCs3BUgGjhhynjM-raT52k1ejgHJrCu6THXwnozEuJo8xwnPBnaCh3m2TGeNBz77dOQ1QHLggPlRUcyQAQR/s16000/image.png" /></a></div><br /><p></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRjoKxIg1OSbqndTDV94OWeyqAbxx-imzRC-fh9j1fo_s50t4bICHb_uRn60oTsyhCrUKWeo3aDdky0K16kfn2NM3os6UnuzIzSruDKdMKsRn6n_h8iFWI_bS_nLSu76QEB6Fo-c-CaAAh/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="697" data-original-width="1358" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRjoKxIg1OSbqndTDV94OWeyqAbxx-imzRC-fh9j1fo_s50t4bICHb_uRn60oTsyhCrUKWeo3aDdky0K16kfn2NM3os6UnuzIzSruDKdMKsRn6n_h8iFWI_bS_nLSu76QEB6Fo-c-CaAAh/w559-h205/image.png" width="559" /></a></div><p></p><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p></p><div class="separator" style="clear: both; text-align: left;">click [..] to go to Expression Editor.</div><p></p></blockquote><p>new SimpleDateFormat("yyyyMMdd").parse($P{P_ATTDT})</p><p>$P{P_ATTDT} ------------ > This is the Parameter or field.</p><p>Note : Month should be in MM format not in mm Format. </p><p>e.g. new SimpleDateFormat("yyyyMMdd").parse($P{P_ATTDT})</p><p>enjoy !!!</p><p><br /></p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-18025906817355515342021-04-09T11:10:00.008-07:002021-04-09T11:20:55.492-07:00How to enable/disable ssh login through putty<p>Some time you may want to disable login through putty by the port 22 SSH. You have to reboot the pc after disable sshd. Then add the firewall ports. Start listener. Restart tomcat and start Apache.</p><p><b>Step 1 : Enable or disable sshd in vultr.com console after login</b></p><p>---- systemctl enable sshd</p><p>systemctl disable sshd</p><p><b>Step 2 : Restart the server.</b></p><p>init 6</p><p><b>Step 3 : Add firewall rules:</b></p><p>firewall-cmd --zone=public --add-port=80/tcp</p><p>firewall-cmd --zone=public --add-port=443/tcp</p><p>firewall-cmd --zone=public --add-port=1510/tcp</p><p>firewall-cmd --zone=public --add-port=1539/tcp</p><p><b>Step 3: Start listener :</b></p><p>. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh</p><p>lsnrctl start</p><p><b>Step 4 : Restart tomcat :</b></p><p>cd /usr/local/tomcat/bin</p><p>./shutdown.sh </p><p>./startup.sh</p><p><b>Step 5 : Start Apache :</b></p><p>sudo systemctl start httpd</p><div><br /></div>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-69345295215553682692021-04-06T03:36:00.002-07:002021-04-06T18:09:49.562-07:00How to integrate Jasper Report in Linux<p>cd /opt/oracle/apex</p><p>copy jri-2.7.0-jasper-6.16.0.zip to /opt/oracle/apex ---- By SSH Secure file transfer<br /><span face="Signika, Arial, Helvetica, sans-serif" style="background-color: white; color: #555555; font-size: 13px;"><br /></span></p><p><span face="Signika, Arial, Helvetica, sans-serif" style="background-color: white; color: #555555; font-size: 13px;">Download : </span><a href="https://github.com/daust/JasperReportsIntegration/releases" style="background-color: white; color: #de5c06; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px; outline: none; text-decoration-line: none;">https://github.com/daust/JasperReportsIntegration/releases</a></p><p>unzip jri-2.7.0-jasper-6.16.0.zip</p><p>mv jri-2.7.0-jasper-6.16.0 jri</p><p><br /></p><p>cd /opt/oracle/apex/jri</p><p>mkdir conf</p><p>mkdir logs</p><p>mkdir reports</p><p><br /></p><p>cd /opt/oracle/apex/jri/bin</p><p><br /></p><p>chmod +x setConfigDir.sh</p><p><br /></p><p>cd /opt/oracle/apex</p><p><br /></p><p>mkdir rep</p><p><br /></p><p>cd /opt/oracle/apex/jri/bin</p><p><br /></p><p>chmod +x setConfigDir.sh</p><p><br /></p><p>chmod +x /opt/oracle/apex/jri</p><p><br /></p><p>./setConfigDir.sh /opt/oracle/apex/jri/webapp/jri.war /opt/oracle/apex/jri</p><p><br /></p><p>cd /opt/oracle/apex/jri/conf</p><p><br /></p><p>192.168.1.1</p><p><br /></p><p>vi application.properties</p><p>---- Change IP Address, Port, DB, Username and password.</p><p>cp /opt/oracle/apex/jri/webapp/jri.war /usr/local/tomcat/webapps/</p><p><br /></p><p>cd /usr/local/tomcat/bin</p><p><br /></p><p>./shutdown.sh </p><p>./startup.sh</p><p><br /></p><p><b><u>Copy Reports to : (.jasper)</u></b></p><p>/opt/oracle/apex/jri/reports</p><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><b><u>Javascript :</u></b></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var report_server = "http://localhost:8080/jri/report?";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var report_name = "dept";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var report_format = "pdf";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var data_source = "default";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var run_report=""+report_server+"&_repName="+report_name+"&_repFormat="+report_format+"&_dataSource="+data_source+"";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">window.open(run_report);</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><b><u>Javascript with parameter :</u></b></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var report_server = "http://localhost:8080/jri/report?";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var report_name = "dept_param";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var report_format = "pdf";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var data_source = "default";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var ap_1 = $v("P3_DEPT");</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var rp_1 = "&P_DEPT";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var param = ""+rp_1+"="+ap_1+"";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var report=""+report_server+"&_repName="+report_name+"&_repFormat="+report_format+"&_dataSource="+data_source+"";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">var run_report = ""+report+""+param+"";</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on">window.open(run_report);</div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><br /></div><div dir="ltr" style="background-color: white; color: #555555; font-family: Signika, Arial, Helvetica, sans-serif; font-size: 13px;" trbidi="on"><div dir="ltr" trbidi="on">Reference : <a href="https://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/" style="color: #de5c06; outline: none; text-decoration-line: none;">https://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/</a></div><div dir="ltr" trbidi="on">Download : <a href="https://github.com/daust/JasperReportsIntegration/releases" style="color: #de5c06; outline: none; text-decoration-line: none;">https://github.com/daust/JasperReportsIntegration/releases</a></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><br /></div></div>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-58416784604734766122021-04-03T19:50:00.008-07:002021-04-09T11:16:20.311-07:00How to Install SSL Certbot of LetsEncrypt <p> <b><u>How to Install SSL Certbot of LetsEncrypt :</u></b></p><p><br /></p><p>vi /usr/local/tomcat/conf/server.xml</p><p>-- Change tomcat port to : 1610</p><p>cd /usr/local/tomcat/bin</p><p><br /></p><p>./shutdown.sh </p><p>./startup.sh</p><p><br /></p><p>firewall-cmd --zone=public --add-port=1610/tcp</p><p>firewall-cmd --zone=public --add-port=443/tcp</p><p>sudo systemctl start httpd</p><p>cd /etc/httpd/conf.d</p><p>vi 10-apex.conf</p><p><VirtualHost *:80></p><p> ServerName example.com</p><p> ServerAlias www.example.com</p><p> Redirect Permanent / https://example.com</p><p> ProxyRequests On</p><p> <Proxy *></p><p> Order deny,allow</p><p> Allow from all</p><p> </Proxy></p><p> <Location /></p><p> ProxyPreserveHost on</p><p> RequestHeader unset Origin</p><p> ProxyPass http://192.168.1.1:1610/</p><p> ProxyPassReverse http://192.168.1.1:1610/</p><p> </Location></p><p>RewriteEngine on</p><p>RewriteCond %{SERVER_NAME} =example.com [OR]</p><p>RewriteCond %{SERVER_NAME} =www.example.com [OR]</p><p>RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]</p><p></VirtualHost></p><p><br /></p><p>sudo yum install epel-release</p><p>sudo yum install certbot python2-certbot-apache mod_ssl</p><p>sudo certbot --apache -d example.com</p><p><b><u>Check the Status :</u></b></p><p>https://www.ssllabs.com/ssltest/analyze.html?d=example.com</p><p>--- Add Auto Renewal at crontab :</p><p>sudo crontab -e</p><p>-- Add this line at crontab</p><p>0 0,12 * * * python -c 'import random; import time; time.sleep(random.random() * 3600)' && certbot renew</p><p>sudo certbot renew --dry-run</p><p>vi /etc/hosts</p><div><pre style="border-radius: 5px; border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.30769; margin-bottom: 0px; margin-top: 0px; max-height: 600px; overflow-wrap: normal; overflow: auto; padding: 12px; vertical-align: baseline; width: auto;"><code style="border-radius: 0px; border: 0px; box-sizing: inherit; color: var(--black-800); font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;">192.168.0.1 example.com
192.168.0.1 www.example.com</code></pre></div>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-63182396246129258502021-01-21T08:18:00.004-08:002021-01-21T08:21:48.065-08:00How to install Oracle Database 19c In Centos 7 Linux<p> Install Oracle Database 19c :</p><p>-----------------------------</p><p>pSSWRDa</p><p>---------------- /opt/oracle/product/19c/dbhome_1</p><p>Log in as root.</p><p>curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm</p><p><br /></p><p>yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm</p><p><br /></p><p>cd /root</p><p># yum -y localinstall oracle-database-ee-19c.rpm</p><p>Change the port here:</p><p>vi /etc/sysconfig/oracledb_ORCLCDB-19c.conf </p><p>To configure a sample Oracle Database instance, run the following service configuration script:</p><p>mkdir -p /opt/oracle/oradata</p><p>vi /etc/hosts</p><p>157.230.243.130 srvr01</p><p>--- add ip address with hostname</p><p>/etc/init.d/oracledb_ORCLCDB-19c configure</p><p><br /></p><p>This script creates a container database (ORCLCDB) with one pluggable database (ORCLPDB1) </p><p>and configures the listener at the default port (1521).</p><p><br /></p><p>Review the status information that is displayed on your screen.</p><p><br /></p><p>echo '# setting oracle database environment variables and aliases' >> /etc/profile.d/oraenv.sh</p><p>echo 'ORACLE_SID=ORCLCDB' >> /etc/profile.d/oraenv.sh</p><p>echo 'ORAENV_ASK=NO' >> /etc/profile.d/oraenv.sh</p><p>echo 'ORACLE_HOME=/opt/oracle/product/19c/dbhome_1' >> /etc/profile.d/oraenv.sh</p><p>echo '. /usr/local/bin/oraenv -s' >> /etc/profile.d/oraenv.sh</p><p>echo 'alias sqlplus="rlwrap sqlplus"' >> /etc/profile.d/oraenv.sh</p><p>echo 'alias rman="rlwrap rman"' >> /etc/profile.d/oraenv.sh</p><p>. /etc/profile.d/oraenv.sh</p><p><br /></p><p>/opt/oracle/product/19c/dbhome_1</p><p>or vi /etc/profile.d/oraenv.sh</p><p>chmod 6751 $ORACLE_HOME/bin/*</p><p>systemctl enable oracledb_ORCLCDB-19c</p><p><br /></p><p># chown -R oracle:oinstall /opt </p><p># chmod -R 775 /opt </p><p><br /></p><p>chown -R oracle:dba /opt</p><p>chmod -R 777 /opt</p><p><br /></p><p>su oracle</p><p>sqlplus / as sysdba</p><p>create pfile from spfile;</p><p><br /></p><p>delete this parameter from pfile:</p><p><br /></p><p>*.memory_target=1024m</p><p><br /></p><p>create spfile from pfile;</p><p><br /></p><p>startup force pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCL.ora';</p><p><br /></p><p>COLUMN name FORMAT a20;</p><p>SELECT name,con_id FROM v$pdbs;</p><p>SELECT name as “Service Name” FROM v$active_services WHERE con_id=3;</p><p>SQLPLUS / as SYSDBA</p><p>SHOW con_name</p><p><br /></p><p>ALTER SESSION SET CONTAINER=orclpdb1;</p><p>Note that since 12c Oracle Database has multitenant architecture, which means there could be several pluggable databases and </p><p>one multitenant container database. By default, the XEPDB1 pluggable database is created during the installation of XE.</p><p><br /></p><p>To make it easier to connect to the pluggable database, I recommend editing of tnsnames.ora file and add there a new connection </p><p>descriptor that we are going to use:</p><p><br /></p><p>vi /opt/oracle/product/18c/dbhomeXE/network/admin/sqlnet.ora</p><p>SQLNET.ALLOWED_LOGON_VERSION=8</p><p><br /></p><p>vi /opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora</p><p>Add this record there below the standard XE record:</p><p><br /></p><p>PDB1 =</p><p> (DESCRIPTION =</p><p> (ADDRESS = (PROTOCOL = TCP)(HOST = 157.230.243.130)(PORT = 1539))</p><p> (CONNECT_DATA =</p><p> (SERVER = DEDICATED)</p><p> (SERVICE_NAME = XEPDB1)</p><p> )</p><p> )</p><p><br /></p><p>And save the changes.</p><p>alter session set "_ORACLE_SCRIPT"=true; </p><p>copy tnsnames to your windows oracle /network/admin folder.</p><p>Check connection from anywhere. e.g. Your Laptop or PC.</p><p>CONNECT WITHOUT GIVING ANY DATABASE NAME:</p><p>=========================================</p><p><br /></p><p>sqlplus /nolog</p><p>conn SYS/CBQQZ123 AS SYSDBA</p><p>SHUTDOWN IMMEDIATE</p><p>create pfile from spfile;</p><p>STARTUP</p><p>alter session set "_ORACLE_SCRIPT"=true; </p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-15445420756897888422021-01-21T08:16:00.007-08:002021-02-14T05:28:55.974-08:00How to Install Oracle 20.1 in Centos 7 and Oracle Database 11g Xe<p><u>Firewall Configuration :</u></p><p>firewall-cmd --zone=public --add-port=80/tcp<br />firewall-cmd --zone=public --add-port=8080/tcp<br />firewall-cmd --zone=public --add-port=1539/tcp<br /><br />. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh<br />sqlplus /nolog</p><p><b>TOMCAT :<br /></b>https://www.tecmint.com/install-apache-tomcat-in-centos/<br />useradd nt<br />passwd nt<br />password : pSSWRD<br />yum install java-1.8.0-openjdk-devel <span style="white-space: pre;"> </span>#install JDK 8<br />java -version</p><p>cd /usr/local<br />yum install wget<br />wget https://archive.apache.org/dist/tomcat/tomcat-9/v9.0.39/bin/apache-tomcat-9.0.39.tar.gz<br />tar -xvf apache-tomcat-9.0.39.tar.gz<br />mv apache-tomcat-9.0.39 tomcat</p><p>echo "export CATALINA_HOME="/usr/local/tomcat"" >> ~/.bashrc<br />source ~/.bashrc</p><p>Now we all set to start the tomcat web server using the scripts provided by the tomcat package.</p><p>cd /usr/local/tomcat/bin<br />./startup.sh </p><p>sudo firewall-cmd --zone=public --add-service=http<br />http://192.168.1.100:8080<br />OR<br />http://example.com:8080</p><p>vi /usr/local/tomcat/conf/tomcat-users.xml <br />cd /usr/local/tomcat/bin</p><p>./shutdown.sh <br />./startup.sh</p><p><br /></p><p>If you want to run Tomcat on different port say 80 port. You will have to edit the ‘server.xml‘ file in ‘/usr/local/tomcat/conf/‘. Before changing, port, make sure to stop the Tomcat server using.</p><p># /usr/local/tomcat/bin/shutdown.sh<br />Now open the server.xml file using the Vi editor.<br /># vi /usr/local/tomcat/conf/server.xml</p><p>Now search for “Connector port” and change its value from 8080 to 1510 or any other port you want as it follows.</p><p><b>Restart Tomcat9 :</b></p><p>cd /usr/local/tomcat/bin<br />./shutdown.sh <br />./startup.sh</p><p><b>Secure Tomcat :</b></p><p>https://geekflare.com/apache-tomcat-hardening-and-security-guide/<br />https://geekflare.com/apache-tomcat-hardening-and-security-guide/<br />https://gridscale.io/en/community/tutorials/securing-apache-tomcat-with-ssl/<br />https://www.mulesoft.com/tcat/tomcat-security<br />https://www.upguard.com/blog/15-ways-to-secure-apache-tomcat-8</p><p>Let’s hide the product and version details from the Server header.<br /><br />vi /usr/local/tomcat/conf/server.xml<br />Go to $tomcat/conf folder<br />Modify server.xml by using vi<br />Add following to Connector port</p><p>Server =” “<br /><Connector port="8080" protocol="HTTP/1.1"<br />connectionTimeout="20000"<br />Server =" "<br />redirectPort="8443" /></p><p>vi /etc/httpd/conf/httpd.conf</p><p><b>Server Time Zone :<br /></b>sudo timedatectl set-timezone Asia/Dhaka</p><p><br /></p><p><b>Swap Space :</b></p><p>swapon -s<br />free -m<br />df -h<br />sudo fallocate -l 2G /swapfile<br />ls -lh /swapfile<br />sudo mkswap /swapfile<br />sudo dd if=/dev/zero of=/swapfile count=2048 bs=1MiB<br />sudo chmod 600 /swapfile<br />sudo mkswap /swapfile<br />sudo swapon /swapfile</p><p>vi /etc/fstab<br />/swapfile swap swap sw 0 0</p><p><u>run this command:</u></p><p>sudo sysctl vm.swappiness=10<br />vi /etc/sysctl.conf</p><p><u>Add this line :</u><br />vm.swappiness = 10<br />vm.vfs_cache_pressure = 50<br /><br /><u>To verify swap's size<br /></u><br /></p><p>swapon --summary<br />free -h</p><p><b>Upgrade the system :</b></p><p>yum upgrade -y<br />yum install java-1.8.0-openjdk.x86_64 java-1.8.0-openjdk-devel.x86_64 mc net-tools.x86_64 htop iotop iftop unzip wget epel-release -y<br />yum install rlwrap -y</p><p><b>Minimal CentOS installation:</b></p><p>There's an utility called chrony for this purpose in the minimal CentOS installation:</p><p>systemctl start chronyd<br />systemctl enable chronyd</p><p><b>SElinux disable :</b></p><p>vi /etc/sysconfig/selinux</p><p>And change the value SELINUX=enforcing to SELINUX=disabled, then save the config file. After doing this, execute this to disable selinux in the runtime:</p><p>setenforce 0</p><p><b>Install Oracle DB :</b></p><p>cd /root<br />yum install oracle-rdbms-server-11gR2-preinstall-1.0-3.el7.x86_64.rpm --skip-broken</p><p># curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm</p><p># yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm</p><p><br /></p><p>uninstall oracle database xe 11g :</p><p>---- yum remove oracle-database-xe-18c<br />---install oracle database xe 18c :</p><p>cd Disk1/<br />yum localinstall oracle-xe-11.2.0-1.0.x86_64.rpm</p><p><br /></p><p>Now, when the packages are installed and the user is set up, you need to run the initial database configuration script:</p><p><b>Listener :<br /></b><b>Configurations :</b></p><p>/etc/init.d/oracle-xe configure</p><p>---------------- https://davidghedini.com/pg/entry/install_oracle_11g_xe_on_centos/</p><p>. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh</p><p>sqlplus /nolog<br />CONN SYS/SYS@XE AS SYSDBA<br />--To allow remote access to Oracle 11g XE GUI (as well as Application Express GUI) issue the following from SQL*Plus</p><p>EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);</p><p>-- ADD PORT 8080<br />firewall-cmd --zone=public --add-port=8080/tcp<br />You should now add an additional member for each group under /u01/app/oracle/oradata/XE<br />SQL ALTER DATABASE ADD LOGFILE MEMBER '/u01/app/oracle/oradata/XE/log1b.LOG' TO GROUP 1;</p><p>SQL ALTER DATABASE ADD LOGFILE MEMBER '/u01/app/oracle/oradata/XE/log2b.LOG' TO GROUP 2;</p><p>ALTER DATABASE ADD LOGFILE MEMBER '/u01/app/oracle/oradata/XE/log1b.LOG' TO GROUP 1;</p><p>ALTER DATABASE ADD LOGFILE MEMBER '/u01/app/oracle/oradata/XE/log2b.LOG' TO GROUP 2;</p><p>alter system set sessions=250 scope=spfile;<br />shutdown immediate<br />startup</p><p>alter system set processes=200 scope=spfile;<br />startup</p><p>---------------- https://davidghedini.com/pg/entry/install_oracle_11g_xe_on_centos/</p><p>Note that since 12c Oracle Database has multitenant architecture, which means there could be several pluggable databases and one multitenant container database. By default, the XEPDB1 pluggable database is created during the installation of XE.</p><p>To make it easier to connect to the pluggable database, I recommend editing of tnsnames.ora file and add there a new connection descriptor that we are going to use:</p><p>---vi /u01/app/oracle/product/11.2.0/xe/network/admin/sqlnet.ora</p><p>--- SQLNET.ALLOWED_LOGON_VERSION=8</p><p>vi /u01/app/oracle/product/11.2.0/xe/network/admin/tnsnames.ora</p><p>Add this record there below the standard XE record:</p><p><br /></p><p>srvr2 =<br /> (DESCRIPTION =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1539))<br /> (CONNECT_DATA =<br /> (SERVER = DEDICATED)<br /> (SERVICE_NAME = XE)<br /> )<br /> )</p><p>--- give access to firewall of port 1539<br />firewall-cmd --zone=public --add-port=1539/tcp<br />copy tnsnames to your windows oracle /network/admin folder.<br />Check connection from anywhere. e.g. Your Laptop or PC.</p><p><b>CONNECT WITHOUT GIVING ANY DATABASE NAME:</b></p><p>sqlplus /nolog<br />conn SYS/PSSWRD123 AS SYSDBA<br />SHUTDOWN IMMEDIATE<br />create pfile from spfile;<br />STARTUP</p><p><b>Install Apex 20.1 :</b></p><p>>> So let's get it started. Change your directory back to /root, unzip the APEX archive and make the user oracle the owner of the directory. </p><p>Considering we are installing the 18.2 version of APEX, it would look like this:</p><p><br /></p><p>cd /root<br />cd /opt<br />mkdir oracle<br />cd /opt/oracle<br />--rm -rf oracle<br />mkdir -p /opt/oracle/apex</p><p>cd /root<br />unzip apex_20.1.zip -d /opt/oracle<br />chown -R oracle:oinstall /opt/oracle/apex</p><p><br /></p><p>>> Note that we will be installing the full development environment of APEX. </p><p>This could be converted to a runtime only environment if needed. Refer to the official documentation for this. The full development environment should be used only when the Application Builder is needed. On a production environment it is strongly recommended to choose the runtime only setup.<br /><br />>> From the APEX new home directory connect to our pluggable database as sysdba and run the installation scripts </p><p>(we will be using SYSAUX schema for APEX metadata):</p><p>cd /opt/oracle/apex<br />sqlplus /nolog<br />conn sys/SYS@XE AS SYSDBA<br />--- @apxremov.sql<br />-- connect to the database</p><p>sqlplus /nolog</p><p>conn sys/SYS@XE AS SYSDBA<br /><br />CREATE TABLESPACE APEX DATAFILE '/u01/app/oracle/oradata/apex01.dbf' SIZE 5000M AUTOEXTEND ON NEXT 1M;<br /><br />CREATE TABLESPACE apexindex DATAFILE '/u01/app/oracle/oradata/apexindex01.dbf' SIZE 5000M AUTOEXTEND ON NEXT 1M;<br /><br />---CREATE TABLESPACE bhorbazar DATAFILE '/opt/oracle/oradata/XE/bhorbazar01.dbf' SIZE 5000M AUTOEXTEND ON NEXT 1M;<br /><br />ALTER USER ANONYMOUS ACCOUNT UNLOCK;<br /><br />--- ALTER SESSION SET CONTAINER=XE;</p><p><br />-- run the script to install a full development environment:<br /><br />SQL> <br /><br />sqlplus /nolog<br />conn sys/SYS@XE AS SYSDBA<br />@apexins.sql APEX APEX TEMP /i/<br /><br />----@apxldimg.sql E:\apex_20.1<br />----@apxldimg.sql /opt/oracle<br />---- create an instance administrator user and set their password</p><p>conn sys/SYS@XE AS SYSDBA</p><p>@apxchpwd.sql<br />@apex_rest_config.sql<br />@apex_epg_config.sql /opt/oracle<br /><br />SELECT DBMS_XDB.gethttpport FROM DUAL;</p><p>exec dbms_xdb.sethttpport(8080);<br />--- exec dbms_xdb.setftpport(0);</p><p>>> unlock and set up APEX public user, this is needed for ORDS to be able to connect to APEX engine.</p><p>alter user apex_public_user account unlock;<br />alter user apex_public_user identified by PSSWRD123;</p><p>conn sys/SYS@XE AS SYSDBA<br />alter USER ANONYMOUS ACCOUNT UNLOCK;<br />alter user ANONYMOUS identified by PSSWRD123;</p><p>alter USER XDB ACCOUNT UNLOCK;<br />alter user XDB identified by PSSWRD123;</p><p>--- Account Status must be Open :</p><p>select account_status from dba_users where username='ANONYMOUS';<br />select account_status from dba_users where username='XDB';</p><p>conn sys/SYS@XE AS SYSDBA</p><p>-- now disconnect from the database</p><p>192.168.1.100:8080/apex<br />192.168.1.100:80/apex</p><p><b>Installation of ORDS :</b></p><p>cd /root<br />cd /opt/oracle<br />rm -rf ords<br />mkdir -p /opt/oracle/ords<br />cd /root<br />yum install unzip<br /><br />unzip ords-19.2.0.199.1647.zip -d /opt/oracle/ords<br />cd /opt/oracle/ords</p><p>mkdir config<br />mv ords.war apps.war</p><p><b>How to UnInstall ORDS :</b><br />----- systemctl stop tomcat<br />----- systemctl stop httpd<br />----- java -jar apps.war uninstall</p><p>java -jar apps.war install advanced<br />------- Configuration folder path :</p><p>/opt/oracle/ords/config</p><p>When prompted for ORDS configuration directory (the first question), enter config. Then provide the connection info to your pluggable database (</p><p>******* specify XEPDB1 for the service name</p><p>Enter the name of the database server [localhost]:example<br />Enter the database listen port [1521]:1539<br />Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1<br />Enter the database service name:ORCLPDB1<br />Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:1<br />Enter the database password for ORDS_PUBLIC_USER:<br />Confirm password:<br />Requires SYS AS SYSDBA to verify Oracle REST Data Services schema.</p><p><br /></p><p>Enter the database password for SYS AS SYSDBA:<br />Confirm password:</p><p>Retrieving information.<br />Enter the default tablespace for ORDS_METADATA [SYSAUX]:SYSAUX<br />Enter the temporary tablespace for ORDS_METADATA [TEMP]:TEMP<br />Enter the default tablespace for ORDS_PUBLIC_USER [USERS]:USERS<br />Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:TEMP<br />Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.<br />If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:1<br />Enter the PL/SQL Gateway database user name [APEX_PUBLIC_USER]:APEX_PUBLIC_USER<br />Enter the database password for APEX_PUBLIC_USER:</p><p>Confirm password:<br /><br />Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]:1<br />Enter the database password for APEX_LISTENER:<br /><br />Confirm password:<br />Enter the database password for APEX_REST_PUBLIC_USER:<br />Confirm password:</p><p>Oct 30, 2019 1:05:38 PM<br />INFO: reloaded pools: []</p><p>Installing Oracle REST Data Services version 18.3.0.r2701456<br />... Log file written to /root/ords_install_core_2019-10-30_130538_00357.log<br />... Verified database prerequisites<br />... Created Oracle REST Data Services schema<br />... Created Oracle REST Data Services proxy user<br />... Granted privileges to Oracle REST Data Services<br />... Created Oracle REST Data Services database objects<br />... Log file written to /root/ords_install_datamodel_2019-10-30_130554_00366.log<br />... Log file written to /root/ords_install_apex_2019-10-30_130556_00005.log</p><p>Completed installation for Oracle REST Data Services version 18.3.0.r2701456. Elapsed time: 00:00:19.713</p><p>Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2<br />After the configuration is completed, <br />****** the values are saved in </p><p>vi /opt/oracle/ords/config/ords/defaults.xml <br /><br />file and may be modified there. <br /><br />You can find more information about possible ORDS configuration options in the official documentation. The tomcat user (created as part of Tomcat install) must have read-write access to the ORDS configuration folder:</p><p>chown -R nt:nt /opt/oracle/ords/config</p><p>Copy the ords.war into the Tomcat webapps directory for this (and we will restart the Tomcat service later):<br /><br />------------------cp -a /opt/oracle/ords/ords.war /usr/share/tomcat/webapps/apps.war<br /><br />---- cp -a /opt/oracle/ords/apps.war /usr/share/tomcat/webapps/<br />cp -a /opt/oracle/ords/apps.war /usr/local/tomcat/webapps/</p><p>Then we need to copy APEX static files (images, stylesheets, JS files and so on) to the web server directory:</p><p>cd /usr/local/tomcat/webapps</p><p>mkdir i<br />cp -a /opt/oracle/apex/images/. /usr/local/tomcat/webapps/i/<br />cd /usr/local/tomcat/conf<br />vi server.xml</p><p>--- Now search for : <br /><br /><Host name="localhost" appBase="webapps"<br /> unpackWARs="true" autoDeploy="true"><br /><br />Add this line here :<br /><br /><Context docBase="/opt/oracle/apex/images/" path="/i/" /></p><p>--------------------------------------------------------------------------------------------------------</p><p><br /></p><p> <Connector port="1510" protocol="HTTP/1.1"<br /> connectionTimeout="20000"<br /> redirectPort="8443" /><br /> <!-- A "Connector" using the shared thread pool--><br /> <!--<br /> <Connector executor="tomcatThreadPool"<br /> port="1510" protocol="HTTP/1.1"<br /> connectionTimeout="20000"<br /> redirectPort="8443" /></p><p>--------------------------------------------------------------------------------------------------------</p><p>cd /usr/local/tomcat/bin</p><p>./shutdown.sh <br />./startup.sh</p><p>sudo systemctl restart tomcat</p><p><br /></p><p>Done! We succeeded in installing of ORDS and deploying it to Tomcat by now. Only one step is left.</p><p><br /></p><p>ALTER USER APEX_LISTENER IDENTIFIED BY PSSWRD123 ACCOUNT UNLOCK;<br />ALTER USER APEX_PUBLIC_USER IDENTIFIED BY PSSWRD123 ACCOUNT UNLOCK;<br />ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY PSSWRD123 ACCOUNT UNLOCK;</p><p><br /></p><p><b>HTTPD :</b></p><p>sudo yum install httpd<br />cd /etc/httpd/conf.d/<br />touch 10-apex.conf<br />vi /etc/httpd/conf.d/10-apex.conf</p><p><br /></p><p><VirtualHost *:80><br /> ServerName example.com<br /> ServerAlias www.example.com<br /> Redirect Permanent / https://example.com<br /> ProxyRequests On<br /> <Proxy *><br /> Order deny,allow<br /> Allow from all<br /> </Proxy><br /> <Location /><br /> ProxyPreserveHost on<br /> RequestHeader unset Origin<br /> ProxyPass http://192.168.1.100:1510/<br /> ProxyPassReverse http://192.168.1.100:1510/<br /> </Location></p><p>RewriteEngine on<br />RewriteCond %{SERVER_NAME} =example.com [OR]<br />RewriteCond %{SERVER_NAME} =www.example.com [OR]<br />RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]</VirtualHost></p><p>systemctl enable httpd<br />systemctl restart httpd</p><p><VirtualHost *:80><br /> ServerName bhorbazar.com<br /> ServerAlias www.bhorbazar.com<br /> ProxyRequests On<br /> <Proxy *><br /> Order deny,allow<br /> Allow from all<br /> </Proxy><br /> <Location /><br /> ProxyPreserveHost on<br /> RequestHeader unset Origin<br /> ProxyPass http://192.168.1.100:1510/<br /> ProxyPassReverse http://192.168.1.100:1510/<br /> </Location></p><p>RewriteEngine on<br />RewriteCond %{SERVER_NAME} =example.com [OR]<br />RewriteCond %{SERVER_NAME} =www.example.com [OR]<br />RewriteRule ^ https://%{SERVER_NAME}%{REQUEST_URI} [END,NE,R=permanent]</VirtualHost></p><p><b>Tomcat Redirect :</b></p><p>cd /usr/local/tomcat/webapps/ROOT<br />cp index.jsp original-index.jsp<br />vi index.jsp<br /><br /><% response.sendRedirect(""); %><br />mkdir public<br />mkdir admin<br />cd public<br />vi index.jsp</p><p><% response.sendRedirect(""); %><br />cd ..<br />cd admin<br /><br /></p><p>vi index.jsp<br /><br /><% response.sendRedirect(""); %></p><p><b>SSL in httpd:</b></p><p>sudo yum install epel-release<br />sudo yum install certbot python2-certbot-apache mod_ssl<br />sudo certbot --apache -d example.com<br />sudo certbot --apache -d example.com -d www.example.com<br />sudo certbot --apache</p><p>sudo certbot renew --dry-run<br />sudo crontab -e</p><p><b>ssl tomcat :</b></p><p>--- https://medium.com/@mashrur123/a-step-by-step-guide-to-securing-a-tomcat-server-with-letsencrypt-ssl-certificate-65cd26290b70</p><p>------------------------<br />-------- Prerequisites :<br />------------------------</p><p>>>> Before starting work on this task, I assume you already have:</p><p><br /></p><p>01 - Running Centos system with sudo privileges shell access.<br />02 - A domain name registered and pointed to your server’s public IP address. <br />03 - For this tutorial, we use bhorbazar.com and www.bhorbazar.com, which is pointed to our server.<br />04 - Recent version of JAVA installed.<br />05 - Recent version of tomcat server installed in your .<br />06 - Have port 80 and 8443 open in your firewall.<br />07 - Have Openssl installed.</p><p>sudo yum install epel-release<br />sudo yum install certbot</p><p>---- If you have an active firewall, e.g firewalld, open https port on the firewall.<br />---- # firewall-cmd --add-service https --permanent<br />---- # firewall-cmd --reload</p><p>---- If you are not using letsencrypt then you can skip this step.<br />sudo certbot certonly --standalone -d www.example.com</p><p>If everything goes fine. A new ssl will be issued at below location. Navigate to below directory and view files.</p><p>cd /etc/letsencrypt/live/example.com</p><p>ls -l</p><p>Files List: -- ></p><p> cert.pem</p><p> chain.pem</p><p> fullchain.pem</p><p> privkey.pem</p><p><br /></p><p>>>> Convert keypair + certificate to Java Keystore : <br />At first create a PKCS12 that contains both your full chain and the private key. You need to have openssl installed for that.</p><p>openssl pkcs12 -export -out /tmp/bhorbazar.com_fullchain_and_key.p12 \<br /> -in /etc/letsencrypt/live/www.bhorbazar.com/fullchain.pem \<br /> -inkey /etc/letsencrypt/live/www.bhorbazar.com/privkey.pem \<br /> -name tomcat</p><p>Then convert that PKCS12 to a JKS, using java's keytool</p><p>keytool -importkeystore \<br /> -deststorepass pSSWRD -destkeypass pSSWRD -destkeystore /tmp/www.bhorbazar.com.jks \<br /> -srckeystore /tmp/bhorbazar.com_fullchain_and_key.p12 -srcstoretype PKCS12 -srcstorepass pSSWRD \<br /> -alias tomcat</p><p>Replace pSSWRD with your password. : pSSWRD<br />----- Configure Tomcat with the Java Keystore :</p><p>Now go to your tomcat application and open your server.xml file<br /># vi /etc/tomcat/conf/server.xml<br />Ensure the following section is commented out</p><p><!---<br /> <Connector port="8080" protocol="HTTP/1.1"<br /> connectionTimeout="20000"<br /> redirectPort="8443" /><br /> --></p><p>Configure connector to use a shared thread pool<br /><Connector executor="tomcatThreadPool"<br /> port="8080" protocol="HTTP/1.1"<br /> connectionTimeout="20000"<br /> redirectPort="8443" /><br />Next is to define SSL HTTP/1.1 Connector on port 8443<br /><Connector port="8443" protocol="org.apache.coyote.http11.Http11Protocol"<br /> maxThreads="150" SSLEnabled="true" scheme="https" secure="true"<br /> keystoreFile="/tmp/example.com.jks"<br /> keystorePass="pSSWRD"<br /> clientAuth="false" sslProtocol="TLS" /></p><p>With above configuration, http to https redirect will be done automatically for the application.<br />Now just Stop and Start Apache Tomcat and you are done.</p><p>cd /usr/local/tomcat/bin</p><p>./shutdown.sh <br />./startup.sh</p><p><b>How to enable iptables :</b></p><p>https://upcloud.com/community/tutorials/configure-iptables-centos/<br /><br />drop the lines with REJECT commands.</p><p><b>DDos Attack :</b></p><p>netstat -ntu | grep ESTAB | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -nr<br /><br />You can also bock an IP address on the server using iptables by entering the following commands:<br />https://www.hostingswift.com/how-to-block-or-unblock-an-ip-address-on-a-linux-server</p><p>iptables -A INPUT -s 88.99.252.172 -j DROP<br />iptables -A INPUT -s 67.207.67.2 -j DROP</p><p>systemctl restart httpd</p><p><b>HOW TO UNBLOCK AN IP ADDRESS ON A LINUX SERVER :</b></p><p>Use the following syntax (the -d options deletes the rule from table):</p><p># iptables -D INPUT -s 209.175.453.23 -j DROP<br /># service iptables save<br /><br />vi /etc/sysconfig/iptables</p><p><br /></p><p><b>SSL in Database (Wallet):<br /><br /></b>https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6121/index-en.html</p><p><br /></p><p><br /></p>Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-10086498203272335612019-12-27T08:03:00.003-08:002019-12-27T08:56:06.685-08:00Oracle Apex Upload and Preview Image<div dir="ltr" style="text-align: left;" trbidi="on">
Reference 1st : https://www.youtube.com/watch?v=XTao_pQALLg<br />
<br />
<b><u>code in post-text of "FILE BROWSER" :</u></b><br />
<br />
<canvas id="image-preview" width="100" height="50" style="border:1px solid #000000;"><br />
<br />
<b><u>Dynamic Action of "File Browser": CHANGE AND JAVA SCRIPT CODE :</u></b><br />
<br />
try {<br />
var canvus =$x('image-preview');<br />
var ctx = canvus.getContext('2d');<br />
var img = new Image;<br />
<br />
img.src = window.URL.createObjectURL(this.triggeringElement.files[0]);<br />
img.onload = function() {<br />
if (img.width > 200) {<br />
canvus.style.width = "100px";<br />
}<br />
canvus.width = img.width;<br />
canvus.height = img.height;<br />
ctx.drawImage(img,0,0);<br />
$("#container-img-preview").show();<br />
}<br />
} catch (e) {<br />
console.log(e);<br />
}</div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-49904384013310141472019-08-05T02:34:00.003-07:002019-08-05T02:34:43.613-07:00Oracle Apex Desktop Navigation Menu User wise Authentications<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
CREATE TABLE ALOGIN<br />
(OPRTR VARCHAR2(10),<br />
URIGHTS CHAR(1)<br />
);<br />
<br />
<br />
INSERT INTO ALOGIN VALUES ('D00001','1');<br />
INSERT INTO ALOGIN VALUES ('D00002','1');<br />
INSERT INTO ALOGIN VALUES ('D00003','1');<br />
INSERT INTO ALOGIN VALUES ('D00004','1');<br />
<br />
COMMIT;<br />
<br />
Go to : > Shared Components > Navigation Menu > Desktop Navigation Menu > Click <> menu ><br />
Go to : Conditions > Condition Type > (SQL Query Returns at least one row.) ><br />
<br />
Write the following code at :<br />
<br />
SELECT sys_context('APEX$SESSION', 'APP_USER') FROM DUAL<br />
WHERE sys_context('APEX$SESSION', 'APP_USER') IN<br />
(SELECT UPPER(OPRTR) FROM ALOGIN WHERE UPPER(OPRTR)='D00004')<br />
OR sys_context('APEX$SESSION', 'APP_USER')='LIERP';<br />
<br />
<br />
Reference 1st : https://www.youtube.com/watch?v=J83jSqDwxgk<br />
<br />
<br /></div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-8601985014725523522019-07-29T13:10:00.006-07:002021-06-01T06:46:26.245-07:00Potential Blogs of Oracle Apex - Links.<div dir="ltr" style="text-align: left;" trbidi="on">
<ol style="text-align: left;">
<li>Md. Kamal Hossain - http://www.apexexplorer.com/</li>
<li><a href="http://deneskubicek.blogspot.com/">http://deneskubicek.blogspot.com/</a></li>
<li>All the Ground Breakers of Oracle Apex : <span style="color: #0000ee;"><u>https://apexapps.oracle.com/pls/apex/f?p=119297:3::::::</u></span></li><li><span style="color: #0000ee;"><u>Noorstech.com</u></span></li><li><span style="color: #0000ee;"><u><br /></u></span></li>
</ol>
</div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-43181464185652847652019-07-16T13:44:00.003-07:002019-07-16T13:44:35.944-07:00Oracle Apex Forms Validation, Alert, Save and Update.<div dir="ltr" style="text-align: left;" trbidi="on">
<br /></div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-36209103693879315892019-07-16T12:19:00.009-07:002021-02-22T05:49:58.650-08:00Oracle Apex Jasper Report Integration<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" trbidi="on">Reference : <a href="https://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/">https://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/</a></div><div dir="ltr" trbidi="on">Download : <a href="https://github.com/daust/JasperReportsIntegration/releases">https://github.com/daust/JasperReportsIntegration/releases</a></div><div dir="ltr" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQT6fNCakqrsblqTo6Bne2xv6LoJmYRua6iMycM8UDGe-3aOB0vfyQSLFG_-2Jj5DEDn10dkxLi0YtMZnAM4EaFK-Tc7hmjFcO_sUIjNaDyQI7oosvA5jxYHbN9BFoEjneiaTc_ycVGqMg/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="217" data-original-width="1024" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQT6fNCakqrsblqTo6Bne2xv6LoJmYRua6iMycM8UDGe-3aOB0vfyQSLFG_-2Jj5DEDn10dkxLi0YtMZnAM4EaFK-Tc7hmjFcO_sUIjNaDyQI7oosvA5jxYHbN9BFoEjneiaTc_ycVGqMg/s16000/image.png" /></a></div></div><div dir="ltr" trbidi="on">unzip jri-2.7.0-jasper-6.16.0.zip to :</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">D:\apex_20.1\JasperReportsIntegration</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">D:\apex_20.1\</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">mkdir jasper</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">copy D:\apex_20.1\JasperReportsIntegration to D:\apex_20.1\jasper</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">cd jasper</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">mkdir logs</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">D:\>cd apex_20.1</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">D:\apex_20.1>cd jasper</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">D:\apex_20.1\jasper>cd bin</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Linux Permission :</u></b></div><div dir="ltr" trbidi="on"><b><u><br /></u></b></div><div dir="ltr" trbidi="on">chmod +x setConfigDir.sh </div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Windows :</u></b></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">setConfigDir.cmd D:\apex_20.1\JasperReportsIntegration\webapp\jri.war D:\apex_20.1\jasper</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Linux :</u></b></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">./setConfigDir.cmd D:\apex_20.1\JasperReportsIntegration\webapp\jri.war D:\apex_20.1\jasper </div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Windows :</u></b></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">copy D:\apex_20.1\jasper\webapp\jri.war to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\jri.war</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Linux :</u></b></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">cp D:\apex_20.1\jasper\webapp\jri.war to C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\jri.war</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Javascript :</u></b></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var report_server = "http://localhost:8080/jri/report?";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var report_name = "dept";</div><div dir="ltr" trbidi="on">var report_format = "pdf";</div><div dir="ltr" trbidi="on">var data_source = "default";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var run_report=""+report_server+"&_repName="+report_name+"&_repFormat="+report_format+"&_dataSource="+data_source+"";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">window.open(run_report);</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Javascript with parameter :</u></b></div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var report_server = "http://localhost:8080/jri/report?";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var report_name = "dept_param";</div><div dir="ltr" trbidi="on">var report_format = "pdf";</div><div dir="ltr" trbidi="on">var data_source = "default";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var ap_1 = $v("P3_DEPT");</div><div dir="ltr" trbidi="on">var rp_1 = "&P_DEPT";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var param = ""+rp_1+"="+ap_1+"";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var report=""+report_server+"&_repName="+report_name+"&_repFormat="+report_format+"&_dataSource="+data_source+"";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">var run_report = ""+report+""+param+"";</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on">window.open(run_report);</div><div dir="ltr" trbidi="on"><br /></div><div dir="ltr" trbidi="on"><b><u>Sample Jasper Report files (with and without parameter) :</u></b></div><div><br /></div><div><a href="https://drive.google.com/drive/folders/1qYsb9bJITbAaSVQUFvxngqiaM79sG4in?usp=sharing">https://drive.google.com/drive/folders/1qYsb9bJITbAaSVQUFvxngqiaM79sG4in?usp=sharing</a></div><div><br /></div><div>Potential Youtube channel to learn Jasper Report :</div><div><a href="https://www.youtube.com/watch?v=W3tpVJDEgo4&list=PLErD1cRL87W9P2GIviyQWJd_U2kVxleLy">https://www.youtube.com/watch?v=W3tpVJDEgo4&list=PLErD1cRL87W9P2GIviyQWJd_U2kVxleLy</a></div><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><b><i><u>Previous Research:</u></i></b></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on"><br /></div><div dir="ltr" style="text-align: left;" trbidi="on">
Reference : http://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/2.4.0/Index.html<br />
<br />
Installation<br />
Download the files<br />
Installation in the J2EE server<br />
Installation of database objects<br />
Installation of the test application<br />
<br />
1. Download the files<br />
You can download the files from here and unzip them.<br />
<br />
2. Installation in the J2EE server<br />
We need to install the J2EE application and configure the data sources in this step. The J2EE application has to find various configuration files<br />
<br />
(e.g. conf/application.properties, conf/log4j.properties) and also the different reports that we can run (e.g. reports/test.jasper).<br />
<br />
It is recommended practice to separate the configuration-/report files from the J2EE application itself. In the early versions of the<br />
<br />
JasperReportsIntegration all reports were placed directly in the web application itself, for example into the directory<br />
<br />
$TOMCAT_HOME/webapps/reports. In order to easily upgrade your installation in the future it is recommended to put the configuration and report files<br />
<br />
into a separate directory and not store them inside of the J2EE application.<br />
<br />
Nevertheless the J2EE application must be able to locate these files.<br />
<br />
We have two options here:<br />
<br />
Configure the server environment using an operating system environment variable<br />
<br />
Configure the setting in the web.xml file of the JasperReportsIntegration.war file<br />
<br />
The difference comes into play when you deploy the JasperReportsIntegration.war file multiple times on the same J2EE server or on different J2EE<br />
<br />
servers on the same machine. When using the operating system environment variable, all instances of the JasperReportsIntegration will use the same<br />
<br />
configuration and reports.<br />
<br />
If you want to use different configurations for your different instances on the same machine (either you deploy different version of the<br />
<br />
JasperReportsIntegration or you have your development, test and production environment running on the same machine but on different J2EE servers),<br />
<br />
you would use the direct manipulation of the web.xml file.<br />
<br />
2.1. Configure the server environment using an operating system environment variable<br />
Using the operating system environment variable OC_JASPER_CONFIG_HOME we can configure where these files reside on the filesystem. This directory is<br />
<br />
the same as the base directory of your downloaded files, i.e. it should at least contain the sub directories conf, reports, logs.<br />
<br />
2.1.1 Create the required directory structure<br />
First you need to set up the required directory structure in the target directory. Just copy the directories conf, reports and logs to the target<br />
<br />
directory, e.g. c:\app\JasperReportsIntegration:<br />
<br />
directory structure<br />
<br />
2.1.2.a) Unix / Linux: set the environment variable<br />
On a Unix / Linux system running Tomcat you could for example add this setting to the Tomcat startup script (e.g. /usr/local/tomcat/bin/startup.sh):<br />
OC_JASPER_CONFIG_HOME=/opt/JasperReportsIntegration<br />
export OC_JASPER_CONFIG_HOME<br />
<br />
2.1.2.b) Windows: set the environment variable<br />
On a Windows machine you could do the same (e.g. c:\program files\apache tomcat\bin\startup.cmd):<br />
SET OC_JASPER_CONFIG_HOME=c:\app\JasperReportsIntegration<br />
or you could modify the system environment of the machine and create the variable OC_JASPER_CONFIG_HOME=c:\app\JasperReportsIntegration<br />
<br />
2.2 Configure the setting in the web.xml file of the JasperReportsIntegration.war file<br />
By using this approach you can tell the JasperReportsIntegration.war file directly where it can find its configuration files. The following<br />
<br />
procedure will manipulate the J2EE context-parameter oc.jasper.config.home in the file web.xml of the JasperReportsIntegration.war directly for you.<br />
<br />
2.2.1 Create the required directory structure<br />
First you need to set up the required directory structure in the target directory. Just copy the directories conf, reports and logs to the target<br />
<br />
directory, e.g. c:\app\JasperReportsIntegration:<br />
<br />
directory structure<br />
<br />
2.2.2.a) Unix / Linux: Set the configuration directory directly in the JasperReportsIntegration.war file<br />
In the following example we will use /opt/JasperReportsIntegration as the target directory.<br />
cd bin<br />
./setConfigDir.sh ../webapp/JasperReportsIntegration.war /opt/JasperReportsIntegration<br />
<br />
2.2.2.b) Windows: Set the configuration directory directly in the JasperReportsIntegration.war file<br />
In the following example we will use c:\app\JasperReportsIntegration as the target directory.<br />
cd bin<br />
setConfigDir.cmd ..\webapp\JasperReportsIntegration.war c:\app\JasperReportsIntegration<br />
<br />
2.2.3.a) Unix / Linux: Get the configuration directory from the JasperReportsIntegration.war file<br />
In order to determine the configuration directory from a specific JasperReportsIntegration.war file, you can run the following command to see where<br />
<br />
it points to. This is just for verification purposes.<br />
cd bin<br />
./getConfigDir.sh ../webapp/JasperReportsIntegration.war<br />
<br />
2.2.3.b) Windows: Get the configuration directory from the JasperReportsIntegration.war file<br />
In order to determine the configuration directory from a specific JasperReportsIntegration.war file, you can run the following command to see where<br />
<br />
it points to. This is just for verification purposes.<br />
cd bin<br />
getConfigDir.cmd ..\webapp\JasperReportsIntegration.war<br />
<br />
2.3 Configure your database access<br />
Edit the file conf/application.properties in your target directory and configure the data source default to connect to your Oracle schema (change<br />
<br />
the parts in bold to point to the Oracle schema you want to connect to):<br />
<br />
#====================================================================<br />
# JDBC datasource configuration<br />
# http://www.orafaq.com/wiki/JDBC#Thin_driver<br />
# type=jdbc|jndi<br />
#====================================================================<br />
<br />
[datasource:default]<br />
type=jdbc<br />
name=default<br />
url=jdbc:oracle:thin:@192.168.2.114:1521:XE<br />
username=HR<br />
password=hr_password<br />
<br />
Alternatively you could use the native JNDI data source of your application server. See the documentation there on how to configure it. In this<br />
<br />
configuration file you would have to register just the JNDI datasource you want to use:<br />
<br />
#====================================================================<br />
# Native JNDI datasource, to be configured in the application server<br />
# name: jndi_test<br />
#====================================================================<br />
[datasource:jndi_test]<br />
type=jndi<br />
name=jndi_test<br />
<br />
2.4 Encrypting all passwords in the application.properties file<br />
You can optionally encrypt the passwords in the application.properties file. Just follow the following steps, the file will automatically be updated<br />
<br />
with the encrypted passwords for all of the datasources.<br />
<br />
2.4.1.a) Unix / Linux<br />
In order to determine the configuration directory from a specific JasperReportsIntegration.war file, you can run the following command to see where<br />
<br />
it points to. This is just for verification purposes.<br />
cd bin<br />
./encryptPasswords.sh <path to application.properties file><br />
e.g.: ./encryptPasswords.sh /opt/JasperReportsIntegration/conf/application.properties<br />
<br />
2.4.1.b) Windows<br />
In order to determine the configuration directory from a specific JasperReportsIntegration.war file, you can run the following command to see where<br />
<br />
it points to. This is just for verification purposes.<br />
cd bin<br />
encryptPasswords.cmd <path to application.properties file><br />
e.g.: encryptPasswords.cmd c:\app\JasperReportsIntegration\conf\application.properties<br />
<br />
2.5 Deploy the J2EE application<br />
Take the application server of your choice and deploy the file webapp/JasperReportsIntegration.war to it. For an Apache Tomcat this typically means<br />
<br />
to copy the file JasperReportsIntegration.war into the directory webapps of your Tomcat application. If the Tomcat doesn't deploy it automatically,<br />
<br />
you would have to restart the Tomcat.<br />
<br />
After that you can reach the JasperReportsIntegration homepage with the URL http://<server>:<port>/JasperReportsIntegration.<br />
<br />
Here you will find the included documentation, information about the location of the configuration files, you can test the database connections and<br />
<br />
run the test reports:<br />
<br />
<br />
2.6 Securing the homepage of the J2EE application<br />
Since the homepage tells you a lot about the system you will typically protect that information in a production environment.<br />
Therefore you can edit the file conf/application.properties and set the config parameter infoPageIsEnabled=false.<br />
<br />
#====================================================================<br />
# Application properties (global)<br />
#====================================================================<br />
[application]<br />
configFileVersion=2.3.0<br />
jndiPrefix=java:comp/env/jdbc/<br />
# infoPageIsEnabled will show the initial start page of the j2ee application<br />
# including testing and the environment settings<br />
infoPageIsEnabled=false<br />
<br />
After you restart the J2EE application the homepage will be protected:<br />
<br />
Protected Homepage<br />
3. Installation of database objects<br />
The database objects required for the integration will be installed into each application schema that you want to use with the integration.<br />
The installation instructions will refer to the application schema (in which you install the software) as [application schema]. The password for the<br />
<br />
application schema will be referred to as [application schema password].<br />
<br />
Thus when I use an instruction like sqlplus [application schema]/[application schema password]@[database] please replace that with the actual values<br />
<br />
of your local installation. For example, if you want to install the integration kit into the schema HR with the password hr1 into your local XE<br />
<br />
instance (having a TNS entry named xe) then this instruction translates to:<br />
<br />
sqlplus hr/hr1@xe<br />
<br />
3.1 Database installation (SYS)<br />
First of all we need to grant the required privileges to the Oracle user who will own the packages for the integration.<br />
<br />
Extract the downloaded zip file.<br />
Open a command shell:<br />
e.g. on Windows: Start > Execute : cmd<br />
Go to the subdirectory sql (of where you extracted the file):<br />
cd sql<br />
Connect as SYS to the local instance (using sqlplus)<br />
sqlplus "sys/[sys password]@[database] as sysdba"<br />
Run the installation script (and pass the name of the target application schema as a parameter)<br />
@sys_install.sql [application schema]<br />
[optional] If you are installing on an Oracle Release 11.0 and higher, you have to grant the required network privileges to the application schema.<br />
The script sys_install_acl.sql allows access to the local machine on port 80 to port 10000. Please adapt the script to suit your needs, especially<br />
<br />
if the J2EE server is running on a different machine. It needs to be run for each application schema using the integration.<br />
@sys_install_acl.sql [application schema]<br />
<br />
3.2 Database installation (Application Schema)<br />
Open a command shell:<br />
e.g. on Windows: Start > Execute : cmd<br />
Go to the subdirectory sql (of where you extracted the file):<br />
cd sql<br />
Connect as the application schema to the local instance (using sqlplus)<br />
sqlplus [application schema]/[application schema password]@[database]<br />
Run the installation script<br />
@user_install.sql<br />
<br />
4. Installation of the test application<br />
The test application will allow for basic testing of the integration with all relevant parts. Install the application file apex<br />
<br />
\f121_JasperReportsIntegration-Test_x.x.x.x.sql into your workspace.<br />
It will perform checks on the installation and allow you to run the test reports.<br />
<br />
<br />
<br />
In some circumstances you can encounter errors, mostly due to enhanced security constraints:<br />
Expected errors during validation<br />
<br />
Check 4 can fail when there is no valid index page for the J2EE container<br />
<br />
Check 5 and Check 6 can fail, when the setting infoPageIsEnabled=false in the application.properties file is set<br />
<br />
Check 7 should be always be working correctly.<br />
<br />
<h3 style="text-align: left;">
<b>Javascript :</b></h3>
var r_server = "server address with report folder?_repName=report_name&_repFormat=pdf&_dataSource=data_source_name";<br />
var r_branch_code = $v("P126_BRANCH");<br />
var r_emp_id = $v("P126_FO");<br />
var r_year = $v("P126_YEAR");<br />
var rp_1 = "&P_BRANCH";<br />
var rp_2 = "&P_EMP";<br />
var rp_3 = "&P_YEAR";<br />
<br />
var r_link = ""+r_server+""+rp_1+"="+r_branch_code+""+rp_2+"="+r_emp_id+""+rp_3+"="+r_year+"";<br />
window.open(r_link);<br />
<br />
<h2 style="text-align: left;">
<b><u>Javascript 2 :</u></b></h2>
<br />
var r_server = "http://localhost:8181/JasperReportsIntegration/report?_repName=CountryList&_repFormat=pdf&_dataSource=default";<br />
var r_id1 = $v("P15_ID1");<br />
var r_id2 = $v("P15_ID2");<br />
var rp_1 = "&P1";<br />
var rp_2 = "&P2";<br />
<br />
var r_link = ""+r_server+""+rp_1+"="+r_id1+""+rp_2+"="+r_id2+"";<br />
window.open(r_link);<br />
<br />
<br />
<div>
<br /></div>
<br /></div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-9457312683137891742019-07-06T11:29:00.001-07:002019-07-06T11:29:34.895-07:00How to install ORDS and tomcat for Oracle Apex<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
Apex + ORDS + Tomcat<br />
<br />
1 - Download ORDS and apache tomcat (Search in google.)<br />
2 - Copy ORDS to c:\ and extract. and rename to ords.<br />
3 - Rename ords.war to noorbd.war<br />
4 - Create a folder config in c:\ords<br />
<br />
java -jar noorbd.war<br />
<br />
Enter the location to store configuration date: c:\ords\config<br />
<br />
Enter the name of the database server [Localhost]: Enter<br />
Enter the database listen port [1521]:<br />
Enter 1 to specify the database service name,or 2 to specify the database SID : 2<br />
Enter the database SID [xe]:<br />
Enter the database password for ORDS_PUBLIC_USER:<br />
Confirm Password :<br />
<br />
Retrieving information.<br />
<br />
Enter 1 if you want to user PL/SQL Gateway or 2 to skip this step.<br />
If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]: 1<br />
Enter the database password for APEX_PUBLIC_USER:<br />
Confirm Password :<br />
<br />
Enter 1 to specify passwords for Application Express RESTful Services database users (APEX LISTENER...): 1<br />
Enter the database password for APEX_LISTENER:<br />
Confirm password:<br />
Enter the database password for APEX_REST_PUBLIC_USER:<br />
Confirm password:<br />
<br />
Enter 1 if you wish to start in standalone mode or 2 to exit [1]: 2<br />
<br />
>>>>Now Install Apache tomcat.<br />
<br />
copy the noorbd.war where ROOT folder exist in tomcat folder.<br />
<br />
Create a directory 'i' here.<br />
<br />
Copy image to i<br />
<br />
edit server in notepad : ../Tomcat8.5/conf<br />
<br />
Search appBase ="webapps"<br />
<br />
Write<br />
<br />
<Context docBase="C:\apex\images" path="/i" /><br />
<br />
Run Apache Server.<br />
<br />
Change the port number at : C:\Program Files\Apache Software Foundation\Tomcat 8.5\conf\server.xml to<br />
<br />
<Connector port="8181" protocol="HTTP/1.1"<br />
connectionTimeout="20000"<br />
redirectPort="8443" /><br />
<br />
<br />
---- Run in command prompt : CMD<br />
<br />
java -jar noorbd.war validate orcl<br />
<br />
---- SQLplus /nolog<br />
---- conn / as sysdba<br />
<br />
EXEC DBMS_XDB.SETHTTPPORT(8181);<br />
<br />
<br /></div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-23940821265415891082019-07-06T11:27:00.001-07:002019-07-06T11:27:08.275-07:00How to install Oracle Apex 18.1<div dir="ltr" style="text-align: left;" trbidi="on">
01 - Create a new tablespace to act as the default tablespace for APEX.<br />
<br />
CREATE TABLESPACE apex DATAFILE 'F:\app\Administrator\oradata\TEMPDB\apex_01.dbf' SIZE 1000M AUTOEXTEND ON NEXT 1M;<br />
<br />
02 - Installation:<br />
------------------<br />
<br />
Change directory to the directory holding the unzipped APEX software.<br />
<br />
D:\apex_18.1_en\apex<br />
<br />
F:\app\Administrator\product\11.2.0\dbhome_1\BIN\sqlplus.exe /nolog<br />
<br />
CONN sys/sys@tempdb AS SYSDBA<br />
<br />
@apexins.sql APEX APEX TEMP /i/<br />
<br />
03 - Once complete, change the admin password by running the "apxchpwd.sql" scripts as the SYS user.<br />
----------------------------------------------------------------------------------------------------<br />
<br />
CONN sys/sys@tempdb AS SYSDBA<br />
<br />
@apxchpwd.sql<br />
<br />
04 - Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.<br />
------------------------------------------------------------------------------------------------------------<br />
<br />
CONN sys/sys@tempdb AS SYSDBA<br />
<br />
@apex_rest_config.sql<br />
<br />
05 - Embedded PL/SQL Gateway (EPG) Configuration :<br />
--------------------------------------------------<br />
<br />
CONN sys/sys@tempdb AS SYSDBA<br />
<br />
@apex_epg_config.sql D:\apex_18.1_en<br />
<br />
06 - Unlock the ANONYMOUS account :<br />
-----------------------------------<br />
<br />
CONN sys/sys@tempdb AS SYSDBA<br />
<br />
ALTER USER ANONYMOUS IDENTIFIED BY a;<br />
<br />
alter user anonymous account unlock;<br />
<br />
<br />
DECLARE<br />
l_passwd VARCHAR2(40);<br />
BEGIN<br />
l_passwd := DBMS_RANDOM.string('a',10) || DBMS_RANDOM.string('x',10) || '1#';<br />
-- Remove CONTAINER=ALL for non-CDB environments.<br />
EXECUTE IMMEDIATE 'ALTER USER anonymous IDENTIFIED BY ' || l_passwd || ' ACCOUNT UNLOCK CONTAINER=ALL';<br />
END;<br />
/<br />
<br />
07 - Check the port setting for XML DB Protocol Server:<br />
-------------------------------------------------------<br />
<br />
CONN sys/sys@tempdb AS SYSDBA<br />
<br />
SELECT DBMS_XDB.gethttpport FROM DUAL;<br />
<br />
GETHTTPPORT<br />
-----------<br />
0<br />
<br />
CONN sys/sys@tempdb AS SYSDBA<br />
<br />
EXEC DBMS_XDB.sethttpport(8080);<br />
<br />
08- Find the URL here :<br />
-----------------------<br />
<br />
http://localhost:8080/apex<br />
<br />
workspace : TEST<br />
UserName : TEST<br />
Password : TEST<br />
<br />
Schema : Test/t@tempdb<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-49924487782938490482019-07-06T11:00:00.001-07:002019-07-06T11:00:16.651-07:00How to install Jasper iReport 5.1<div dir="ltr" style="text-align: left;" trbidi="on">
1 - Install Jre7 https://drive.google.com/file/d/0B3LTUDyiHdTNNXVnek1uQ1VtMk0/view<br />
2 - Install Jasper Ireport 5.1<br />
3 - Go to : C:\Program Files (x86)\Jaspersoft\iReport-5.1.0\etc\ireport.conf<br />
#jdkhome="C:\Program Files (x86)\Java\jre7"<br />
4 - Run Ireport.<br />
5 - Go to : Tools>Options>ClassPath> Add jar > show ojdbc14.jar Click Reloadable. OK.<br />
6 - Click Report DataSource.<br />
7 - Click New.<br />
8 - JDBC connections.<br />
9 - Next > Show Oracle Driver.<br />
10 - Name the connection.<br />
11 - Change the JDBC URL: jdbc:oracle:thin:@localhost:1521:tempdb<br />
12 - Test.<br />
13 - Save.<br />
<div>
<br /></div>
</div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0tag:blogger.com,1999:blog-1601352731238367731.post-7273917459747158102019-07-04T12:31:00.000-07:002019-12-27T08:55:56.200-08:00Picture in Report<div dir="ltr" style="text-align: left;" trbidi="on">
select "EMPNO",<br />
"ENAME",<br />
"JOB",<br />
"MGR",<br />
"HIREDATE",<br />
"SAL",<br />
"COMM",<br />
"DEPTNO",<br />
dbms_lob.getlength("PHOTO") "PHOTO"<br />
"GENDER",<br />
"ROSTER_TYP"<br />
from "#OWNER#"."EMP"<br />
<br />
<b><u>css in PAGE:</u></b><br />
<br />
img{<br />
width:50px;<br />
height: 100 px;<br />
}</div>
Muhammad Abdullah Al Noorhttp://www.blogger.com/profile/09924639368955439382noreply@blogger.com0