Archive for the ‘Databases’ Category

Another snapshot agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent

11, Jun 2010

When creating publication in a merge replication in MSSQL Server 2005, especially for beginners, it’s not new that while doing it in SSMS, you run into steps that makes your publication incorrectly configured thus forcing you to abort the process. Now when you cancel the publication and you’re in the middle of generating the snapshot, [...]

How to setup Oracle10g linked server in an MSSQL Server 2005 64-bit cluster

4, Jun 2010

The process in creating Oracle linked server on a 64-bit SQL Server instance should be: Install Oracle 10g Release 2 64-bit client software (available from Oracle website) Install Oracle 10g Release 2 64-bit ODAC software (available from Oracle website) Restart SQL services Configure OraOLEDB.Oracle under \Linked Servers\Providers in SSMS in its properties making sure that [...]

Configuring distribution in an MSSQL Server 2005 cluster

2, Jun 2010

For some reason that you receive an error trying to configure distribution on your MSSQL Server 2005 cluster and it will ask you to use the actual server name when connecting to the server, verify that your server name in the sys.servers catalogue is the same as your instance name. To verify, while connected to [...]

Cannot manage or see shared drives/LUNs within MSSQL Server 2005 cluster

22, Apr 2010

This happens when the shared drives/LUNs in the cluster are not included in the dependency of your SQL Server resource. To fix this issue, go to SQL Server resource in the cluster’s SQL Group and go to properties. Under Dependency tab, modify it to include all the resources you wanted to be visible within your [...]

Cannot recreate publication: Invalid object name ‘dbo.sysmergepublications’ in MSSQL Server 2005 replication

5, Apr 2010

This happens when you delete subscription and publication directly from Replication node in SSMS tool. Run below against the database you deleted the replication before setting it up again. USE [database] EXEC sp_removedbreplication GO

The Distributor has not been installed correctly. [SQLSTATE 42000] (Error 20036)

1, Apr 2009

Once replication is setup, the “Expired subscription clean up” job on the distributor SQL Server fails with the above error. But replication functions normally, without any problems. When you have a dedicated SQL Server 2005 distribution server, that is not publishing any of its own databases, you are likely to get this error. Workaround To [...]

TNS-12546/ORA-12546: TNS:permission denied

1, Oct 2008

After reboot in a newly installed Oracle 10g, TNS fails to start with these error: TNS-12546 / ORA-12546: TNS:permission denied TNS-12560 / ORA-12560: TNS:protocol adapter error TNS-00516: permission denied Solaris Error: 13: permission denied If you try to telnet the port 1521 and you get network is unreachable, this is clearly a permission error related [...]

Oracle 10g: Creating external tables from a text file in a windows system

29, Sep 2008

External Tables let you query data in a flat file as though the file were an Oracle table. In 10g, you can write out data to an external table, but you can’t write to an existing table. While external tables can be queried, they’re not usable in many ways regular Oracle tables are. You cannot [...]


top