在centos7虚拟机上安装docker oracle11g

简介: 在centos7虚拟机上安装docker oracle11g

docker pull registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g

docker 下载oracle11g

docker run -d -p 1521:1521 --name oracle11g registry.cn-hangzhou.aliyuncs.com/helowin/oracle_11g
docker exec -it oracle11g bash
[oracle@fed9e5bdd51d /]$ sqlplus /nolog
bash: sqlplus: command not found 不可用
su root

输入密码helowin

vi /etc/profile 并在文件最后添加如下命令
export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=helowin
export PATH=$ORACLE_HOME/bin:$PATH
ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
切换到oracle 用户 就可以sqlplus /nolog 了

2.118修改了系统密码如下:

alter user system identified by estar2022;
alter user sys identified by estar2022;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

增加jeecgboot用户

SQL> create user jeecgboot identified by estar20220308;
User created.
SQL> grant connect,resource,dba to jeecgboot;
Grant succeeded.
SQL>

下面主要是修改字体

shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2213776 bytes
Variable Size 402655344 bytes
Database Buffers 1191182336 bytes
Redo Buffers 7360512 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered.
SQL> alter database open;
Database altered.
SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
Database altered.
SQL> select * from v$nls_parameters;

另外客户端tnsnames.ora增加下面一项

oracle11g-118 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.118)(PORT = 1521))
(CONNECT_DATA = (SID = helowin))
)
相关文章
|
1天前
|
Linux Docker 容器
rpm 降级安装 Docker
【6月更文挑战第17天】rpm 降级安装 Docker
11 2
|
4天前
|
Docker 容器
CentOS7.3 安装 docker
CentOS7.3 安装 docker
18 0
|
4天前
|
NoSQL MongoDB Docker
windows下基于docker安装mongodb
windows下基于docker安装mongodb
7 1
|
4天前
|
Linux Docker Windows
windows10安装docker报错【已解决】
windows10安装docker报错【已解决】
19 0
|
13天前
|
关系型数据库 应用服务中间件 nginx
docker基础,docker安装mysql,docker安装Nginx,docker安装mq,docker基础命令
docker基础,docker安装mysql,docker安装Nginx,docker安装mq,docker基础命令
|
13天前
|
Ubuntu Linux Docker
windows 安装docker 安装Ubuntu linux
windows 安装docker 安装Ubuntu linux
|
13天前
|
Ubuntu Docker 容器
ubuntu 通过docker方式安装clouddrive2
ubuntu 通过docker方式安装clouddrive2
|
13天前
|
应用服务中间件 Shell nginx
mac m1笔记本docker 安装nginx
mac m1笔记本docker 安装nginx
|
13天前
|
Docker 容器
docker 安装cloudreve
docker 安装cloudreve
|
13天前
|
Ubuntu 关系型数据库 MySQL
docker 安装最新mysql
docker 安装最新mysql