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...
by XTIVIA | Oct 16, 2014 | Blog, Databases
When a database is moved to a new server, existing database users will not have access to the database on the new server. Attempting to add the users to the database on the new server results in an error message saying the user already exists in the database. To fix...
by XTIVIA | Oct 15, 2014 | Blog, Data Management, Databases
Have you ever noticed when you are working on a query for SQL Server and the second time you execute the query it runs much faster than the first time you had executed it? There is a reason for this and most likely it is caused by your buffer. When your SQL...
by XTIVIA | Sep 17, 2014 | Blog, Data Management, Databases
Often when I am requested to look at an issue with SQL Server I have to spend some time in the error log. On a side note, I think the log itself is a commonly overlooked tool for troubleshooting. Often it can be a bit cumbersome to work with if the default settings...
by XTIVIA | Aug 28, 2014 | Blog, Databases
Environment: Informix 11.50 FC3 / AIX 6.1 Genero BDL 2.11.03 / Genero GDC 2.02 / License Manager 5.15. Error: Listener-thread: err = -408: oserr = 0: errstr = : Invalid message type received from the sqlexec process. One of our Virtual-DBA clients...
by XTIVIA | Aug 27, 2014 | Blog, Data Management, Databases
So I wanted to throw a quick reminder out there of a nice feature that came along with Oracle 10g and datapump exports and imports. The feature I’m referring to is the ability to detach and reattach to export and import jobs. To detach from an export or import you...
by XTIVIA | Aug 21, 2014 | Blog, Data Management, Databases
Often the things I post about are the items that I am using that day, or recently. Many of the topics, are simply based on how I may have made using SQL Server a bit easier for me to use one way or another. In another SQL Server Error Log post I had mentioned a few of...
by XTIVIA | Aug 21, 2014 | Blog, Data Management, Databases
Are you testing your database backups, If so how? Sure there are a couple options that you can use to help validate backups but does this mean you are 100% sure, without a doubt, that it can be restored? Have you ever seen a backup file not restore? Recently I was...
by XTIVIA | Aug 19, 2014 | Blog, Data Management, Databases
So tonight we were helping a Virtual-DBA client apply an PSU patch for an ASM/GI Oracle home. It’s a bit different in the fact that you use opatch auto instead of opatch apply or napply. You also need an OCM response file before you can run opatch auto. First...
by Barrie Shaw | Aug 4, 2014 | Blog, Databases
When tuning performance for an IBM Informix instance, one important issue to look for is the presence of tables and indexes containing a large number of extents. Today’s high speed disks and SSD drives can mask some of the performance hit, making this an area...
