by XTIVIA | Jan 26, 2015 | Blog, Data Management, Databases
The ORA-600 is an internal Oracle error that can be reported by a very serious error. A lot of times this error can’t be solved by an onsite DBA and needs direct help from Oracle to help troubleshoot the issue. If the trace files from the error don’t prove...
by XTIVIA | Jan 24, 2015 | Blog, Data Management, Databases
ORA-12154: TNS:could not resolve the connect identifier specified This is one of the most common Oracle errors and it is basically telling you that you are trying to connect to a database name that is unknown to the system. The most common cause are typos in your...
by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
It’s well known that Oracle has some of the most complicated licensing practices when dealing with virtual hosts/machines. Not only complicated, but also very expensive. I recently work on a project involving a database move to one of the popular cloud...
by XTIVIA | Jan 20, 2015 | Blog, Data Management, Databases
Oracle subscription for node down event pending. You will sometimes see this message on an Oracle database from 10g forward as that is when the default subscription to the Oracle Notification Service(ONS) was introduced. In a single instance environment it is...
by XTIVIA | Dec 8, 2014 | Blog, Data Management, Databases
Recently for a client I had to manually remove a few failed database software installations and a couple of failed client installs from a Windows 2008R2 server. Attempts were made to try and force a 10.2.0.1 Oracle Database and client install on the server. They were...
by XTIVIA | Dec 8, 2014 | Blog, Data Management, Databases
So we have several Virtual-DBA clients that come to us that either had previous DBAs onsite or previous remote DBA services. Everyone has different ways of setting up performance monitoring of databases, though a potentional problem that I see a lot is the...
by XTIVIA | Dec 8, 2014 | Blog, Data Management, Databases
I encountered an issue today with an instance that was showing up in OEM 11g though you couldn’t get to the database instance management page as the Agent Connection to Instance was reporting Unavailable. I came up with nothing after a few hours of checking...
by XTIVIA | Nov 19, 2014 | Blog, Data Management, Databases
I’m not going to draw this out, though I just wanted to help make this information more widely known to the Oracle community as it was news to me when researching CPU patches for a 12c client of ours. Direct Quote from Oracle Docs: “2.1 Database Security...
by XTIVIA | Oct 31, 2014 | Blog, Data Management, Data Warehousing
So I encounter the looping chain of synonyms error every once in a while and it seems pretty simple to understand, though I thought I would take a minute to demonstrate how it works. ORA-01775: looping chain of synonyms – Basically means that you created a...
by XTIVIA | Oct 20, 2014 | Blog, Data Management, Databases
There might be better ways to do it, though this is how I renamed a database when asked to do so…Hope it helps someone out. Make sure Oracle env is set ORACLE_HOME ORACLE_SID sqlplus / as sysdba create pfile from spfile; exit Create a full database backup just...
