<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>DB Tricks</title>
	<link>http://dbtricks.com</link>
	<description>DataBase Tips and Tricks</description>
	<lastBuildDate>Thu, 02 Sep 2010 11:11:41 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>What to do when Oracle XE is not starting after a reboot</title>
		<description><![CDATA[When you install Oracle Xe on a windows machine (mainly server OS&#8217;s like Windows 2003) you may notice that the database is not always starting after a reboot. This ussualy happenes when the Oracle XE was installed under a different user than the one you are currently logged in as.
It is easy to start the [...]]]></description>
		<link>http://dbtricks.com/?p=152</link>
			</item>
	<item>
		<title>How to grant privileges on all tables to a user</title>
		<description><![CDATA[Sometimes you need to grant privileges to one user&#8217;s objects to another user. While granting should be done very carefully, when you have a lot of tables it is nice to have an automated script to do it.

It is important to note that the best way to do that is creating a role, granting the [...]]]></description>
		<link>http://dbtricks.com/?p=135</link>
			</item>
	<item>
		<title>&#8220;A service specific error occurred: 2&#8243; when trying to start dbconsole</title>
		<description><![CDATA[When logging in to database control after some time you may get a message that some accounts&#8217; passwords need to be changed (sysman, system etc..).  A page will be displayed allowing you to change those password but if something (like timeout)  happens during the page processing you will not be able to log in [...]]]></description>
		<link>http://dbtricks.com/?p=130</link>
			</item>
	<item>
		<title>Net configuration assistant changes are not saved on Windows 7</title>
		<description><![CDATA[If you are trying to use the oracle net configuration assistant in order to create tnsnames.ora entry on windows 7, you may notice that sometimes the net service name is simply not created. Even after you run through the wizard successfully you may get the famous “ORA-12154 – TNS could not resolve service name” when [...]]]></description>
		<link>http://dbtricks.com/?p=122</link>
			</item>
	<item>
		<title>&#8220;Shrink failed for Database&#8221; when attempting to shrink a data file.</title>
		<description><![CDATA[Sometimes, when you try to shrink a data file you may get the following message:
TITLE: Microsoft SQL Server Management Studio
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;
Shrink failed for Database &#8216;Data base name&#8217;.  (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&#38;ProdVer=9.00.1399.00&#38;EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&#38;EvtID=Shrink+Database&#38;LinkId=20476
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;
A severe error occurred on the current command.  The results, if any, should be discarded. [...]]]></description>
		<link>http://dbtricks.com/?p=116</link>
			</item>
	<item>
		<title>What to do when listener.log is growing.</title>
		<description><![CDATA[over time, the Listener.log file can grow to huge size and take a lot of disk space.
If you will try to delete it in windows you may get the following error:

&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;
Error Deleting File or Folder
&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;
Cannot delete listener: It is being used by another person or program.
Close any programs that might be using the file and [...]]]></description>
		<link>http://dbtricks.com/?p=95</link>
			</item>
	<item>
		<title>Adding a Transaction Log at runtime to prevent it from running out of space</title>
		<description><![CDATA[sometimes, when running a big transaction, the transaction log can become full or simply grow to a huge size . while you can sometimes free some space using &#8220;backup log db-name with truncate_only&#8221; and trying to shrink the DB using SQL Management studio. 
The process is described in the above link but basically it is: [...]]]></description>
		<link>http://dbtricks.com/?p=91</link>
			</item>
	<item>
		<title>Possible Causes to ORA-00980 Synonym Transaltion no longer valid</title>
		<description><![CDATA[ORA-00980: synonym translation is no longer valid
This error usually means that the synonym used is based on a table, view, or synonym that no longer exists. in order to fix it you will need to replace the synonym with the name of the object it references or re-create the synonym so that it refers to [...]]]></description>
		<link>http://dbtricks.com/?p=89</link>
			</item>
	<item>
		<title>Hostname Column in SQL Profiler 2005</title>
		<description><![CDATA[If you are using SQL Profiler and you want to know which workstation is using the db you should use the hostname column in sql profiler.
While this was relatively straight forward in SQL Server 2000, users of SQL Server 2005 may find that the hostname column is not displayed when running the SQL Profiler. By [...]]]></description>
		<link>http://dbtricks.com/?p=87</link>
			</item>
	<item>
		<title>OUI.EXE has stopped working on Windows 2008</title>
		<description><![CDATA[If you are trying to install Oracle 10.2.0.3 client on a Windows 2008 server and you get the following error:




OUI.EXE has stopped working
Close the program
 
For some reason, the Oracle installer is having problem with long directory structures.
To overcome this, you can simply copy the installtion directory to a location with a shorter path.
1)create a new Temp [...]]]></description>
		<link>http://dbtricks.com/?p=65</link>
			</item>
</channel>
</rss>
