1、安装OracleClient11gR2
oracle官网下载,window下一路默认安装,安装目录可随意,尽量不要带空格的目录
2、本地网络服务名配置
命令行运行netca或者开始菜单打开Net Configuration Assistant,即打开下图所示窗口
配置步骤如下:
[img]http://dl2.iteye.com/upload/attachment/0117/5073/ff9c320a-b5cd-3e5d-b2d5-14084c2476da.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5075/5806f392-13f5-363c-8217-9c0c05aca761.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5077/745e673d-905b-3b21-8512-ab353b95f56f.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5079/e2ceb2e7-8ccd-3a0e-a248-0c4d68b3fc71.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5081/05b7f5bf-fb2e-3d44-9a2f-32790c6aebb2.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5083/b6a61709-3862-34aa-b4f6-914df1733305.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5085/e0da27eb-2447-354c-9e43-2d1db77b518d.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5087/81478c0e-a358-3e43-921d-dd84dbba0529.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5089/45bcbffe-72f1-3359-86d1-27f0d626e98e.png[/img]
3、使用sqlplus测试连一下oracle
sqlplus命令行登录命令格式为:
以用户名为jison,密码为jison,步骤2中配的本地网络服务名为orcl为例,即
4、安装PLSQLDeveloper11.x
可以一路默认安装,安装目录可随意设置,尽量不要带空格的目录,安装前确保前面3个步骤正确执行
安装和汉化问题自行解决
登录操作如下图所示
[img]http://dl2.iteye.com/upload/attachment/0117/5091/33fae2b9-c6d8-39e5-8b97-32406c28b996.png[/img]
oracle官网下载,window下一路默认安装,安装目录可随意,尽量不要带空格的目录
2、本地网络服务名配置
命令行运行netca或者开始菜单打开Net Configuration Assistant,即打开下图所示窗口
配置步骤如下:
[img]http://dl2.iteye.com/upload/attachment/0117/5073/ff9c320a-b5cd-3e5d-b2d5-14084c2476da.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5075/5806f392-13f5-363c-8217-9c0c05aca761.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5077/745e673d-905b-3b21-8512-ab353b95f56f.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5079/e2ceb2e7-8ccd-3a0e-a248-0c4d68b3fc71.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5081/05b7f5bf-fb2e-3d44-9a2f-32790c6aebb2.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5083/b6a61709-3862-34aa-b4f6-914df1733305.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5085/e0da27eb-2447-354c-9e43-2d1db77b518d.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5087/81478c0e-a358-3e43-921d-dd84dbba0529.png[/img]
[img]http://dl2.iteye.com/upload/attachment/0117/5089/45bcbffe-72f1-3359-86d1-27f0d626e98e.png[/img]
3、使用sqlplus测试连一下oracle
sqlplus命令行登录命令格式为:
sqlplus user/pass@ORACLE_SID
以用户名为jison,密码为jison,步骤2中配的本地网络服务名为orcl为例,即
sqlplus jison/jison@orcl
4、安装PLSQLDeveloper11.x
可以一路默认安装,安装目录可随意设置,尽量不要带空格的目录,安装前确保前面3个步骤正确执行
安装和汉化问题自行解决
登录操作如下图所示
[img]http://dl2.iteye.com/upload/attachment/0117/5091/33fae2b9-c6d8-39e5-8b97-32406c28b996.png[/img]