Friday, October 9, 2009

How to: Oracle 10g installation on RHEL5

Published by CybTech at 10:02 AM

Oracle 10g v10.2.0, RHEL 5.3, kernel 2.6.18-128.1.1.el5xen
Software requirements

After standard system installation and updating, install the following packges:

* compat-libstdc++
* libXp
* libXtst
* gcc
* gcc-c++
* glibc-devel

Users and groups

If the user oracle already exists but you could not use it (e.g., you are using a company Kerberos), you can use different user name. You can also add the user in more groups (-G argument), or set another home.

# groupadd dba
# groupadd oinstall
# useradd -g oinstall -d /home/oracle -G dba oracle
# passwd oracle

Set system limits

To view current limits use sysctl -a. The used values are required minimums.

shmall should be 2097152, shmni 4096, shmmax half the size of physical memory (in bytes). These requirements are usually met by default.

sysctl -w kernel.sem="250 32000 100 128"
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
net.ipv4.ip_local_port_range="1024 65000"
sysctl -p # reload the changes

Shell profile

Suggested changes to .bashrc:

export PATH=/opt/oracle/product/10.2.0/bin/:$PATH
export ORACLE_OWNER=oracle
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0
export ORACLE_SID=you_great_SID

Relogin for the changes to take effect.


OS Version

Pretend that you are somebody else in /etc/redhat-release:

Red Hat Enterprise Linux ES release 4 (Nahant Update 6)

GUI Installer

gunzip 10201_database_linux_x86_64.cpio.gz
cpio -idvm < 10201_database_linux_x86_64.cpio
rm 10201_database_linux_x86_64.cpio.gz
cd database
./runInstaller

Choose Advanced Installation, go with Enterprise Edition, you can let it create general purpose database.

Post Installation

You can login as SYSDBA, create a user and grant them some privileges.

CREATE USER myuser IDENTIFIED BY password DEFAULT TABLESPACE users;
GRANT ALL PRIVILEGES TO myuser;

Created on: May 14, 2009 4:49 AM by Martin Vecera - Last Modified:  May 14, 2009 9:34 AM by Martin Vecera

Tuesday, August 25, 2009

PowerBuilder NET 12

Published by CybTech at 8:25 AM

PowerBuilder .NET - Skins and PowerBuilder

Published by CybTech at 8:15 AM

Watch TV - Live online internet televisionAccess to 4000 live TV stations from your pc. No need of a TV tuner or decoder. 100% legal - no subscription needed.

Watch television channels online anywhere. All you need is our software, your pc, and Internet connection. Thousands of television shows that would cost you big money in the long run with traditional TV providers, now can watch them with no subscription. Watch 4000 TV Stations from Over 80 Countries!

Cartoons, Fashion, News, Discovery, Sport, Movies, Music, Football, Adult Shows, Weather, Stocks, Educational, and many others channels are available.

You can watch TV to your PC or laptop at any time and anywhere in the world since our service is not affected by regional terrain or weather.

This webtv software does not contain any spyware or advertise modules. It has safety installation with NO WORRIES concerning valuable information loss.

WATCH TV NOW. LIMITED TIME OFFER.