Oracle Technology Stack
Day to day Experience on Oracle Database, Oracle E-Business Suite and Linux Operating System
Tuesday, October 1, 2024
Shrink datafile after 'ORA-03297'
›
Problem When try to resize datafile following error occur SQL> ALTER DATABASE DATAFILE '/u01/PROD/data/system01.dbf' RESIZE 10G...
Tuesday, September 10, 2024
Clone PDB on 19c
›
Check Free space on server SQL> col name for a10 col percentage 999.99 SELECT name, free_mb, total_mb, free_mb/total_mb*100 as percen...
Tuesday, July 25, 2023
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
›
There are many ways to overcome this issue Method 1 - Increase parameter Check Current connection count SQL> SELECT count(*) as con...
Sunday, March 19, 2023
Data Guard Broker Configuration in 19c
›
Data Guard broker is a centralized framework to manage entire Data Guard configuration through a client connection to any database in the co...
Thursday, March 9, 2023
Configure SSL on Oracle E-Business Suite 12.2 using Self-Signed Certificate
›
1. Creating wallet Surce run edition environemnt variable $ source EBSapps.env run Navigate to s_web_ssl_directory/Apache, If not creat...
Wednesday, February 1, 2023
Change Backup Retention Policy on Standby Database
›
Problem Following error occured when try to change backup policies on standby db RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF...
ORA-30554: function-based index is disabled
›
Problem Following error occured from DB when access the table Rejected - Error on table GPS.MAIN_PROD. ORA-30554: function-based index GPS...
›
Home
View web version
