Category: Linux

Oracle and Toad – tnsnames.ora example

Getting Toad to work with Oracle doesn’t seem to be explained very well anywhere. Here’s a quick list: Download and Install TOAD from http://www.toadsoft.com/toad_oracle.htm Download and Install the Oracle XE Client from http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html If you launch toad now, you should see XE as an option for connecting to Oracle Create a tnsnames.ora file in C:/Program […]

svn: PROPFIND request failed on /svn – Moved Permanently

Setup a new svn repo, and got the following error: # svn checkout http://xx.xx.xx.xx/svn /var/www/myproject –non-interactive# svn: PROPFIND request failed on ‘/svn’# svn: PROPFIND of ‘/svn’: 301 Moved Permanently (http://xx.xx.xx.xx/) Make sure apache has read/write access to the repo, if that doesn’t fix it, then move your svn repo out of the DocumentRoot and you […]

Oracle Joins Across Multiple Servers

You can create a link as: CREATE PUBLIC DATABASE LINK “OtherDB” CONNECT TO “UserName” IDENTIFIED by “Password” USING ‘SID’SELECT * FROM “OtherSchema”.”TableName”@”OtherDB”; or CREATE SYNONYM “otherTableName” FOR “OtherSchema”.”TableName”@”OtherDB” SELECT * FROM “otherTableName” ( it’s easier to do this via the oracle enterprise manager http://192.168.X.X:1158/em Administration > Schema ) You need to establish the link as […]

Hide .svn files on a samba share

Found myself in a situation where I was editing and uploading some files through Dreamweaver on a windows box. The files were accessed via a mounted samba share on a debian server. Didn’t want dreamweaver to see all the .svn directories and files under them (so uploading a folder from dreamweaver would skip uploading the […]