Oracle Database&EBS General
-
Naming Convention for Oracle Database
As you know Oracle has new naming convention. Before start Let us check current Release and Support Timelines. Now here is the details Continue reading
-
ORA-02080: database link is in use
You may face with that error while you are working with dblink. Sometimes, after a remote operation a user wants to close the connection to the remote site to conserve resources. Formal details lets look at the oerr: ORA-02080, 00000, “database link is in use” Cause: a transaction is active or a cursor is open Continue reading
-
/etc/rc.d/rc.sysinit: fork: Cannot Allocate Memory error after reboot Oracle linux
One of our customer need to decreased server RAM from 128Gb to 32 Gb. After closing database, We rebooted server. While server trying to open it gave below error message: Continue reading
-
What Oracle Background Processes Stand for?
As you know there many oracle process are running as background process. You may now some of them or you may not. So You can find related process from oracle documentation or you can follow below steps: Some of Oracle Process: Continue reading
-
Getting ORA-29024&ORA-29273 for https request
I got email from one of our customer. He says they have been changed their SMS system and they want to use https. But when they try to get select query return with below error message ORA-29273: HTTP request failed ORA-06512: at “SYS.UTL_HTTP”, line 1572 ORA-29024: Certificate validation failure ORA-06512: at line 1 I tried Continue reading
-
List Rman Backup Details
In my previous post I shared some command which are related to get information RMAN backups. You can find this post in this link In this post I try to give more details and examples for to get information about our RMAN backups Continue reading
-
In Grid Infrastructure How We Can Change IP
Yo may need to change your existing IP or hostname after installation for your setup In this case I need to change my current IP to another on my standalone GI. Operation System –> AIX 7.1Oracle GI Version –> 12.1.0.2 Continue reading
-
What happen When You run Update in database
It is easy for all to make 1 row update or 1000 row update in database. Kust write code than wait some second and finally get xxx row updated. It seems very easy right? But Let us see what happen when you update some rows at database. I assume that We are updating or selecting Continue reading
-
What is Block Corruption&How We can Solve Block Corruption
In daily IT process, There are many possible causes of a block corruption including: – Bad IO hardware / firmware– OS problems– Oracle problems– Recovering through “UNRECOVERABLE” or “NOLOGGING” database actions (in which case ORA-01578&ORA-01110 is expected behavior) Continue reading
-
Getting ORA-39726 error on compressed tables
I face with that error message while I tried to drop column on my compressed tables which in exists in my Exadata. Bad news is, there is no solution in 10g release. But there are some workaround options available for can pass this error. What are those options? These are: Upgrade your db to 11gR2 Continue reading
HELIOS BLOG 