docker installation and configuration oracle

I have read a lot of articles on docker installing oracle on the Internet. Since there are many images, I tried several images without success. The image below is one that I installed successfully. I recorded the installation process. I hope Can help everyone.

Installation steps:

1. Use the following command to search for the image:

$ docker search oracle

2. Pull the image directly:

$ docker pull jaspeen/oracle-xe-11g  #因为版本不同有的可能是jaspeen/oracle-11g

3. After the download is completed, run the image file:

$ docker run -p 1521:1521 --name oracle_11g -d --restart=always jaspeen/oracle-xe-11g

4. Enter the usage to check whether the image is started.

$ docker ps -a

The default for the newly installed one is startup. Okay, if it does not start, use the following command to start

$ docker start oracle

5. Go into the oracle container to set the dba password, etc. You can operate sql directly in it:

$ docker exec -it oracle_11g /bin/bash
root@a96767712314:/#

After entering Oracle:

(1), Oracle is installed by default Under the oracle user, execute:

su oracle

(2) and find the directory where the sqlplus command is located. This image is in:

/u01/app/oracle/product/11.2.0/xe/bin 下
 cd /u01/app/oracle/product/11.2.0/xe/bin
 ./sqlplus / as sysdba

( 3) Change the DBA password:

alter user sys identified by newpassword;
alter user system identified by newpassword;

Now you can log in through the DBA account, or you can use tools to log in, the default SID: XE

(4). Generally, it is impossible to give a DBA account to others, so you must create an account for them: Create a new user: User name is admin and password is password

 create user admin identified by password;

(5). After creation, you will find You can't log in because you don't have authorization, so you need to authorize the login permission:

grant create session to admin

6. Stop or start the service in Docker

docker stop oracle       #停止oracle
docker start oracle       #启动oracle

7. Check the running container

docker ps

After the docker container oracle database is installed, we need to do some daily operations. Use the connection tool to connect and find some problems. The following commands will be used frequently.

Log in as system user

connect as dba;

Give admin the permission to create views

grant create view to admin;

Give admin the permission to query any table

grant select any teble to admin;

Give admin the permission to query any dictionary

grant select any dictionary to admin;

Use the sys account to give the admin account the permission to create synonym

grant create synonym to admin;

The above steps are what I have installed successfully. Follow the above Just install it step by step. If you don't understand anything, please leave a message. Thank you for your support. Hope this helps everyone.

Related recommendations: "docker tutorial"

The above is the detailed content of docker installation and configuration oracle. For more information, please follow other related articles on the PHP Chinese website!