使用docker-compose部署oracle
vim docker-compse.yml
version: '2'
services:
oracle:
image: absolutapps/oracle-12c-ee
environment:
- ORACLE_PDB=system
- ORACLE_PWD=oracle
- ORACLE_CHARACTERSET=AL32UTF8
restart: always
container_name: oracle
volumes:
- /home/docker/docker-compose/oracle/my-docker-data/oracle-11g/data:/u01/app/oracle
ports:
- 1521:1521
运行命令
docker-compose -f docker-compse.yml up -d
查看容器
docker ps -a
容器运行成功,这是一个使用Navicat连接报错:ORA-12541: TNS:no listener
解决办法:
docker exec -it 容器id /bin/bash
查找listener.ora文件所在位置,并编辑
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
再次连接报错:ORA-21561: OID generation failed
解决办法(mac电脑):
1、在终端输入hostname命令
2、编辑/etc/hosts文件
127.0.0.1 hostname
再次连接成功!!!