ORA-12154: TNS:could not resolve the connect identifier specified!

Often users face this issue while establishing a connection to their database. In layman terms, it implies that Oracle is unable to understand the user-defined connection. The […]

By |

Oracle Offers Remote Privileges for Cloud Through Its Cloud at Customer Program

There are so many companies that would find it more suitable to move to a public cloud. But, they are usually restricted due to concerns and restrictions […]

By |

Why Software Consultation Is Rising In Current Business Scenarios?

Software consultation is in demand! The whole world is seeing the growth of the IT sector, and with that, the growth of the different business sectors as […]

By |

Oracle 12.2 Database: 9 Features

With the launch of the onsite version of the Oracle 12.2 Database, people are interested in hearing about the new features. We detail 9 key features in […]

By |

How to Manage Your Oracle ULA

The Oracle Unlimited License Agreement (ULA) has been an issue for many organizations. The management of this agreement is so critical, that it leaves you with too […]

By |

The Cost of Oracle Development License

Is it time for you to decrease the cost of an Oracle development license? In most cases, different companies focus on license cost cutting; therefore, they are using versions, […]

By |

Clear The Confusion: Oracle Consulting Services

When you decide to invest in Oracle consulting services, many confusions arise due to the lack of understanding of the work system. So, here, we are exploring […]

By |

Oracle Consulting Companies Eliminate Threats

Outsourcing IT services is playing a key role in the current business environment, therefore businesses are turning to Oracle consulting companies. Specialized professionals offering great services to […]

By |

Reduce Oracle Licenses Costs: 3 Ways

Reduce Oracle licenses costs without losing licenses your business requires to run efficiently. Cost control of licenses is an issue most organizations are facing today. Even with […]

By |

Finding The Best Oracle Consultant: 4 Tips

Finding the best Oracle consultant for your needs is a process; you want to make sure that you invest in one Oracle consultant who can get the job done. […]

By |

Ensure a Database Smooth Migration

It is known that databases work behind the scenes to provide a smooth workflow for your business. It provides the required information to your employees and keeps […]

By |

The Risks That Arise When You Put Your Oracle Database in The Cloud

Each and every business has its priority when it comes to the Oracle database. Not all of them get benefited by putting it in the cloud. But, […]

By |

How to Protect Oracle Database From Hacking

The defense system of your Oracle database decides the security of all the precious information of your company. The threat of getting hacked keep roaming around the […]

By |

The Benefits of Having Database Management

You love to ride a horse, but don’t know how to ride. What is the solution? Simple, just someone who knows how to control the horse and […]

By |

The Success of Database Recovery After a Disaster

The disasters are the truth of our world. They come in front of us through different ways and in different forms. Just the word ‘disaster’ puts a […]

By |

5 Latest IT Strategy Tips to Improve the Functions of Your Organization

The market is giving a lot of opportunities for new as well as existing organizations. To capture all of these opportunities, it is essential that you add […]

By |

Oracle Goldengate – unable to start integrated replicat – OGG-00446

For one of our projects, we upgraded Goldengate version to 12.2.0.1. After upgrading to newer version, I am able to successfully add new replicats. But when I […]

By |

oracle impdp as sysdba and attach job

impdp allows Oracle DBA to exit out of the current process while the job continues to run in the background.  In the event you have to connect to the […]

By |

oracle – generate kill database sessions script

Here is the script that comes handy to Oracle DBAs for generating script to kill sessions based on user sessions.

For example, this SQL script generates the script to kill […]

By |

Oracle dbms_job remove from another schema

In the following use case, as sysdba I am trying to remove the job that belongs to another user – ‘AMS2000’ that results in error – ORA-23421.

As a sysdba, […]

By |

Enabling and Disabling – auto optimizer stats collection

Here is how you can query if the Auto Optimizer Stats Collection job is running in Oracle Database 11g:

Login to database as SYSDBA:

SELECT CLIENT_NAME,
STATUS
FROM DBA_AUTOTASK_CLIENT
WHERE CLIENT_NAME = ‘auto optimizer […]

By |

oracle standard edition one vs oracle standard edition 2

Starting Sept 2015, Oracle Standard Edition and Oracle Standard Edition One are no longer available from Oracle.  Oracle Standard Edition 2 is the new product offering under standard edition […]

By |

Goldengate Integrated Extract – Identifying and resolving extract process hang issue

Goldengate extract process can hang for various reasons. It is very important to have a process in place to monitor goldengate process and detect hanging issues. I recently encountered […]

By |

expdp fails with ORA-27037 on Oracle RAC

When parallel option is used in expdp, it expects the DIRECTORY path to be available on nodes of the cluster. If you have created the directory on only […]

By |

Identifying Blocking Sessions in Oracle Database

Below SQL gives the blocker and blockee sessions in database.

Oracle RAC Environment:

select
(select username from gv$session where sid=a.sid) blocker,
a.sid,
'is blocking',
(select username from gv$session where sid=b.sid) blockee,
b.sid
from gv$lock a, gv$lock b
where [...]

By |