在Ubuntu上配置Oracle数据库可以通过多种方法实现,包括手动安装和使用Docker容器。以下是详细的步骤:
sudo apt-get update
sudo apt-get install docker.io
docker pull store/oracle/database-enterprise:12.2.0.1
docker run -d --name oracle-db -p 1521:1521 -p 5500:5500 store/oracle/database-enterprise:12.2.0.1
sudo apt update
sudo apt install alien libaio1 unixodbc build-essential
下载Oracle数据库安装包: 访问Oracle官方网站并下载适用于Linux的Oracle数据库安装包,并解压到指定目录。
创建Oracle用户和组:
sudo groupadd oinstall
sudo groupadd dba
sudo useradd -g oinstall -G dba -d /home/db01 -s /bin/bash db01
sudo passwd db01
~/.bashrc文件,添加以下内容:export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_SID=orcl
使配置生效:
source ~/.bashrc
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
sudo mkdir -p /u01/app/oracle/oradata
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/control01.ctl
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo01.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo02.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo03.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo04.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo05.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo06.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo07.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo08.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo09.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo10.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo11.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo12.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo13.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo14.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo15.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo16.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo17.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo18.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo19.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo20.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo21.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo22.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo23.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo24.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo25.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo26.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo27.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo28.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo29.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo30.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo31.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo32.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo33.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo34.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo35.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo36.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo37.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo38.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo39.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo40.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1/oradata/redo41.log
sudo mkdir -p /u01/app/oracle/product/19.0.0/dbhome_