Mac 使用docker安装oracle11g，连接navicat，导入dmp文件

2. 连接navicat
   修改服务名

# 软连接Oracle
1、docker ps -a

2、sudo docker exec -it cdfb5971deb9 /bin/bash

3、 sqlplus / as sysdba

# 执行修改命令
SQL> show parameter service_name;

SQL> alter system set service_names='orcl' scope=both;

SQL> shutdown immediate

SQL> exit

4. 导入dmp

# 将dmp文件上传到docker镜像
--docker cp 本地dmp文件路径 容器ID:镜像路径
docker cp /Users/xxx/Downloads/aaa.dmp cdfb5971deb9:/home/oracle
# 修改字符集为ZHS16GBK
1、软连接数据库
	sqlplus / as sysdba
2、顺序执行以下SQL
	SHUTDOWN IMMEDIATE;
	STARTUP MOUNT;
	ALTER SYSTEM DISABLE RESTRICTED SESSION;
	ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
	ALTER SYSTEM SET AQ_TM_PROCESSES=0;
	ALTER DATABASE OPEN;
	ALTER DATABASE CHARACTER SET ZHS16GBK;
执行完最后一条SQL如果报错：ERROR at line 1:
ORA-12712: new character set must be a superset of old character ....
则再执行下面的SQL：
	ALTER SYSTEM ENABLE RESTRICTED SESSION;
	ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
	SHUTDOWN IMMEDIATE;
	STARTUP;
#imp导包 imp oracle用户名/密码@localhost/orcl file=/home/oracle/xxx.dmp full=y ignore=y
[oracle@df12839f8bab /]$ imp dzzd/dzzd@localhost/orcl file=/home/oracle/xxx.dmp full=y ignore=y

5. Java项目连接JDBC
   若是报这个错误，参考此博文：Java 连接JDBC
   ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
   需要修改tomcat content.xml连接数据库的参数 或者配置文件中连接数据库的参数