oracle与plsql的连接

1.将两个压缩包同时选中解压，点击setup直接安装,安装完后修改两个文件：

D:\XX\product\11.2.0\dbhome_1\NETWORK\ADMIN
listener：
(SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\201610201\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\201610201\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    加入下面内容：
    (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME = D:\app\201610201\product\11.2.0\dbhome_1)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\201610201\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )
tnsnames：全部修改为：HOST = 127.0.0.1

2.打开plsql-工具-首选项-检查连接

3.登录：sqlplus 用户名：sys 密码 as sysdba 连接到oracle
4.新建用户 create user XX identified by XX  授权 grant dba to fXX
5.导入dmp:cmd-imp XX/XX@orcl file="D:\2015.dmp" full=y;(dos命令非oracle命令)
6.登录：XX  XX  127.0.0.1:1521/ORCL
7.安装myeclipse:
安装目录为：C:\tools\Genuitec 也可修改配置文件myeclipse.ini
项目导入-取消校验（vaidation,showView-navigator-.project)-修改xml中地址，全部改为127.0.0.1  XX XX