Query to get the front end URL from back-end
SELECT home_url FROM icx_parameters; http://hostname.domainname.com:8000/OA_HTML/AppsLogin
Posts Tagged ‘Oracle Database’
Query To Get The Front End URL From Backend
February 6th, 2022, posted in Oracle EBS Application, Oracle QueriesOracle 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
Oracle Database New Features (12c to 19c)
January 1st, 2022, posted in Oracle EBS ApplicationOracle Database New Features (12c to 19c)
From Oracle database 12c on-wards, whole architecture was changed. And it comes with many new features. Oracle also changed the policy of releasing database patches and version. Now we are seeing new version every year from 2018 on-wards, i.e. 18c in the year of 2018, 19, in the year of 2019 and now very soon 20c is coming this year.
Here I am highlighting Oracle database new features which was introduce in different Oracle database versions. My focus is to highlight most important features from version 12c onwards up to 19c.
This will help you to understand which feature we can use in which version.
|
Category
|
DB
Versions |
|||
|
12.1
|
12.2
|
18c
|
19c
|
|
|
High
Availability |
Comprehensive HA and disaster
recovery functionality |
Sharding
|
Sharded RAC
|
Data Guard DML Redirect
|
|
Oracle Golden Gate for heterogeneous replication
|
Autonomous Health Framework
|
User-defined Sharding Methods
|
Sharding: Supports multiple PDB shards in a CDB
Unique sequence number generation per shard |
|
|
Zero Downtime Grid Infrastructure
Patching |
||||
|
PDB Recovery Catalog
|
||||
|
Improvements to Application
Continuity |
||||
|
Category
|
DB Versions
|
|||
|
12.1
|
12.2
|
18c
|
19c
|
|
|
Performance and Salability
|
In-Memory Column Store
|
In Memory JSON Queries
|
Memory Optimized Row
Store |
Fast ingest support for
IoT type workloads |
|
Engineered Systems
|
In Memory Active Standby
|
New Approximate Functions
|
Quarantine for SQL Statements
|
|
|
Optimizer Adaptive
Feature |
Optimizer Adaptive
Feature |
Stats Only Queries
|
||
|
Approximate Query Processing
|
New Approximate Functions
|
Improvements for COUNT DISTINCT and GROUP BY queries
|
||
|
Optimizer Statistics
Advisor |
Automatic Indexing
|
|||
|
Realtime Statistics
|
||||
|
Automatic Resolution of
SQL Plan Regressions |
||||
|
Category
|
DB Versions
|
|||
|
12.1
|
12.2
|
18c
|
19c
|
|
|
Multitenant
|
Container managed
database virtualization |
Online cloning &
relocation |
Transportable backups
|
DBCA Silent mode
operations for PDB |
|
Manage Many as one
|
Incremental refresh of test/dev master
|
Snapshot carousel
|
RAT and ADDM at PDB level
|
|
|
Patching, Backup,
Security, Online Cloning, Online Relocation |
Application containers
|
Refreshable PDB
switchover |
Automated PDB Relocation
|
|
|
Category
|
DB Versions
|
|||
|
12.1
|
12.2
|
18c
|
19c
|
|
|
Security
|
Security In-Depth
Access Controls, Encryption, Redaction, Masking, Auditing, SQL Firewalls Key Vault |
Online encryption
|
Integration with Active
Directory |
Data Dictionary
Encryption |
|
Audit Vault Database Firewall
|
Password-less schema creation
|
Password-less Schema-only Oracle accounts
|
||
|
Security Assessment Tool
|
Database Vault Operations
Control |
|||
|
Privilege Analysis available in EE
|
||||
|
Category
|
DB Versions
|
|||
|
12.1
|
12.2
|
18c
|
19c
|
|
|
Application
Development
|
Application Express 5.1
|
Long Identifiers
|
Improved JSON Support
|
SQL JSON Enhancements
|
|
Comprehensive Language support
PL/SQL, SQL , Python, Node.js, PHP, Java, C, .NET, REST JSON |
Case Insensitive Databases
|
C, Python, JavaScript JSON SODA API
|
Materialized View for JSON_TABLE
|
|
|
Private Temporary Tables
|
Partial JSON Update
support |
|||
|
Realtime SQL Monitoring for Developers
|
||||
|
Category
|
DB Versions
|
|||
|
12.1
|
12.2
|
18c
|
19c
|
|
|
Data Warehousing and Big Data
|
Partitioning,
Compression, SQL, Analytical Views, Analytical SQL, Data Mining |
Partitioned External
Tables |
In-Memory for external
tables |
Hybrid Partitioned Tables
|
|
Easily analyze data held in Hadoop with Big Data SQL
|
Analytical Views
|
Automatic propagation of nologged data to standby
|
Stats only Queries
|
|
|
Big Data Appliance
|
Machine Learning :
Random Forrest, Neural Network |
|||
|
Category
|
DB Versions
|
|||
|
12.1
|
12.2
|
18c
|
19c
|
|
|
Other
Improvements
|
EZConnect Improvements
|
|||
|
Oracle Database XE
Free to use Includes most EE features no RAC, Data Guard, GoldenGate |
||||
|
Oracle Database 19c RPM
Install, Yum install of Oracle Instant Clients |
||||
|
Oracle Read Only Homes
|
||||
|
No click through client
software install |
||||
|
Oracle Docker images
|
||||
|
SQLDeveloper Web
|
||||
|
Oracle Data REST Services (ORDS)
|
||||
Autoconfig Error on Appstier Tier: Context Value Management Failed
October 29th, 2019, posted in Oracle EBS ApplicationAfter clone, while running adautocfg.sh getting the following error.
Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...Exception in thread "main" java.lang.AbstractMethodError: oracle.sql.LnxLibThin.lnxnuc([BILjava/lang/String;) at oracle.sql.NUMBER.toInt(NUMBER.java:413) at oracle.jdbc.dbaccess.DBConversion.NumberBytesToInt(DBConversion.java: 2959) at oracle.jdbc.driver.OracleStatement.getIntValue(OracleStatement.java:4583) at oracle.jdbc.driver.OracleCallableStatement.getInt(OracleCallableStatement.java:635) at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java: 216) at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222) at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1586) at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:665) Error returned from java. Context Value Management was aborted ERROR: Context Value Management Failed. Terminate. The logfile for this session is located at: %APPL_TOP%\admin\%CONTEXT_NAME%\log\\adconfig.log
Solution :
The reason for this error is that JAVA_TOP/oracle/sql contain the following two files
LnxLibThin.class,
LdxLibThin.class
Need to remove and re-run autoconfig again.
As part of the 11.5.10 Maintenance Pack, these files should have been removed by adpatch
After successfully removed these two files, need to re-run the autoconfig from Applmgr user
Cheers!!!
AutoConfig Failing With NegativeArraySizeException 11g Database
October 6th, 2019, posted in Oracle QueriesI encountered Some issues. I encounter this issue while running autoconfig as post upgrade step.
Error stack while running autoconfig :
Updating Context file…COMPLETED
Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NegativeArraySizeException has been detected in FND_GSM_UTIL.upload_context_file. oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -29532: ORA-29532: Java call terminated by uncaught Java exception: java.lang.NegativeArraySizeException has been detected in FND_GSM_UTIL.upload_context_file. at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:281) at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBInf(FileSysDBCtxMerge.java:735) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:224) at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1663) at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:709) FAILED
Solution:
Run below query from apps user>
select is_compiled from user_java_methods where name = 'oracle/xml/parser/v2/SAXAttrList' and method_name='addAttr'
and arguments=7;
It should return “YES”, if it return YES then proceed further.
Execute following sql statement from RDBMS oracle home as apps user:
call dbms_java.set_native_compiler_option('optimizerThrowConversion', 'false');
Execute the following sql statement from RDBMS oracle home as sys user:
call dbms_java.set_native_compiler_option('optimizerThrowConversion', 'false');
Flush all JIT-compiled code from the database by using following statement as SYS:
truncate table java$mc$; commit;
After this step restarted database and completed autoconfig without any issues.