Oracle客户端安装
第一步:安装和配置Oracle客户端、PLSQL
- 配置tnsnames
- 在C:\app\Administrator\product\11.2.0\client_1 中自定义文件 network/ admin/ tnsnames.ora
- 记事本打开tnsnames.ora,配置数据库信息(服务器上每次新建数据库都需要在这里手动配置)
JYTTest = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.80)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = JYTTest) ) )
- 配置环境变量
- 我的电脑 - 属性 - 高级 - 环境变量 - 系统变量
- 新建 Path = C:\app\Administrator\product\11.2.0\client_1
- 新建TNS_ADMIN = C:\app\Administrator\product\11.2.0\client_1\network\admin
- 新建NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
- 安装、配置PL/SQL
C:\app\Administrator\product\11.2.0
C:\app\Administrator\product\11.2.0\client_1\oci.dll
第二步:使用PLSQL创建Oracle的表空间及用户
需要使用拥有dba权限的用户登录PLSQL,打开Command Window窗口,然后创建表空间及在该表空间下创建用户;
命令:
--创建表空间
SQL> Create tablespace JYTTableSpace 2 logging 3 datafile 'C:\DB\JYTTest\JYTTableSpace.dbf' 4 size 50m 5 autoextend on 6 next 50m 7 extent management local; Tablespace created
--创建表空间用户
SQL> Create user JYT_Users identified by 123456 default tablespace JYTTableSpace temporary tablespace temp; User created
--为用户授权
SQL> Grant connect,dba to JYT_Users;
Grant succeeded
不用PL/SQL,还可以使用Navicat Premium管理Oracle数据库
配置:
Oracle服务端安装步骤
按提示安装完成后需要操作 :
- 开放1521端口(关闭防火墙,新建入站规则)
- 按需配置C:\app\jyt\product\11.2.0\dbhome_1\NETWORK\ADMIN下的三个文件:
tnsnames.ora JYTTEST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WindowsServer2012R2-Image)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = JYTTest) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = WindowsServer2012R2-Image)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )
listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = ORCL) (ORACLE_HOME = C:\app\jyt\product\11.2.0\dbhome_1) (ENVS = "EXTPROC_DLLS=ONLY:C:\app\jyt\product\11.2.0\dbhome_1\BINoraclr11.dll") ) (SID_DESC = (SID_NAME = JYTTEST) (ORACLE_HOME = C:\app\jyt\product\11.2.0\dbhome_1) (GLOBAL_DBNAME= JYTTEST) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.80)(PORT = 1521)) ) ) ADR_BASE_LISTENER = C:\app\jyt
sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)