docker 安装Oracle12 (absolutapps/oracle-12c-ee )（无废话版）---------------（六）

妖狐艹你老母 2023-07-01 05:26 13阅读 0赞

1.下载

docker pull absolutapps/oracle-12c-ee

如果官方没有这个镜像了可以下载我的，我上传上去了：

docker pull heidaodageshiwo/oracle-12c-ee:latest

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70][]

2.查看是否下载

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 1][]

3.启动（你们只需要修改8066这个端口即可）

创建一个文件夹来挂载数据

mkdir -p /var/oracle

启动（ad9bdfc002e7这个是我的镜像的imageid）上图可见

docker run -d -p 8080:8080 -p 8066:1521 -v /var/oracle:/u01/app/oracle --privileged  ad9bdfc002e7

是否启动

docker logs -f 6fea41c62a884314c0ac3ceb385eba5a88e5fc5ad69d44791714dbf4baa2965d

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 2][]

启动截图日志：（docker logs -f 可能会很慢，但一定要看，要不然不知道是否启动）

中间可能会遇到  /dev/shm 挂载盘的问题，可自行百度一下

[root@iz2zej4i2jdf3i8bhr61xsz oracle]# docker run -d -p 8080:8080 -p 8066:1521 -v /var/oracle:/u01/app/oracle --privileged  ad9bdfc002e7
    6fea41c62a884314c0ac3ceb385eba5a88e5fc5ad69d44791714dbf4baa2965d
    [root@iz2zej4i2jdf3i8bhr61xsz oracle]# docker logs -f 6fea41c62a884314c0ac3ceb385eba5a88e5fc5ad69d44791714dbf4baa2965d
    ls: cannot access /u01/app/oracle/oradata/orcl: No such file or directory
    No databases found in /u01/app/oracle/oradata/orcl. About to create a new database instance
    Starting database listener
    
    LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 19-JAN-2020 02:24:27
    
    Copyright (c) 1991, 2014, Oracle.  All rights reserved.
    
    Starting /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr: please wait...
    
    TNSLSNR for Linux: Version 12.1.0.2.0 - Production
    System parameter file is /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
    Log messages written to /u01/app/oracle/diag/tnslsnr/6fea41c62a88/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=6fea41c62a88)(PORT=1521)))
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=6fea41c62a88)(PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
    Start Date                19-JAN-2020 02:24:27
    Uptime                    0 days 0 hr. 0 min. 0 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora
    Listener Log File         /u01/app/oracle/diag/tnslsnr/6fea41c62a88/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=6fea41c62a88)(PORT=1521)))
    The listener supports no services
    The command completed successfully
    Copying database files
    1% complete
    3% complete
    11% complete
    18% complete
    26% complete
    37% complete
    Creating and starting Oracle instance
    40% complete
    45% complete
    50% complete
    55% complete
    56% complete
    60% complete
    62% complete
    Completing Database Creation
    66% complete
    70% complete
    73% complete
    85% complete
    96% complete
    100% complete
    Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
    
    LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 19-JAN-2020 02:29:40
    
    Copyright (c) 1991, 2014, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=6fea41c62a88)(PORT=1521)))
    The command completed successfully
    Database has been created in /u01/app/oracle/oradata/orcl
    SYS and SYSTEM passwords are set to [oracle]
    Setting HTTP port to 8080
    
    PL/SQL procedure successfully completed.
    
    Please login to http://<ip_address>:8080/em to use enterprise manager
    User: sys; Password oracle; Sysdba: true
    Fixing permissions...
    Running init scripts...
    Init scripts in /oracle.init.d/: Ignoring /oracle.init.d/*
    
    Done with scripts we are ready to go

查看container状态

![20200119140247759.png][]

进入刚刚创建的container中

docker exec -it 6fea41c62a88 /bin/bash 进入

su oracle 切到oracle

$ORACLE\_HOME/bin/sqlplus / as sysdba 使用sysdba登录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 3][]

修改密码：  
alter user system identified by oracle;  
alter user sys identified by sys;  
ALTER PROFILE DEFAULT LIMIT PASSWORD\_LIFE\_TIME UNLIMITED;  
创建用户  
create user test identified by test;  
并给用户赋予权限  
grant connect,resource,dba to test;

[root@iz2zej4i2jdf3i8bhr61xsz ~]# docker exec -it 6fea41c62a88 /bin/bash
    [root@6fea41c62a88 /]# su oracle
    [oracle@6fea41c62a88 /]$ $ORACLE_HOME/bin/sqlplus / as sysdba
    
    SQL*Plus: Release 12.1.0.2.0 Production on Sun Jan 19 05:20:04 2020
    
    Copyright (c) 1982, 2014, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
    
    SQL> conn system/oracle as sysdba;
    Connected.
    SQL>    alter user system identified by oracle;
    
    User altered.
    
    SQL>  alter user sys identified by sys;
    
    User altered.
    
    SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    
    Profile altered.
    
    SQL> create user test identified by test;
    
    User created.
    
    SQL> grant connect,resource,dba to test;
    
    Grant succeeded.

然后使用Navicat链接

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 4][]

![2020011914090082.png][]

点击TEST右键打开模式

我自己创建了一张表

![202001191411073.png][]

![20200119141136205.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 5][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 6][]

### 4年了没有用oracle了不知道为啥登录上来就是一个TEST ###

### 而且oracle这块 表空间还有用户这块都忘了。  不清楚咋回事了只能用到的时候再看了。。。。。。。。。。。。 ###

### 如有不明白的可以一块交流 ###

### ![20200119141256104.png][] ###

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/2020011914462037.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200119135348210.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/202001191357134.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl,size_16,color_FFFFFF,t_70
[20200119140247759.png]: https://img-blog.csdnimg.cn/20200119140247759.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200119140455792.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/202001191407565.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl,size_16,color_FFFFFF,t_70
[2020011914090082.png]: https://img-blog.csdnimg.cn/2020011914090082.png
[202001191411073.png]: https://img-blog.csdnimg.cn/202001191411073.png
[20200119141136205.png]: https://img-blog.csdnimg.cn/20200119141136205.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20200119141220141.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20200119141204888.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1bmhlaWRhb2Rl,size_16,color_FFFFFF,t_70
[20200119141256104.png]: https://img-blog.csdnimg.cn/20200119141256104.png