SSIS ORA-00900: invalid SQL statement calling Oracle Procedure

Calling an Oracle stored procedure in SSIS is a little different than calling a SQL Server version.  Today I will show you the error you get if trying the SQL Server syntax and how to fix it.

Continue reading SSIS ORA-00900: invalid SQL statement calling Oracle Procedure

One Year Anniversary of Blogging!

Today is my one year anniversary of blogging!  If you would have told me 14 months ago that I would be writing a technical blog, I would have looked at you like you had two heads!  It has gone very well and I have learned/reinforced some valuable skills such as TESTING/TESTING/TESTING, writing comprehensive documentation, and keeping my problem solving skills honed.  See below for some stats from the previous year.

Continue reading One Year Anniversary of Blogging!

Backing up an Oracle Database with RMAN

Some workplaces have multiple database platforms that you will be responsible for.  The main thing a DBA is responsible for is being able to recover the database in case of a disaster.  Below is an easy way how to backup an Oracle database using RMAN.  Is it the only way to do this?  Of course not, there a literally dozens of ways depending on how complicated your environment is, but it is a legitimate way to create a backup and it will save you.  In the next posting, I will show you how to restore the database onto a new server.

Continue reading Backing up an Oracle Database with RMAN

Query Timeout Expired

If you ever use linked servers to run queries on a remote database server, you may run into this issue if your queries take longer than 10 minutes:  OLE DB provider “SQLNCLI11” for linked server xxxxx returned message “Query timeout expired” [SQLSTATE 01000] (Message 7412)

Continue reading Query Timeout Expired