oracle与plsql的连接

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

D:/XX/PRoduct/11.2.0/dbhome_1/NETWORK/ADMINlistener：(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 连接到oracle4.新建用户 create user XX identified by XX  授权 grant dba to fXX5.导入dmp:cmd-imp XX/XX@orcl file="D:/2015.dmp" full=y;(dos命令非oracle命令)6.登录：XX  XX  127.0.0.1:1521/ORCL7.安装myeclipse:安装目录为：C:/tools/Genuitec 也可修改配置文件myeclipse.ini项目导入-取消校验（vaidation,showView-navigator-.project)-修改xml中地址，全部改为127.0.0.1  XX XX