一堆废话,一堆废话,一堆废话,一堆废话,一堆废话,一堆废话,一堆废话,一堆废话,废话少说,开干
一、Oracle操作
1、docker拉取oracle镜像
docker pull registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c
2、 创建挂载文件
mkdir -p /home/oracle/oradata
3、启动Oracle
docker run -d \
-p 1524:1521 -p 5502:5500 \
-e ORACLE_SID=ORCLCDB \
-e ORACLE_PDB=ORCLPDB1 \
-e ORACLE_PWD=123456 \
-e ORACLE_EDITION=standard \
-e ORACLE_CHARACTERSET=AL32UTF8 \
-v /mydata/oracle/oradata:/home/oracle/oradata \
--name oracle \
registry.cn-hangzhou.aliyuncs.com/zhuyijun/oracle:19c
4、进入Oracle容器
docker exec -it oracle bash
#配置环境变量
export ORACLE_HOME=/home/oracle/product/11.2.0/dbhome_2
export PATH=$ORACLE_HOME/bin:$PATH;
#刷新环境变量
source /etc/profile
#启动监听器
lsnrctl start
lsnrctl status
#查找服务名,找到tnsnames.ora
find / -name tnsnames.ora
5、用超级管理角色登录,一般都会报错
sqlplus / as sysdba
shutdown immediate; --关闭数据库
# 启动数据库mount
startup mount
# 启动数据库
alter database open;
# 修改数据库
ALTER DATABASE CHARACTER SET ZHS16GBK;
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
# 重新启动数据库
shutdown immediate;
startup; --启动数据库
#修改密码
select * from dba_users;
alter user system identified by system;
alter user sys identified by system;
exit;
6、其他指令,用的上就用
conn /as sysdba
#创建内部管理员账号密码,账号test前要加c##,不然无法创建;
create user c##test identified by test;
grant connect,resource,dba to test; --将dba权限授权给内部管理员账号和密码;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; --修改密码规则策略为密码永不过期;
alter system set processes=1000 scope=spfile; --修改数据库最大连接数据;
二、Mysql
1、下载mysql到Linux中/home/mysql中
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
2、解压mysql
tar xvJf mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
3、重命名文件夹
mv mysql-8.0.20-linux-glibc2.12-x86_64 /usr/local/mysql-8.0.20
4、创建data文件夹 存储文件
mkdir -p /data/mysql
#创建用户组以及用户和密码
groupadd mysql
useradd -g mysql mysql
5、修改mysql配置文件(若没有则新建)
vim /etc/my.cnf
#文件内容
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql-8.0.20/
datadir=/data/mysql
/usr/local/mysql-8.0.20/socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#skip-grant-tables
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
lower_case_table_names=1
6、查看mysql密码
cat /data/mysql/mysql.err
7、mysql.server放置到/etc/init.d/mysql中
cp /usr/local/mysql-8.0.20/support-files/mysql.server /etc/init.d/mysql
8、启动mysql
service mysql start
9、如果datadir目录改了,要重新进入mysql的bin文件下,重新初始化并启动MySQL
cd /usr/local/mysql-8.0.20/bin
#初始化
./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-8.0.20/ --datadir=/var/lib/mysql/ --user=mysql --initialize