Oralce
<h1><center>Oralce</center></h1>
<p>搜索镜像</p>
<pre><code>docker search oralce</code></pre>
<p>拉取镜像</p>
<pre><code>docker pull oracleinanutshell/oracle-xe-11g </code></pre>
<p>(具体拉取哪个根据实际情况而定</p>
<p>启动镜像</p>
<pre><code>docker run -p 1521:1521 -e ORACLE_ALLOW_REMOTE=true --name oracle_11g -d --restart=always oracleinanutshell/oracle-xe-11g </code></pre>
<p>-d 后台运行 -p: 指定端口映射,格式为:主机(宿主)端口:容器端口</p>
<p>上面命令中 -e ORACLE_ALLOW_REMOTE=true 的作用是开启远程连接
自动启动镜像 --restart=always</p>
<p>设置用户信息</p>
<pre><code>docker exec -it oracle_11g /bin/bash</code></pre>
<p>使用普通身份登入</p>
<pre><code> sqlplus system/oracle
</code></pre>
<p>创建数据库 及用户
<a href="https://www.jianshu.com/p/9589a29f9705">https://www.jianshu.com/p/9589a29f9705</a></p>
<pre><code>CREATE TABLESPACE nutz LOGGING DATAFILE '/mnt/nutz.dbf' SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL;
create temporary tablespace nutz_temp tempfile '/mnt/nutz_temp.dbf' size 100m autoextend on next 32m maxsize 500m extent management local;
CREATE USER nutz IDENTIFIED BY ruoyinutz DEFAULT TABLESPACE nutz TEMPORARY TABLESPACE nutz_temp;
grant connect,resource,dba to nutz ;
grant create session to nutz ;
commit;</code></pre>
<p>创建用户并分配权限</p>
<pre><code>查看用户</code></pre>
<pre><code>select username,password from dba_users;
</code></pre>
<p>创建用户:用户名为 oracle;密码为:oracle</p>
<pre><code>create user oracle identified by oracle;</code></pre>
<p>查看是否有此用户 oracle</p>
<pre><code>select * from all_users;</code></pre>
<p>给用户赋予connect 和 resource 角色(connect: 保证数据库可以链接;resource:该用户可以使用数据库的资源;create session:会话的权利)</p>
<pre><code>grant connect,resource,create session to oracle;</code></pre>
<p>输入建表语句</p>
<pre><code>create table student(
SID number(32) primary key,
SNAME varchar(32),
wage number(32)
)
create table person(
SID number(32) primary key,
SNAME varchar(32),
wage number(32)
)
</code></pre>
<p><a href="https://blog.csdn.net/weixin_36001063/article/details/91598532">https://blog.csdn.net/weixin_36001063/article/details/91598532</a></p>
<p>参考教程:<a href="https://www.oraclejsq.com/oraclegl/010300770.html">https://www.oraclejsq.com/oraclegl/010300770.html</a></p>
<p>maven</p>
<pre><code> <dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>12.1.0.1-atlassian-hosted</version>
<!-- <scope>test</scope> -->
</dependency></code></pre>
<p>数据库配置</p>
<pre><code>jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:XE
jdbc.username=oracle
jdbc.password=oracle</code></pre>
<p><a href="https://hub.docker.com/r/oracleinanutshell/oracle-xe-11g">https://hub.docker.com/r/oracleinanutshell/oracle-xe-11g</a></p>