Oracle

Installation on Linux/CentOS
Steps: 

• Setup X tunnel via SSH
• Installation
• Partitioning

1. Setup X tunnel via SSH
I use for that a "VcXsrv Windows X Server" 
Setting server:


You must disable access control

Verify wich display number you get (by default - first start of application is hostname:0.0)



Now set Putty to work with X window:
Connection->SSH->X11 forwarding enable and put here a number from above.
Of course, you can save this seassion for next time.



In Linux (remote) side:


xauth list $DISPLAY

node01.thegeekdiary.com/unix:10  MIT-MAGIC-COOKIE-1  dacbc5765ec54a1d7115a172147866aa
# echo $DSIPLAY
localhost:10.0

3. Switch to another user account using sudo. Add the cookie from the command output above to the sudo user.


# sudo su - [user]
# xauth add node01.thegeekdiary.com/unix:10  MIT-MAGIC-COOKIE-1  dacbc5765ec54a1d7115a172147866aa

4. Export the display from step 2 again for the sudo user. Try the command xclock to verify if the x client applications are working as expected.


# export DISPLAY=localhost:10.0
# xclock



2. Installation
##################TBD#####################
3. Partitioning

##################TBD#####################

Partitioning
To Use the Partitioning Option in your Database, it's required to:

1- Install the Oracle Software with the Partitioning Option.
2- Enable the Partitioning option at the Database Level.

you can check the partitioning opion install, in the OUI check the installed product.
to check whether partitioning enabled or not run
SQL> select * from v$option where parameter = 'Partitioning';

PARAMETER VALUE
-------------------------------- -------------------
Partitioning TRUE

If it is not enabled in the database then do the following step:

- Shutdown all databases that use this ORACLE_HOME
- Run the following

$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on
$ make -f ins_rdbms.mk ioracle

Comments
Hi,

select * from v$option where parameter = 'Partitioning' is showing FALSE after performing the steps u have told

When i performed the step:

$make -f ins_rdbms.mk part_on
make: *** No rule to make target `/u01/app/oracle/rdbms/lib/kkpoban.o', needed by `part_on'. Stop.