Oracle安装
一、点击setup直接安装
安装时注意事项:
0.关闭防火墙
1.软件目录路径
3.不要改库名orcl(P:root)并设置口令,别完记住了,我这里设置为root
2.安装完后解锁scott(P:tiger)和hr(P:hr)用户并设置密码,方便测试
安装完后可网页登陆:
用户名:sys
密码:dushan
连接SYSDBA
若未建库安装则执行dbca和netca
二、修改配置文件,改HOST及添加内容
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
SID_LIST_LISTENER =
(SID_LIST =
...
#注意添加下段,看清括号
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = orcl)
)
...
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 填写服务器IP)(PORT = 1521))
)
)
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 填写服务器IP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
三、重启服务
计算机-管理-配置-服务
先重启OracleOraDb11g_homeTNSListener服务
后重启OracleServiceORCL服务
如忘记解锁scott用户则在命令行键入以下命令
>sqlplus /nolog
SQL>conn sys/dushan as sysdba
SQL>alter user scott identified by tiger;
SQL>alter user scott account unlock;
Oracle客户端软件安装
安装客户端软件instantclient
准备工作:instantclient下载
1.官网下载地址
http://www.oracle.com/technetwork/topics/winx64soft-089540.html
instantclient-basic-windows.x64-12.2.0.1.0.zip
instantclient-sqlplus-windows.x64-12.2.0.1.0.zip
instantclient-sdk-windows.x64-12.2.0.1.0.zip
2、将上述三个文件解压到同一目录下得到instantclient_12_2文件夹
D:\Oracle\instantclient_12_2
3、在文件夹空白地方按住shift+鼠标右键,打开cmd窗口
4、在弹出对话框中,尝试命令行下登陆:
>sqlplus scott/tiger@192.168.80.100:1521/orcl
安装客户端图形化软件PL/SQL Developer
注意不要安装到有空格和中文的路径下
1. 安装PL/SQL Developer到D:\oracle\SQL_Developer文件夹下
2. 找到服务器端修改过的两个文件:tnsnames.ora和listener.ora (其实listener.ora无所谓)
复制到D:\Oracle\instantclient_12_2\config文件夹下
3、新建一个系统变量
变量名:TNS_ADMIN
变量值:D:\Oracle\SQL_Developer\config
#***
#???添加系统变量???
#NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
#或者找到你PLSQL_Developer安装目录D:\oracle\SQL_Developer
#在里面新建一个记事本文件名称为start.bat执行文件并执行,成功打开PL/SQL Developer后取消登陆
#代码如下:
#@echo off
#set path=D:\app\Administrator\product\instantclient_12_2
#set ORACLE_HOME=D:\app\Administrator\product\instantclient_12_2
#set TNS_ADMIN=D:\app\Administrator\product\instantclient_12_2
#set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
#start plsqldev.exe
#***
4、打开PLSQL_Developer,Cancel,进入主界面
1)在"Configure或tools里面"--Preferences--Connection中,
2)在"logoff with open transaction"选择"Commit";
3)在"Orale HOme"和"OCI Library"填入instantclient路径:
“D:\Oracle\instantclient_12_2”;
4)先点击apply-再点击OK,关闭SQL_Developer重新运行即可。
中文乱码解决问题
-
查看服务器端编码,找到实际值,并记录“SIMPLIFIED CHINESE_CHINA.AL32UTF8”
SQL>select userenv('language') from dual;
-
执行语句,查看两个值是否一样
SQL>select * from V$nls_Parameters;
-
设置环境变量
计算机->属性->高级系统设置->环境变量->新建 设置变量名:NLS_LANG 变量值:第一步查到的值 SIMPLIFIED CHINESE_CHINA.AL32UTF8
-
重新启动PLSQL即可