系列二、配置 连接

一、修改listener.ora1.1、修改前# listener.ora Network Configuration File: C:\Programs\Oracle11g\product\11.2.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER (SID_LIST (SID_DESC (SID_NAME CLRExtProc) (ORACLE_HOME C:\Programs\Oracle11g\product\11.2.0\dbhome_1) (PROGRAM extproc) (ENVS EXTPROC_DLLSONLY:C:\Programs\Oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll) ) ) LISTENER (DESCRIPTION_LIST (DESCRIPTION (ADDRESS (PROTOCOL IPC)(KEY EXTPROC1521)) (ADDRESS (PROTOCOL TCP)(HOST localhost)(PORT 1521)) ) ) ADR_BASE_LISTENER C:\Programs\Oracle11g1.2、修改后SID_LIST_LISTENER (SID_LIST (SID_DESC (SID_NAME CLRExtProc) (ORACLE_HOME C:\Programs\Oracle11g\product\11.2.0\dbhome_1) (PROGRAM extproc) (ENVS EXTPROC_DLLSONLY:C:\Programs\Oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll) ) (SID_DESC (GLOBAL_DBNAME ORCL) (ORACLE_HOME C:\Programs\Oracle11g\product\11.2.0\dbhome_1) (SID_NAME ORCL) ) ) LISTENER (DESCRIPTION_LIST (DESCRIPTION (ADDRESS (PROTOCOL IPC)(KEY EXTPROC1521)) (ADDRESS (PROTOCOL TCP)(HOST 0.0.0.0)(PORT 1521)) ) ) ADR_BASE_LISTENER C:\Programs\Oracle11g二、常用指令# 停止Oracle服务 lsnrctl stop # 重启oracle服务 lsnrctl start # 查询监听状态 lsnrctl status三、连接Oracle四、权限4.1、授予HR用户权限-- 授予创建表的权限 GRANT CREATE TABLE TO HR; -- 授予表空间使用权限如果你的用户表空间配额不足 ALTER USER HR QUOTA UNLIMITED ON USERS;4.2、建表-- 创建科室信息表属于 HR 用户 CREATE TABLE hr.v_department ( department_code VARCHAR2(255), -- 科室编号 department_name VARCHAR2(255), -- 科室名称 hospital_name VARCHAR2(255), -- 医院名称 campus_name VARCHAR2(255) -- 院区名称 ); -- 添加字段注释 COMMENT ON COLUMN hr.v_department.department_code IS 科室编号; COMMENT ON COLUMN hr.v_department.department_name IS 科室名称; COMMENT ON COLUMN hr.v_department.hospital_name IS 医院名称; COMMENT ON COLUMN hr.v_department.campus_name IS 院区名称;