在Ubuntu系统上使用Oracle数据库涉及多个步骤,包括安装、配置、管理和维护。以下是一个详细的教程大全,涵盖了从安装到高级管理的各个方面。
sudo apt-get update
sudo apt-get install apt-transport-https ca-certificates curl software-properties-common
curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add -
sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu $(lsb_release -cs) stable"
sudo apt-get update
sudo apt-get install docker-ce
sudo docker run hello-world
sudo usermod -a -G docker $USER
docker search oracle
docker run -d --name exeed-db -p 1521:1521 -p 8080:8080 --shm-size=1g --restart=always -e ORACLE_PWD=XXX -v exeed-db:/u01/app/oracle/oradata zerda/oracle-database:11.2.0.2-xe
wget http://old-releases.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio1_0.3.107-7ubuntu2_amd64.deb
wget http://old-releases.ubuntu.com/ubuntu/pool/main/liba/libaio/libaio-dev_0.3.107-7ubuntu2_amd64.deb
dpkg -i ./libaio1_0.3.107-7ubuntu2_amd64.deb
dpkg -i ./libaio-dev_0.3.107-7ubuntu2_amd64.deb
sudo groupadd dba
sudo useradd -g dba -d /home/db01 -s /bin/bash db01
~/.bashrc
文件,添加以下内容:export ORACLE_HOME=/opt/oracle/product/18c/dbhomeXE
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_SID=orcl
使更改生效:
source ~/.bashrc
sudo /etc/init.d/oracle-xe-18c configure
sudo systemctl start oracle-xe-18c
sudo systemctl status oracle-xe-18c
~/.bashrc
文件:nano ~/.bashrc
添加以下内容,替换your_oracle_home
为你的Oracle安装目录:
export ORACLE_HOME=your_oracle_home
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
保存并关闭文件,使更改生效:
source ~/.bashrc
验证环境变量是否已正确设置:
echo $ORACLE_HOME
echo $LD_LIBRARY_PATH
sqlplus sys as sysdba
创建用户并分配权限:
CREATE USER user_name IDENTIFIED BY password;
GRANT CONNECT, RESOURCE TO user_name;
listener.ora
:LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
创建TNSNAMES.ORA文件:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
启动监听器:
lsnrctl start
$ORACLE_BASE/diag/rdbms/dbname/instancename/trace/alter_instancename.log
Alert.log
和数据库进程的trace
日志都存放在相同目录下,例如$ORACLE_BASE/diag/rdbms/database_name/instance_name/trace/alter_instancename.log
。$GRID_HOME
目录下执行diagcollectin.sh
脚本,生成包含CRS日志信息的压缩包。ALTER DATABASE ARCHIVE LOG;
SELECT dest_name, status, destination FROM archive_dest;
ALTER SYSTEM ARCHIVE LOG ALL;
DELETE NOPROMPT ARCHIVE LOG ALL BACKED UP 1 TIMES TO DISK;
希望这些步骤能帮助你在Ubuntu系统上成功安装和管理Oracle数据库。如果在安装过程中遇到任何问题,建议参考Oracle的官方文档或联系专业的数据库管理员。