Wednesday, March 30, 2011

Get your 4 Giga Ram ( or more) to work under ubuntu 10.10

Hello All,
Usually ubuntu 10.10 (the 32-bit version) does not support 4 giga ram addressing, But the 64-bit version do.

To get your 32-bit version to work you need to install the following:
linux-headers-server
linux-image-server
linux-server
linux-generic-pae
linux-headers-generic-pae

so go ahead and update the system then apt-get install "the above list"

$ sudo apt-get update
$ sudo sudo apt-get install linux-headers-server linux-image-server linux-server
$ sudo apt-get install linux-generic-pae linux-headers-generic-pae

reboot your system ... and have fun !.

Wednesday, March 23, 2011

install .rpm packages in Ubuntu

Hello, Here are the steps :

install alien package

sudo apt-get install alien

then simply run

alien package.rpm

Sunday, March 6, 2011

Install and start Oracle 10g Express in Ubuntu 10.10

Here are The steps to download, install and start Oracle Express 10g getting the History and Arrow Keys to work in Terminal.

Add this line to /etc/apt/sources.list file:

deb http://oss.oracle.com/debian unstable main non-free

Next, you will need to add the GPG key.

wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -

As root, type:

apt-get update

To install the XE database server, apt-get 'oracle-xe-universal' or 'oracle-xe' (Western European support only).

apt-get install oracle-xe-universal

If you only need the XE client, type

apt-get install oracle-xe-client

----------------------------------------------------------


Then
As root, type:
/etc/init.d/oracle-xe configure

Edit your .bashrc file to include the lines:

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server PATH=$PATH:$ORACLE_HOME/bin export ORACLE_HOME export ORACLE_SID=XE
export PATH

Start a new bash shell for the changes to take effect.

To log in as a database administrator:
conn sys as sysdba ; Then write your password

To Access database home from HTTP
http://localhost:8080/apex/

To add new user to the system and give him dba privilages, write the following in the SQL Plus CMD

create user write_user_name identified by write_user_password;
grant dba to user_name;

To unlock the HR account to work with examples provided by Oracle.

alter user HR account unlock ; alter user HR identified by $password ; exit

-----------------------------------------------------


To get the history and arrows keys to work:
Download qgplus , Click Here

after you download gqlplus,

1. find your path variable:
echo $PATH
you should see this path in there:
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/b

2. Extract the gqplus file you have downloaded and take out the gqlplus executable from the linux folder inside it.


3. place the executable in any of the path directories.

e.g. Copy it here :/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin


Then from the terminal run it.

qglplus


Have Fun :) .


References:

- https://help.ubuntu.com/community/Oracle

- https://help.ubuntu.com/community/Oracle10g#head-35cee01075d83fad1bb353beac13b27bda3fee32

- http://ubuntuforums.org/showthread.php?t=320659