Oracle 11gR2 安装
? ? ? ?Oracle客户端安装步骤:
? ? C:appAdministratorproduct11.2.0 C:appAdministratorproduct11.2.0client_1oci.dll ? ?
? ? ? ? ? ? 使用PLSQL创建Oracle的表空间及用户 需要使用拥有dba权限的用户登录PLSQL,打开Command Window窗口,然后创建表空间及在该表空间下创建用户; 命令: --创建表空间 SQL> Create tablespace JYTTableSpace ??2 ?logging ??3 ?datafile ‘C:DBJYTTestJYTTableSpace.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服务端安装步骤: 按提示安装完成后需要操作?:
l?listener.ora SID_LIST_LISTENER = ??(SID_LIST = ????(SID_DESC = ??????(SID_NAME = ORCL) ??????(ORACLE_HOME = C:appjytproduct11.2.0dbhome_1) ??????(ENVS = "EXTPROC_DLLS=ONLY:C:appjytproduct11.2.0dbhome_1BINoraclr11.dll") ????) ????(SID_DESC = ??????(SID_NAME = JYTTEST) ??????(ORACLE_HOME = C:appjytproduct11.2.0dbhome_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:appjyt ? l?sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT) ? l?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) ????) ??) (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |