如果你的linux系统是32bit的,则需要安装以下包: binutils-2.17.50.0.6 ok compat-libstdc++-33-3.2.3 ok elfutils-libelf-0.125 ok elfutils-libelf-devel-0.125 -- elfutils-libelf-devel-static-0.125 -- gcc-4.1.2 ok gcc-c++-4.1.2 ok glibc-2.5-24 ok glibc-common-2.5 ok glibc-devel-2.5 ok glibc-headers-2.5 ok kernel-headers-2.6.18 ok ksh-20060214 ok libaio-0.3.106 ok libaio-devel-0.3.106 -- libgcc-4.1.2 ok libgomp-4.1.2 ok libstdc++-4.1.2 ok libstdc++-devel-4.1.2 ok make-3.81 ok numactl-devel-0.9.8.i386 -- sysstat-7.0.2 -- unixODBC-2.2.11 -- unixODBC-devel-2.2.11 -- 使用 rpm -qa | grep 名字来检查上面列出的包是否已安装。 如: rpm -qa|grep gcc (不用跟版本号) ================================================== 创建用户: 先创建两个组: groupadd oinstall groupadd dba 添加一个oracle用户, 根目录是 /u01/oracle, 主组是 oinstall ,副组是dba 执行下面的语句时,不需要手动创建/u01/oracle,因为它会自动地创建。 useradd -g oinstall -G dba -d /u01/oracle oraclecp /etc/skel/.bash_profile /u01/oracle cp /etc/skel/.bashrc /u01/oracle cp /etc/skel/.bash_logout /u01/oracle 为oracle用户设置密码 passwd oracle 转到根目录: cd/ ls -l chown -R oracle:oinstall u01(修改文件夹的属主) ls -l 检查 nobody 是否存在 , id nobody 缺省存在的。如果不存在 /usr/sbin/useradd -g nobody ======================================== vim /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 536870912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586 ------------- vim /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 ------------ vim /etc/pam.d/login session required pam_limits.so =================================================
设置oracle 用户环境变量 su oracle pwd ls -la ------------------------- vim /u01/oracle/.bashrc //vim /u01/oracle/.bash_profile //vim /u01/oracle/.bash_logout ORACLE_UNQNAME=wilson ORACLE_BASE=/u01/app ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1/ ORACLE_SID=wilsonexport ORACLE_UNQNAME ORACLE_BASE ORACLE_HOME ORACLE_SID 中间用空格分隔 ------------------------ if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs ORACLE_UNQNAME=wilson ORACLE_BASE=/u01/app ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1/ ORACLE_SID=wilson NLS_LANG=AMERICAN_AMERICA.UTF8 PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin PATH=$PATH:/u01/app/oracle/product/11.2.0/dbhome_1/bin export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH ORACLE_UNQNAME NLS_LANG __________________________________________________________________________ --------------- vim .bash_profile ORACLE_BASE=/u01 ORACLE_HOME=$ORACLE_BASE/oracle ORACLE_SID=wilson PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin NLS_LANG=AMERICAN_AMERICA.UTF8 export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_LANG =================================== database 是oracle的安装文件。 mv database /u01/ 移动文件夹 su root 转换用户 cd /u01 ls -l chown -R oracle:oinstall database/ 修改文件的所属者 使用oracle账号 登陆图形界面 进行安装 运行终端 Terminal 安装之前,必须先运行如下命令: [root@localhost ~]# xhost local:oracle non-network local connections being added to access control list non-network local connections being added to access control list xhost: bad hostname "non-network" xhost: bad hostname "local" xhost: bad hostname "connections" xhost: bad hostname "being" xhost: bad hostname "added" xhost: bad hostname "to" xhost: bad hostname "access" xhost: bad hostname "control" xhost: bad hostname "list" ==================================== cd /u01/database 安装前,切换用户为oracle :su oracle ./runInstaller Installation Optiong install database software only Grid Options Single instance database installation Product Languages English Database Edition Enterprise Edition (3.95) Installation Location Oracle Base: /u01 Software Loacation: /u01/oracle 提示: yes Create Inventory mkdir /oraInventory chown -R oracle:oinstall oraInventory Operating System Groups Next Prerequis ite Checks Ignore All Summary Finish Install Product 安装完毕, 提示执行 2个脚本 sh /oraInventory/orainstRoot.sh sh /u01/oracle/root.sh 直接按回车, 缺省值就可以 Finish The installation of Oracle Database was successful
su oracle [oracle@localhost bin]$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/ netca[oracle@localhost bin]$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/ dbca上面只是安装了软件, 数据库没有创建, 还有配置 监听器 Listener netca 一直默认下一步 , 呵呵, 最后 Finish ps -ef 可以查看Listener是否配置成功 ----------- dbca 一直 Next, Global Database Name 和 SID 都是输入 wilson 选择 User the Same.....All Accounts 密码: 123456 选择 Sample Schemas Memory 内存分配,默认就可以了 Character Sets 选择 Use Unicode(AL32UTF8) 然后一直 Next , 到最后 Finish 弹出一个 Confirmation , 点击 OK 就可以了, 然后自动进行安装 安装到目录 /u01/oradata/wilson /u01/等等 会发现多了很多文件。 ---------------------------- /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca -------------------- 然后可以修改 vi /etc/inittab 让 centos5.5 linux 启动的时候 不进入 图形界面 直接进入 字符界面 id:5:initdefault: 修改成 id:3:initdefault: 保存退出, 然后重启系统 -------------------------------- 用 oracle 用户 远程登录, 然后 sqlplus /nolog SQL> conn / as sysdba Connected to an idle instance. 出现错误 SQL> startup SQL> conn / as sysdba Connected. SQL> create table testUser( id integer,name char(10)); Table created. SQL> insert into testUser values(0,'Jack'); 1 row created. SQL> commit; Commit complete. SQL> select * from testUser; ID NAME ---------- ---------- 0 Jack 关闭数据库 SQL> shutdown immediate SQL> quitORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_HOME su oracle(一定要切换为oracle用户,不要使用root用户) sqlplus /nolog conn / as sysdba startup 运行结果如下: ORACLE instance started.Total System Global Area 234344448 bytes Fixed Size 1335696 bytes Variable Size 155192944 bytes Database Buffers 75497472 bytes Redo Buffers 2318336 bytes Database mounted. Database opened.
楼主,你真牛,我连图形界面都没进去,你是在什么版本的linux上呀?本人在redhat Linux9下安装oracle10g报错Error in writing to directory,帖子链接 http://topic.csdn.net/u/20120307/20/d2f5217f-8e5d-4497-a7dc-00066a9cbe52.html 请楼主指教。
binutils-2.17.50.0.6 ok
compat-libstdc++-33-3.2.3 ok
elfutils-libelf-0.125 ok
elfutils-libelf-devel-0.125 --
elfutils-libelf-devel-static-0.125 --
gcc-4.1.2 ok
gcc-c++-4.1.2 ok
glibc-2.5-24 ok
glibc-common-2.5 ok
glibc-devel-2.5 ok
glibc-headers-2.5 ok
kernel-headers-2.6.18 ok
ksh-20060214 ok
libaio-0.3.106 ok
libaio-devel-0.3.106 --
libgcc-4.1.2 ok
libgomp-4.1.2 ok
libstdc++-4.1.2 ok
libstdc++-devel-4.1.2 ok
make-3.81 ok
numactl-devel-0.9.8.i386 --
sysstat-7.0.2 --
unixODBC-2.2.11 --
unixODBC-devel-2.2.11 --
使用 rpm -qa | grep 名字来检查上面列出的包是否已安装。
如: rpm -qa|grep gcc (不用跟版本号)
==================================================
创建用户:
先创建两个组:
groupadd oinstall
groupadd dba
添加一个oracle用户, 根目录是 /u01/oracle, 主组是 oinstall ,副组是dba
执行下面的语句时,不需要手动创建/u01/oracle,因为它会自动地创建。
useradd -g oinstall -G dba -d /u01/oracle oraclecp /etc/skel/.bash_profile /u01/oracle
cp /etc/skel/.bashrc /u01/oracle
cp /etc/skel/.bash_logout /u01/oracle
为oracle用户设置密码
passwd oracle
转到根目录: cd/
ls -l
chown -R oracle:oinstall u01(修改文件夹的属主)
ls -l
检查 nobody 是否存在 , id nobody
缺省存在的。如果不存在 /usr/sbin/useradd -g nobody
========================================
vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
-------------
vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
------------
vim /etc/pam.d/login
session required pam_limits.so
=================================================
设置oracle 用户环境变量
su oracle
pwd
ls -la
-------------------------
vim /u01/oracle/.bashrc
//vim /u01/oracle/.bash_profile
//vim /u01/oracle/.bash_logout
ORACLE_UNQNAME=wilson
ORACLE_BASE=/u01/app
ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1/
ORACLE_SID=wilsonexport ORACLE_UNQNAME ORACLE_BASE ORACLE_HOME ORACLE_SID
中间用空格分隔
------------------------
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_UNQNAME=wilson
ORACLE_BASE=/u01/app
ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1/
ORACLE_SID=wilson
NLS_LANG=AMERICAN_AMERICA.UTF8
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin
PATH=$PATH:/u01/app/oracle/product/11.2.0/dbhome_1/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH ORACLE_UNQNAME NLS_LANG
__________________________________________________________________________
---------------
vim .bash_profile
ORACLE_BASE=/u01
ORACLE_HOME=$ORACLE_BASE/oracle
ORACLE_SID=wilson
PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
NLS_LANG=AMERICAN_AMERICA.UTF8
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH NLS_LANG
===================================
database 是oracle的安装文件。
mv database /u01/ 移动文件夹
su root 转换用户
cd /u01
ls -l
chown -R oracle:oinstall database/ 修改文件的所属者
使用oracle账号 登陆图形界面 进行安装
运行终端 Terminal
安装之前,必须先运行如下命令:
[root@localhost ~]# xhost local:oracle non-network local connections being added to access control list
non-network local connections being added to access control list
xhost: bad hostname "non-network"
xhost: bad hostname "local"
xhost: bad hostname "connections"
xhost: bad hostname "being"
xhost: bad hostname "added"
xhost: bad hostname "to"
xhost: bad hostname "access"
xhost: bad hostname "control"
xhost: bad hostname "list"
====================================
cd /u01/database
安装前,切换用户为oracle :su oracle
./runInstaller
Installation Optiong
install database software only
Grid Options
Single instance database installation
Product Languages
English
Database Edition
Enterprise Edition (3.95)
Installation Location
Oracle Base: /u01
Software Loacation: /u01/oracle
提示: yes
Create Inventory
mkdir /oraInventory
chown -R oracle:oinstall oraInventory
Operating System Groups
Next
Prerequis ite Checks
Ignore All
Summary
Finish
Install Product
安装完毕, 提示执行 2个脚本
sh /oraInventory/orainstRoot.sh
sh /u01/oracle/root.sh
直接按回车, 缺省值就可以
Finish
The installation of Oracle Database was successful
su oracle
[oracle@localhost bin]$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/ netca[oracle@localhost bin]$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/ dbca上面只是安装了软件, 数据库没有创建, 还有配置 监听器 Listener
netca
一直默认下一步 , 呵呵, 最后 Finish
ps -ef 可以查看Listener是否配置成功
-----------
dbca
一直 Next, Global Database Name 和 SID 都是输入 wilson
选择 User the Same.....All Accounts
密码: 123456 选择 Sample Schemas
Memory 内存分配,默认就可以了
Character Sets 选择 Use Unicode(AL32UTF8)
然后一直 Next , 到最后 Finish
弹出一个 Confirmation , 点击 OK 就可以了, 然后自动进行安装
安装到目录 /u01/oradata/wilson
/u01/等等 会发现多了很多文件。
----------------------------
/u01/app/oracle/product/11.2.0/dbhome_1/bin/dbca
--------------------
然后可以修改 vi /etc/inittab 让 centos5.5 linux 启动的时候 不进入 图形界面
直接进入 字符界面
id:5:initdefault: 修改成 id:3:initdefault:
保存退出, 然后重启系统
--------------------------------
用 oracle 用户 远程登录, 然后
sqlplus /nolog
SQL> conn / as sysdba
Connected to an idle instance.
出现错误
SQL> startup
SQL> conn / as sysdba
Connected.
SQL> create table testUser( id integer,name char(10));
Table created.
SQL> insert into testUser values(0,'Jack');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from testUser;
ID NAME
---------- ----------
0 Jack
关闭数据库
SQL> shutdown immediate
SQL> quitORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_HOME
su oracle(一定要切换为oracle用户,不要使用root用户)
sqlplus /nolog
conn / as sysdba
startup
运行结果如下:
ORACLE instance started.Total System Global Area 234344448 bytes
Fixed Size 1335696 bytes
Variable Size 155192944 bytes
Database Buffers 75497472 bytes
Redo Buffers 2318336 bytes
Database mounted.
Database opened.