groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle
su - oracle
ls -a
vi .profile
export ORACLE_SID=JAVA1
export ORACLE_BASE=/home/oracle/product/10.2.0
export ORACLE_HOME=$ORACLE_BASE/db_1
export PATH=$ORACLE_HOME/bin:.:$PATH

su - root
su - oracle
echo $ORACLE_SID

su - root

mkdir /cdrom

mount /dev/hdc /cdrom

cd /cdrom/Server

rpm -ivh 
gcc-4.1.2-44.el5.i386.rpm  
glibc-devel-2.5-34.i386.rpm  
libgomp-4.3.2-7.el5.i386.rpm  
glibc-headers-2.5-34.i386.rpm  
kernel-headers-2.6.18-128.el5.i386.rpm 

rpm -ivh ncurses-devel-5.5-24.20060715.i386.rpm

terminal: root oracle

root: xhost +
oracle: export DISPLAY=:0
export LANG=en


xclock

init 0 

root:
cd /cdrom/Server
 rpm -ivh libXp-1.0.0-8.1.el5.i386.rpm 


su - oracle
sqlplus / as sysdba


su - oracle
vi .bash_profile
export ORACLE_SID=orcl



sqlplus / as sysdba
create user user1 identified by abc;
grant connect, resource to user1;
conn user1/abc
create table t1
(
id int
);
insert into t1 values (1);
select * from t1;
create table t2
(
id int,
name varchar2(30)
);
insert into t2 values (1,'a');
insert into t2 values (2,'b');
insert into t2 values (3,'c');
select * from t2;
update t2 set name = 'bb' where id = 2;
select * from t2;
delete from t2 where id = 2;
select * from t2;