Oracle Database&EBS General
-
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
One of our 12c database hitting this message at alertlog ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT of 1024 MB PGA_AGGREGATE_LIMIT parameter comes with 12c, it sets a hard limit on the amount of PGA taken up by an instance. Program Global Area (PGA) is Continue reading
-
How to move Control File to another location
You may need to move your control file to one other location. You can follow below steps for can move your control file to one other location. First We will verify the current location of the control files. Continue reading
-
Import terminate by ORA-03106 and ORA-39126 errors
I faced with that issue to make import process on our system. My source db version is 11.2.0.4 and target db version is 12.1.0.2 RAC During import process (used impdp) its ended by below error messages Continue reading
-
How to change the character set of a database
How to change the character set of a database. You may need to change your database character set due to do some requirements. In this example, I am going to change my db character set from UTF8 to WE8ISO8859P9 Here are my steps: Continue reading
-
Yum install command gives “Loaded plugins: langpacks, ulninfo Existing lock /var/run/yum.pid: another copy is running as pid”
While I was trying to make rpm installation by yum, it gave below error [root@veridata ~]# yum install pdksh* Loaded plugins: langpacks, ulninfo Existing lock /var/run/yum.pid: another copy is running as pid 8432. Another app is currently holding the yum lock; waiting for it to exit… The other application is: PackageKit Memory : 85 M Continue reading
-
11gR2 Missing packages on OEL 7.6
I face with that issue while I was making Oracle 11.2.0.1 version on OEL 7.6. At prerequest check screen Here is the screen shot: Continue reading
-
“pdksh-5.2.14” is missing when Installing 11.2.0.4 on RHEL 7.6
While I am installing Oracle 11.2.0.4 on RHEL 7.6 I hit this message on prereq screen. After I made some search I found a solution as below. Login as installation user. In my case my user is oracle Continue reading
-
How to change boot loader option in OEL7.6
After Installing OEL7.6 boot loader comes with 3 options. You need to choose the options to can login your system every boot. If you want to fix default boot you need to follow below steps: Continue reading
-
Getting ORA-01555: snapshot too old: ORA-02354: error in exporting/importing data error during expdp
You may hit with that error code during the export process. I faced with those error on Oracle 12c database. Complete error messages are: ORA-31693: Table data object “SCHEMA”.”TABLE_NAME_HERE” failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-01555: snapshot too old: rollback segment number 21 with name “_SYSSMU21_2773200038$” Continue reading
-
Manually Clear Alerts in Oracle Enterprise Manager
You may need to try to clean Alerts in your OEM. This method can be helpful when there are alerts that the agent won’t clear clearstate or reset dynamic properties won’t work Here are the steps First, log in as SYSMAN or your repository owner. Continue reading
HELIOS BLOG 