系列二、配置 连接

一、修改listener.ora

1.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_DLLS=ONLY: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\Oracle11g

1.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_DLLS=ONLY: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 '院区名称';