Thursday, August 29, 2013

install sqldeveloper on Ubuntu 12.04 LTS

1.download the oracle from Oracle main Site …Geek alert- Nah no command for this , you need to go register and download !!!
2.sudo apt-get install alien (Most probably this would have got already installed while installing oracle)
3.Logically you have  a rpm now so you got to change it to the format ubuntu understands it right ? Alient is your saviour to get that bit done

sudo alien --scripts -d sqldeveloper-3.2.20.09.87-1.noarch.rpm

4.Install sql developer from the deb package you have
sudo dpkg -i sqldeveloper_3.2.20.09.87-2_all.deb

5.Create the following directory in your home folder, this where it's going to store path to the jdk in the next step:
cd /home/$username(The system name variable)
say in my case cd /home/manish
  1. mkdir .sqldeveloper/
Run the sql developer from shell it is gonna ask it to feed path of java Do that , see 
echo $JAVA_HOME and feed that as input
mostly it is going to look like this
/usr/lib/jvm/java-6-openjdk
sudo /opt/sqldeveloper/sqldeveloper.sh

Tuesday, August 27, 2013

Install latest version of R on Ubuntu [if you have some version already installed and getting ERROR: dependencies ‘mclust’, ‘flexmix’ are not available for package ‘fpc’ on R studio]

I had R 2.0.14 on my ubuntu 12.04 LTS and was trying to use the command 
install.packages("fpc")

ERROR: dependencies ‘mclust’, ‘flexmix’ are not available for package ‘fpc’

That is where is realized that my R version is old to have these packages and hence the obvious solution is to uninstall and install latest R 

These details i found on StackOverflow  and it worked for Me

Uninstall old R
sudo apt-get remove r-base-core
Adding deb to sources.list
sudo nano /etc/apt/sources.list    
deb http://cran.rstudio.com/bin/linux/ubuntu precise/
precise is your ubuntu name (may be different)
Add key to sign CRAN packages
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys E084DAB9
Add specific PPA to the system
sudo add-apt-repository ppa:marutter/rdev
sudo apt-get update
sudo apt-get upgrade
installing
sudo apt-get install r-base
From R to check version
version
should give you
version.string R version 3.0.1 (2013-05-16)
Credit Anando Mahto (StackOverflow member)