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 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 XTIVIA | May 28, 2014 | Blog, Data Management, Databases
So for various reasons I run into orphaned datapump jobs either due to a session failure during the import or for some other unknown reason for a failed import. What I wanted to show you really quick was how to find them and how to remove them so you can run your...
by XTIVIA | May 7, 2014 | Blog, Data Management, Databases
Managing Logins If you have worked with SQL Server a while you may recognize there is a difference between logins and users. When it comes to managing security with SQL Server it is important to know the difference, and the differences that have come about over...
by XTIVIA | Mar 31, 2014 | Blog, Data Management, Databases
So I just wanted to share this quick write up on how to stop and start your Oracle database and listener automatically on a Linux server. I use this approach for 10g, 11g, and 12c and so far I haven’t had any issues. Oracle provides the means to do this using scripts...
by XTIVIA | Mar 28, 2014 | Blog, Data Management, Databases
In cases when a database change needs to be made there are some good rules that when used can save you a lot of time down the road. Run changes via scripts – Scripts add for precise execution and help remove human error when it comes to typos. When creating scripts...
by XTIVIA | Feb 14, 2014 | Blog, Data Management, Databases
I was working with a customer the other day and they were asking for some help setting up dbconsole for their 12c database. It seems that it wasn’t working out of the box and they needed some help configuring it. So of course I said sure no problem! I have done...
