Technical Blog
  February 2009
September 2008




  

Technical Blog





Enable root logon to Ubuntu Desktop
By default, root user cannot logon to Ubuntu Desktop using GDM.
Following are the steps to enable the root logon:
  1. Navigate to System >> Administration >> Login Window.
  2. On the Login Window Preferences window select Security Tab
  3. On the Security tab check the empty checkbox labelled 'Allow local system administrator login'.
  4. Click on Close button.
  5. Navigate to System >> Administration >> Users and Groups.
  6. On User Settings window select root user then click on Unlock button.
  7. On Authenticate window enter password of the the user that you are logged on as.
  8. Select root user and click on Properties button.
  9. On Account 'root' properties window enter root password of your choice then click OK
  10. Reboot the system and now you can logon as root user.




Using Oracle SQL Developer to connect SQL Server 2005
I do admit that I am not a great fan of Microsoft technologies, but one of my clients is using SQL Server 2005 as a backend to some applications running on Weblogic 8.1.

Till now I have been using Windows VM to work on SQL Server 2005 and rest of the tools like Weblogic Workshop, Eclipse, etc. on Linux.

After a lot of googling I finally figured out how to connect SQL 2005 server from SQL Developer.
Here is how:
  1. Download jTDS - SQL Server and Sybase JDBC driver (jtds-1.2.2-dist.zip)
  2. Unzip the file and copy jtds-1.2.2.jar from extracted folder to {sqldeveloperhome}/jdbc/lib folder.
  3. Open SQL Developer.
  4. From Menu click Tools >> Preferences...



  5. In Preferecnes window select Database >> Third Part JDBC Drivers



  6. Click on Add Entry and select jtds-1.2.2.jar from {sqldeveloperhome}/jdbc/lib folder.
  7. Click OK
  8. Now click on New Connection icon -- the tabs for SQL Server and Sybase connection are added next to Oracle Connection tab. Now all we need is the SQL Server details.



  9. Easy! :)




ORACLE XE: “ORA-12519, TNS:no appropriate service handler found”
I spent a lot of time to crack this one. I am using Oracle XE 10g. Quick fix is to run following statement as SYSDBA:
"ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;"

You can run this statement in SQL Developer connecting as System user.