Oracle Database (简体中文)

From ArchWiki
Jump to navigation Jump to search

Tango-view-refresh-red.pngThis article or section is out of date.Tango-view-refresh-red.png

Reason: please use the first argument of the template to provide a brief explanation. (Discuss in Talk:Oracle Database (简体中文))


这份文档将会帮助您把Oracle数据库11gR1安装到Arch Linux。使用安装方法2,您可以仅仅通过几个步骤完成长时间的安装过程。

安装方法1 - 手动

这节将会引导您在全新的archlinux上安装Oracle。这是一个通用的方法,在内核2.6.28.ARCH 64位机器上安装Oracle 11g R1 64 位测试通过。这在其他版本的Orale上也应该可以工作



# pacman -Syu
# pacman -S python
# pacman -U


# pacman -S xorg
# pacman -S hwd

尽管从Xorg 7.4后,xorg.conf 不再需要。这命令是可选的。

# hwd -x
# cp /etc/X11/xorg.conf.vesa /etc/X11/xorg.conf

使用startx检查(Should get mouse movement with X cursor - Ctrl-Alt-Backspace to exit.)

$ startx

安装桌面环境,Gnome,KDE 或 Xfce。这个例子假设Xfce4将被安装:

# pacman -S xfce4
# pacman -S pcmanfm

运行 xfce:

$ startxfce4


安装 软件包 unzip sudo base-devel icu gawk gdb elfutils sysstat libstdc++5.

安装 Java 运行时环境,例如 jre7-openjdkjdk7-openjdk.

安装ksh (problem with aurbuild -s ksh).

mkdir -p ABS/ksh
cd ABS/ksh
chmod 777 -R /software
wget --http-user "I accept" --http-password "."[失效链接 2020-08-04 ⓘ]
wget --http-user "I accept" --http-password "."[失效链接 2020-08-04 ⓘ]
wget[失效链接 2020-08-04 ⓘ]
wget[失效链接 2020-08-04 ⓘ]
makepkg -c --asroot
makepkg -i --asroot
pacman -S icu
aurbuild -s beecrypt
aurbuild -s rpm
pacman -S gawk
pacman -S gdb
aurbuild -s libaio
pacman -S libelf
pacman -S sysstat
pacman -S libstdc++5


# pacman -S unixodbc

可选的lib32 软件包 x86_64:

# pacman -S lib32-libstdc++5 
# pacman -S lib32-glibc 
# pacman -S lib32-gcc-libs


Oracle Universal Installer需要的一些软链接。

# ln -s /usr/bin/rpm /bin/rpm
# ln -s /usr/bin/ksh /bin/ksh
# ln -s /bin/awk /usr/bin/awk
# ln -s /bin/tr /usr/bin/tr
# ln -s /usr/bin/basename /bin/basename

Arch x86_64:

# ln -s /usr/lib /usr/lib64



# groupadd oinstall
# groupadd dba
# useradd -m -g oinstall -G dba oracle


# passwd oracle

可选: Add oracle to the sshd_config file.

# pacman -S openssh

Add this line to /etc/ssh/sshd_config:

AllowUsers oracle

Add oracle to /etc/sudoers. This will give oracle super user privilege.

oracle    ALL=(ALL) ALL

Add these lines to /etc/sysctl.d/99-sysctl.conf (Review Oracle documentation to adjust these settings).

# oracle kernel settings
fs.file-max = 6553600
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144

Add these lines to /etc/security/limits.conf (Review Oracle documentation to adjust these settings)

# oracle settings
oracle           soft    nproc   2047
oracle           hard    nproc   16384
oracle           soft    nofile  1024
oracle           hard    nofile  65536

可选: 想使变化生效您可以重启电脑。


mkdir -p /oracle
mkdir -p /oracle/inventory
mkdir -p /oracle/recovery
mkdir -p /oracle/product/db


chown -R oracle:dba /oracle
chmod 777 /tmp

Create or update oracle bashrc /home/oracle/.bashrc. Here is an example of the oracle user settings.

export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/db
export ORACLE_SID=xdb
export ORACLE_INVENTORY=/oracle/inventory
export EDITOR=nano
export VISUAL=nano





Arch i686:

unzip -d /media

Arch x86_64:

unzip -d /media

可选: Arch x86_64 (only required if the installer will not launch automatically ... at the time of this writing there was an issue with the packaged unzip in the 64-bit Oracle installer):

cd /media/database/install
mv unzip unzipx
ln -s /usr/bin/unzip 

Change the permissions for the extracted Oracle database.

chmod -R 777 /media/database
chown -R oracle:oinstall /media/database

Enter the directory where you extracted the Oracle database.

In oder to run oracle installation script you need to export the X display as a normal user:

DISPLAY=:0.0; export DISPLAY; xhost +

Login as the user oracle and export the X display:

su oracle
DISPLAY=:0.0; export DISPLAY

Enter the database directory and run the Oracle Universal Installer as the user oracle.

cd /media/database
./runInstaller -ignoreSysPrereqs


  1. Click on "Next".
  2. Choose "Enterprise Edition" Installation Type and click on "Next"
  3. Oracle Base should be: /oracle. Do not change it, unless you know what you are doing.
    1. Change the default "Name" to orarch or something else.
    2. The predefined path in /etc/rc.d/oracledb is "db", ie: /oracle/product/db. If you want to use a different path you will have to change /etc/rc.d/oracledb, so that the startup script can locate ORACLE_HOME directory.
    3. After changing the defaults, click on "Next".
  4. Since Oracle database requires certain distro requirement, you will have to manually check them and then click on "Next".
  5. Chose "Software Install Only" and click on "Next".
  6. There is only one DBA group for oracle database. Click on "Next".
  7. Install "Summary" shows what's going to be installed. Click on "Install".
  8. The installation will take some time, especially the "Linking" part. Be patient! If you get an error message ignore it by clicking on "Continue".
    1. At the end of the installation you will have to open another terminal, and execute /oracle/product/db/ as root. Do not click on "OK" yet.
    2. When running, you will be offered to use /usr/local/bin as the full pathname. Press the "Enter" key here.
    3. Now you can click on "OK"
  9. Installation is finished, click on "Exit" and "Yes", you really want to exit.


This section describes how to install the web based OEM available in 10g+.

Depending on your settings the OUI may have already installed this.

Login or su to oracle, then run the following commands (answering the prompts approriately). This may take a while.

cd ${ORACLE_HOME}/bin
./emca -repos create
./emca -config dbcontrol db

Test this out by navigating to the enterprise manager (adjust the servername (localhost) apporpriately).


You can control OEM with the following commands.

emctl status dbconsole
emctl stop dbconsole
emctl start dbconsole

安装方法2 - AUR


注意: 这种安装方法会自动创建数据库,因此,在安装完后,Orcale数据库就可以使用了。

第一步 从AUR里面下载Arch Linux 软件包:[失效链接 2020-08-04 ⓘ] 下载Oracle数据库11gR1:

第二步 解压Arch Linux 软件包到一个目录。同时把Oracle数据库11gR1复制到同一目录下。

信息:默认的安装配置 ee.rsp.patch是:


可选: You can either change the default password now or later after the installation. If you change the ee.rsp.patch file, you need to update the md5sums in the PKGBUILD file. To obtain the md5sum, run (makepkg -g) or:

md5sum ee.rsp.patch 


makepkg -s

Step 3. 安装已经创建好的软件包。

Arch i686:

pacman -U oracle-11gR1-1-i686.pkg.tar.gz 

Arch x86_64:

pacman -U oracle-11gR1-1-x86_64.pkg.tar.gz 

Pacman现在将安装Oracle数据库通过执行Oracle自己的安装脚本(./runInstaller -silent -ignoreSysPrereqs)。


Starting to execute configuration assistants
Configuration assistant "Oracle Net Configuration Assistant" succeeded 


The following configuration scripts need to be executed as the "root" user.
#Root script to run
To execute the configuration scripts:
   1. Open a terminal window
   2. Log in as "root"
   3. Run the scripts
The installation of Oracle Database 11g was successful.
Please check '/home/oracle/oraInventory/logs/silentInstall2009-03-03_07-24-10PM.log'
for more details.

第四步 以root身份运行这些脚本:

[ahc@archlinux ~]$ su
cd /home/oracle/oraInventory
cd /home/oracle/app/oracle/product/11.1.0/orarch

第五步 默认的Oracle用户是“oracle”。由于没有为用户oracle设置密码,您需要以root身份运行passwd:

passwd oracle

第六步 以用户oracle身份登录。

su oracle


export ORACLE_SID=archlinux
export ORACLE_HOME=/home/oracle/app/oracle/product/11.1.0/orarch

第七步 如果您没有改变 ee.rsp.patch文件,您需要为SYS和SYSTEM改变管理密码

注意: 如果数据库没有被挂载或者打开,以用户oracle身份登录然后首先尝试:
su oracle
sqlplus '/as sysdba'
SQL> startup mount;
SQL> alter database open; 


sqlplus '/as sysdba'
SQL> show user
SQL> passw system
Changing password for system
New password:
Retype new password:
Password changed
SQL> quit

SYS 用户更改密码:

sqlplus system/secretpassword
SQL> show user;
SQL> passw sys
Changing password for sys
New password: 
Retype new password: 
Password changed
SQL> quit

Post 安装



You have only installed the Oracle database software. Now you need to create a database. Login as the user oracle:

su oracle

Export the ORACLE_HOME binary directory:

export ORACLE_HOME=/oracle/product/db

Run database installation script:


During the graphical installation:

  1. Click on "Next".
  2. Check "Create a Database" and click on "Next".
  3. Check "General Purpose or Transaction Processing" and click on "Next".
  4. Chose a database name and SID. Example: Global Database Name: archlinux, SID: archlinux. And then click on "Next".
  5. Uncheck "Configure Enterprise Manager", leave it empty and click on "Next".
  6. Check "Use the Same Administrative Password for All Accounts", set password and click on "Next".
  7. Check "File System" and click on "Next".
  8. Check "Use Database File Locations from Template" and click on "Next".
  9. Uncheck "Specify Flash Recovery Area" and click on "Next".
  10. No need for "Sample Schemas", click on "Next".
  11. If you do not know what you are doing, check "Typical" and click on "Next"
  12. Check "Keep the enhanced 11g default security settings" and click on "Next".
  13. Uncheck "Enable automatic maintenance tasks" if you wish to do it by yourself and click on "Next".
  14. View your filesystem layout and click on "Next".
  15. "Create Database" is checked by default. Click on "Finish" to create database.
  16. Summary of following operations to be performed, click on "OK".
  17. When database creation is complete, click on "Exit".


This section walks you through doing a scripted initial database creation.

注意: The scripts assume they are the first database to be installed on this system. If this is not the case review the script and comment out the portions which deal with the *.ora files.

Download the following tar file with a set of scripted database installation scripts.


Extract the directory

tar xzf instanceCreateXdb.tgz

Move into instanceCreateXdb directory

cd instanceCreateXdb

File list

  • CreateDB.sql
  • CreateDBCatalog.sql
  • initxdb.dbs.ora
  • initxdb.ora
  • listener.ora
  • postDBCreation.sql
  • sqlnet.ora
  • sysObjects.sql
  • tnsnames.ora
  • xdb-create.sql

Script notes

  • the files assume a database sid of xdb
  • the files assume an oracle base of /oracle/product/db
  • review all memory and storage parameters against Oracle documentation

Setup filesystem (as root)


Install database from script (this will take a long time)

su oracle
sqlplus / as sysdba @/oracle/admin/xdb/scripts/xdb-create.sql


以用户oracle身份登录,然后运行 export ORACLE_SID="yourSID"等,:

export ORACLE_SID=xdb
export ORACLE_HOME=/oracle/product/db


ORACLE_SID = [xdb] ? 
The Oracle base for ORACLE_HOME=/oracle/product/db 
is /oracle


sqlplus '/as sysdba'
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;

ORACLE instance started.

Total System Global Area  385003520 bytes
Fixed Size		    1300100 bytes
Variable Size		  234883452 bytes
Database Buffers	  142606336 bytes
Redo Buffers		    6213632 bytes
Database mounted.
Database opened.

Type "quit" when you want to leave SQL prompt:

SQL> quit


If you want to start with your oracle SID, replace ":N" with ":Y" in /etc/oratab:

<your sid>:<oracle home>:N
<your sid>:<oracle home>:Y

Example from Scripted database creation (/etc/oratab):


To start the oracle database daemon during boot, add "oracledb" in your /etc/rc.conf:

DAEMONS=(oracledb syslog-ng dbus !network netfs crond ntpd alsa hal wicd fam)

Note: If the daemon does not start, please check that the ORACLE_HOME path matches your current oracle directory in /etc/rc.d/oracledb:

export ORACLE_HOME=/oracle/product/db
[oracle@archlinux orarch]$ pwd

Test starting the daemon as root:

/etc/rc.d/oracledb start
Starting Oracle: 
LSNRCTL for Linux: Version - Production on 27-FEB-2009 23:14:45
The command completed successfully
Processing Database instance "archlinux": log file 

Now you will login to your oracle database each time you reboot:

su oracle
export ORACLE_SID=xdb
sqlplus '/as sysdba'

Install Method 2:

su oracle
export ORACLE_SID=archlinux
sqlplus '/as sysdba'



gpasswd -a joe dba

dba组在您登出时然后登录进来才生效。用户oracle拥有oracle家目录的权限,如 /home/oracle:

drwx------ 6 oracle dba 4096 2009-02-27 23:27 oracle


chmod -R g+x /home/oracle


Transfer existing Oracle installation

Moving or transferring Oracle can be quite useful in the following conditions:

  • replacing hardware
  • setting up several dev machines
  • running lean system (no desktop manager, java, etc)

The installation of Oracle requires several packages. However, just running an Oracle database is much simpler and has far fewer requirements, as shown below.

In principle transferring Oracle should work across distros. Transferring from RHEL/Centos 5.2 to ARCH 2009.02 has been tested successfully.

To prep Oracle for a move shutdown database services

dbstop ${ORACLE_HOME}
lsnrctl stop

Optional: stop OEM if it is running

emctl stop dbconsole

If you are running other Oracle daemons stop them as well

This section assumes the following conditions about the existing Oracle installation:

  • oracle root is /oracle
  • oracle data is at /oracle/oradata/<sid>

Tar up entire Oracle installation and data.

cd /
tar czf oracle.tgz /oracle

Using ssh and sftp or your method of choice transfer oracle.tgz to the root (/) of the target system.

Login to target system as root and unpack the tar

cd /
tar xzf oracle.tgz
chmod 755 -R /oracle
chown -R oracle:dba /oracle

Update system

pacman -S pacman
pacman -Syu
pacman -S python
pacman -U
pacman -S unzip
pacman -S sudo

Install required package run Oracle database and required daemons.

aurbuild -s libaio
pacman -S sysstat

Configure server for oracle


Setup OEM (optional)

Oracle#Oracle Enterprise Manager installation (optional)[损坏的链接:无效的章节]

Execute appropriate/desired post installation steps


已知问题: The Oracle Universal Installer(ie, in silent mode) seems create errors when installing on other paths than "../app/oracle/..".


大部分的步骤是基于ubuntu用户的oracle安装向导,这篇文档包括一步一步的图形例子:[失效链接 2020-08-04 ⓘ]