ORA-06512: at “SYS.OWA_UTIL”
Hi guys! Have you ever encountered this error ORA-06512: at “SYS.OWA_UTIL” during a package compilation using for example the Oracle sql developer software? Problem: line 1: ORA-06502: PL/SQL: numeric or… Read more »
Category: Oracle
Oracle 12c/18c/19c: Advanced Network Compression
Starting with Oracle 12c, Oracle supports Advanced Network Compression. Too bad, it is available as part of Advanced Compression option. Oracle compresses the data to be transmitted over network at… Read more »
How to change hostname in ORACLE ASM
Pre-Tasks If you root then execute su – oracle Then > . oraenv Write down: +ASM Before start with the Oracle Restart process you must stop the listener: [oracle@DB ~]# crs_stat… Read more »
JDBC and UCP New Features in Oracle Database 19c and 18c
Oracle Database 19c and 18c JDBC drivers and Java connection pool (UCP) introduce several new features in the performance, high availability, security, and scalability areas. New connection and security features… Read more »
How to purge the Oracle unified audit trail
The unified audit trail, which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace, makes this information available in a uniform format in the UNIFIED_AUDIT_TRAIL data… Read more »
Automatically and Manual Purging Alert Log and Trace files with ADRCI
Automatically purging Sometimes we are facing with space related issues due to the huge number of trace file generation. Automatic purging can help us in this situations if set short… Read more »
How To Audit All Access of Proxy Users with Unified Auditing
This article is intended to provide an example for how to audit access by proxy users using the Unified Auditing feature brought out in Oracle Enterprise Database 12c. The sample… Read more »
ALTER TABLE … MOVE PARTITION ONLINE license trap
The new features of Oracle 12c I had looked closer at possibility to move partitions online. You can move the partition while it is being accessed by DMLs and queries,… Read more »
Oracle Database 18c Express Edition (XE) RPM Installation On Oracle Linux 6 (OEL6) and 7 (OEL7)
Oracle Database 18c Express Edition (XE) RPM Installation On Oracle Linux 6 (OEL6) and 7 (OEL7) This article describes the Oracle Database 18c Express Edition (XE) RPM installation on Oracle… Read more »
Previews Roadmap to Oracle Database Version 19c
At the close of a presentation in which he announced general availability of the company’s latest Autonomous Database Cloud Service, Oracle Autonomous Transaction Processing, Oracle CTO and chairman Larry Ellison… Read more »