https://tedstruik-oracle.nl/ords/f?p=25384:1133::::::&nb...
Thursday, September 2, 2021
Thursday, July 22, 2021
Oracle Apex Image Prefix.
CD APEX21.1CD APEXCD UTILITIES----------- F:\apex_21.1\apex\utilities :SQLPLUS /NOLOGCONN SYS/SYS@ORCLPDB2 AS SYSDBA@reset_image_prefix.sqlEnter the Application Express image prefix [/i/] /images211/...Changing Application Express image prefixNEW_IMAGE_P/images2...
Wednesday, June 2, 2021
The connection pool named: |apex|rt| is not correctly configured, due to the following error(s): ORA-28000: The account is locked.
The connection pool named: |apex|rt| is not correctly configured, due to the following error(s): ORA-28000: The account is locked.Check if there is any Locked User :CONN SYS/SYS@ORCLPDB AS SYSDBAselect username, account_status, profile from dba_users ...
Sunday, May 30, 2021
How to Integrate Oracle 10g Reports with Oracle Apex
Script 1:var r_server = "http://192.168.100.100/reports/rwservlet?server=rep_appsrv1_asbiforms10&destype=cache&desformat";var r_branch_code = $v("P100_BRANCH");var r_emp_id = $v("P100_emp_NO");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+"";window.open(r_link);Script...
Friday, April 30, 2021
Oracle Apex Software Development Companies
Oracle Apex Software Development Companies (1st page on google.) https://adjacentsolutions.com/http://ogesinfotech.com/index.phphttps://www.insum.ca/https://pretius.com/main/https://www.octalsoft.com/https://www.foex.athttps://diceus.com-----------------------------------------------------------------------------------------------------------------------...
Monday, April 19, 2021
Oracle Apex Date Picker to Text Field Dynamic Action PLsql
DECLARE V VARCHAR2(10):=''; vAttdt date;BEGIN vAttdt := :p44_attdt; :P44_ATTDT2:=TO_CHAR(VaTTDT,'RRRRMMDD');E...
Jasper Soft Character to Date conversion in Expression Editor
click [..] to go to Expression Editor.new SimpleDateFormat("yyyyMMdd").parse($P{P_ATTDT})$P{P_ATTDT} ------------ > This is the Parameter or field.Note : Month should be in MM format not in mm Format. e.g. new SimpleDateFormat("yyyyMMdd").parse($P{P_ATTDT})enjoy...
Friday, April 9, 2021
How to enable/disable ssh login through putty
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.Step 1 : Enable or disable sshd in vultr.com console after login---- systemctl enable sshdsystemctl disable sshdStep 2 : Restart the server.init 6Step 3...
Tuesday, April 6, 2021
How to integrate Jasper Report in Linux
cd /opt/oracle/apexcopy jri-2.7.0-jasper-6.16.0.zip to /opt/oracle/apex ---- By SSH Secure file transferDownload : https://github.com/daust/JasperReportsIntegration/releasesunzip jri-2.7.0-jasper-6.16.0.zipmv jri-2.7.0-jasper-6.16.0 jricd /opt/oracle/apex/jrimkdir confmkdir logsmkdir reportscd /opt/oracle/apex/jri/binchmod +x setConfigDir.shcd...
Saturday, April 3, 2021
How to Install SSL Certbot of LetsEncrypt
How to Install SSL Certbot of LetsEncrypt :vi /usr/local/tomcat/conf/server.xml-- Change tomcat port to : 1610cd /usr/local/tomcat/bin./shutdown.sh ./startup.shfirewall-cmd --zone=public --add-port=1610/tcpfirewall-cmd --zone=public --add-port=443/tcpsudo systemctl start httpdcd /etc/httpd/conf.dvi 10-apex.conf<VirtualHost *:80> ...
Thursday, January 21, 2021
How to install Oracle Database 19c In Centos 7 Linux
Install Oracle Database 19c :-----------------------------pSSWRDa---------------- /opt/oracle/product/19c/dbhome_1Log in as root.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.rpmyum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpmcd...
How to Install Oracle 20.1 in Centos 7 and Oracle Database 11g Xe
Firewall Configuration :firewall-cmd --zone=public --add-port=80/tcpfirewall-cmd --zone=public --add-port=8080/tcpfirewall-cmd --zone=public --add-port=1539/tcp. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.shsqlplus /nologTOMCAT :https://www.tecmint.com/install-apache-tomcat-in-centos/useradd ntpasswd ntpassword : pSSWRDyum install java-1.8.0-openjdk-devel ...
