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 25, 2014 | Blog, Data Management, Databases
Beginning in SQL Server 2005 Microsoft introduced a hidden database called the Resource Database. While it is often referred to as the resource database the actual name is mssqlsystemresource. The database contains all the system objects that are included with SQL...
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 | Nov 18, 2014 | News
Austin, TX, (PR.com) – Liferay, Inc., provider of the world’s leading enterprise open source portal platform, announced XTIVIA, Inc. (XTIVIA) the 2014 Liferay “North America Partner of the Year” for the third year in a row. This year’s announcement was made at the 9th...
by XTIVIA | Nov 13, 2014 | News
11-13-14 by PR.com St. Louis, MO, November 13, 2014 –(PR.com)–XTIVIA, Inc. (XTIVIA) announced today that they are the recipient of the 2014 Infor CRM Project of the year award. The announcement was made at...
by XTIVIA | Nov 6, 2014 | News
Denver, CO, November 06, 2014 –(PR.com)–XTIVIA, Inc. is celebrating the 15th anniversary of its remote database administration support service, Virtual-DBA. XTIVIA continues to be a market leader in multi-platform remote database administration through...
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 21, 2014 | Blog, Customer Relationship Management
Wanted to share a small trick I used to make Infor CRM / Saleslogix more usable on laptops, especially if you have customized screens that are very tall. On devices with a low resolution height, tall screens can push the resize handle low enough that it can’t be...
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 | Oct 12, 2014 | News
Liferay Community Excellence The Community Excellence Award was awarded to XTIVIA for demonstrating a unique and valuable dedication to Liferay’s open-source community. This award is given to companies that have spent their own time and resources to make the Liferay...
by XTIVIA | Sep 26, 2014 | News
XTIVIA makes Inc.5000 – Fastest Growing Companies list.
by XTIVIA | Sep 26, 2014 | Blog, Business Intelligence, Data Warehousing, Enterprise Infrastructure
Talend Open Studio does (TOS) not have versioning like the Talend Integration Suite (TIS). In order to set up versioning for TOS we decided to use Tortoise SVN as the client & Slik SVN as the server. After installing Tortoise SVN & Slik SVN, close TOS if you...
