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 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 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 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 | 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...
