Query to get the front end URL from back-end
SELECT home_url FROM icx_parameters; http://hostname.domainname.com:8000/OA_HTML/AppsLogin
Archive for the ‘Oracle’ Category
Query To Get The Front End URL From Backend
February 6th, 2022, posted in Oracle EBS Application, Oracle QueriesSWAP size Adding While installing a Oracle Database 19c on Oracle Linux
January 30th, 2022, posted in Oracle, Solaris
SWAP Size Adding size while installing a Oracle Database 19c on Oracle Linux
Below is the error message I received while I was trying to install Oracle Database 19c on Oracle Linux 7.
PRVF-7573 : Sufficient swap size is not available on node
As per my error on the installer screen I needed 16GB of SWAP space where as my system has just 4GB. So I need to add a swap file for the installation to continue.
Below steps will outline the steps for the same.
dd if=/dev/sdb of=/tmp/swap01 bs=1K count=16M
chmod 600 /tmp/swap01
mkswap /tmp/swap01
swapon /tmp/swap01
Make sure the bs (*) count is equal to your required SWAP space. Also, the /dev/sdb has enough storage as needed
Current Login Users List In Oracle EBS R12 11i
January 23rd, 2022, posted in Oracle EBS Application, Oracle QueriesRun the following query to find out who are the Oracle Apps Users currently Logged into the application.
SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description FROM icx_sessions icx, fnd_user fu WHERE disabled_flag != 'Y' AND icx.pseudo_flag = 'N' AND (last_connect + DECODE (fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'), NULL, limit_time, 0 , limit_time, fnd_profile.VALUE ('ICX_SESSION_TIMEOUT')/60) / 24) > SYSDATE AND icx.counter < limit_connects AND icx.user_id = fu.user_id;
PLS-00201: identifier UTL MAIL.SEND must be declared
January 9th, 2022, posted in Oracle QueriesPLS-00201: identifier ‘UTL_MAIL.SEND’ must be declared
During execution of the package use UTL Mail package for send the mail may give the error PLS-00201. It may be caused due to in configured of UTL Mail package in the database. You may configure the UTL Mail package with following script:
Error:
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_MAIL.SEND' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Solution:
1. Set the Oracle Home Environment Variable
Set ORACLE_HOME=D:\Oracle\12.1.0\dbhome_1
set PATH=%ORACLE_HOME%\bin;%PATH%
2. Connect with sqlplus / as sysdba
@?\rdbms\admin\utlmail.sql;
@?\rdbms\admin\prvtmail.plb;
3. Set up the Parameter SMTP server.
ALTER SYSTEM SET smtp_out_server='address:25' SCOPE=BOTH;
4. Grant the user with required permission.
GRANT execute ON utl_mail TO NEWUSER;
Oracle Database 20c New Features
January 2nd, 2022, posted in OracleOracle Database 20c New Features
Oracle Database 20c is about to release this year but Oracle has already announce some wonderful features of 20c release in OOW and 20c Webcast.
Most Important things of this year is,
1) Oracle Cloud – Free Tier :
Always Free Services- 1 ADW, 1 ATP , 2 Compute services always free
2) De-support of non-cdb architecture, facilitating 3 PDB’s with no cost :
Few new enhancements which catches my eyes on Oracle Database 20c Release.
1) In-Memory Enhancements :
– Spatial & Text
– Vector Joins
– Hybrid Scans
– Auto populate and evict in-memory
Read more here about In-Memory Enhancements
https://blogs.oracle.com/in-memory/oracle-database-20c-aim-enhancements
2) New Binary JSON data type :
Read more here,
https://blogs.oracle.com/sql/how-to-store-query-and-create-json-documents-in-oracle-database
3) Auto Machin Learning in OML4py :
Automatically build and compare Machine Learning models
Read more here,
https://blogs.oracle.com/machinelearning/automated-machine-learning-for-data-scientists
4) Native Blockchain Table :
New blockchain type table. This allows only Inserts and select.
Read more here,
https://blogs.oracle.com/blockchain/blockchain-tables-in-oracle-database:-technology-convergence