Passwords in 11.2.0

Oracle removed the password from the DBA_USERS view in 11g, but apparently it can be fetched from the USER$ table (to which no one should normally have access) by concatenating SPARE4 and the PASSWORD column with a semicolon between the…

Simple example of C# program accessing Oracle

Nothing big, just a placeholder for an example of what is in the subject line. //C:\Users\showard>C:\Windows\Microsoft.NET\Framework\v2.0.50727\csc.exe /r:”C:\oracle\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll” checkConn.cs using System; using Oracle.DataAccess.Client; public class checkConn { public static void Main(String []args){ OracleConnection conn = new OracleConnection(“User Id=biztalk;Password=********;Data Source=fn9dev”); OracleDataReader rdr;…

ACFS install on CentOS

I run CentOS on a test cluster, and every time I patch it with a PSU or whatever, my ACFS installation is trashed as CentOS is not officially supported. To fix this, change the following section in $GRID_HOME/lib/osds_acfslib.pm… if ((defined($release))…