Oracle10g 下载地址:
链接:http://pan.baidu.com/s/1nuY1DzV 密码:vaoi
包含以下四个文件:
1.10201_database_win32.zipOracle数据库服务端安装
2.10201_client_win32.zip Oracle客户端安装
3.PLsql_Developer_cngr PLsql 开发管理客户端
4.instantclient_10_2用于 PLsql 客户端的实例
一、安装Oracle注意事项
1.安装目录不要出现在 Program Files (x86) \目录下,最好是纯英文的目录
2.安装时候有时候会报错,一定要处理错误,千万不要跳过直接安装,不然安装的Oracle数据库不能正常使用
二、安装 10201_database_win32.zip 解压如下,点击setup.exe 即可安装
然后配置监听:D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\listener.ora
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2014-dell)(PORT = 1521))
)
然后配置监听:D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2014-dell)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Test)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.229.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
三、客户端安装 10201_client_win32.zip或者 PLsql_Developer_cngr即可
(1) 安装 10201_client_win32.zip,解压后执行10201_client_win32\client\setup.exe 即可进行安装
然后就可以用客户端带的 sql Plus 进行连接
(2) 下面主要 PL/sql 安装
PLsql_Developer_cngr 包含 1.plsqldev906.exe 2.chinese.exe 3.Key.txt
首先安装PL/sql可执行程序: plsqldev906.exe
其次安装 chinese.exe进行汉化
最后,激活PL/sql,.Key.txt 里有激活码
然后配置:PL/sql 工具-----> 首选项 -----> 勾选检查
instantclient_10_2中