部署Oracle（Windows环境）

部署Oracle（Windows环境）
---

[TOC]

## 工具准备
- 安装包 11g

## 开始安装

`请记住密码`

可以参考文章
Oracle 11g数据库详细安装步骤图解，附带安装包 - projectNo的博客 - CSDN博客
https://blog.csdn.net/projectNo/article/details/76533921

问题小提示：
环境不满足最低需求
处理：Oracle11g安装提示：环境不满足最低需求 - 简书
https://www.jianshu.com/p/ecd0f5a06b2c?utm_campaign

## 安装完成

### 通过Sqlplus登陆访问操作数据库

Oracle详细安装步骤及初步入门 - 夏襄居士的博客 - CSDN博客
https://blog.csdn.net/weixin_38891048/article/details/79172778

测试是否安装成功，我们按下win+r键，调出cmd窗口，输入sqlplus
输入 ：system/orcl as sysdba
创建用户，修改密码，创建表，分配权限和角色
修改用户密码： alter user nlc_zzbz identified by nlc@123456

```
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 5月 28 16:44:34 2019
Copyright (c) 1982, 2010, Oracle.  All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter user nlc_zzbz identified by "nlc@123456";
用户已更改。
SQL> grant dba to nlc_zzbz;
授权成功。
SQL>
```

### SQLPlus常见命令

1.登录：cmd--sqlplus--system/orcl as sysdba
2.conn 连接用户
3.show  user 显示当前登录用户
4.create user 用户名 identified by 密码(加分号)
5.用户权限分配：grant 权限/角色 to 用户名
6.回收权限：revoke 权限/角色 from 角色
7.修改密码
高权限修改：alter user 用户名 identified by 新密码
自己改自己：password 本用户名
8.给用户加锁：alter user 用户名 account lock
  给用户解锁：alter user 用户名 account unlock
9.其他：
claer screen:清屏
show pagesize：显示一页可显示的行数
show linesize：显示一行可显示的长度
spool  路径：/文件名.sql 保存语句和结果
edit   路径：/文件名.sql 打开并编辑
spool off ：清空缓存并结束输出
10.删除用户：
drop user 用户名
drop user 用户名 cascade（删除用户的同时也删除表）

更加详细的入门请查看
Oracle数据库入门——初级系列教程 - 周德顺 - 博客园
https://www.cnblogs.com/kscnchina/p/4570865.html

## 配置网络

以上操作完成，可能只能127连接了，如果开放网络，则需要网络配置

网络配置文件路径：C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
两个相关文件 listener.ora   tnsnames.ora
修改文件内容如下：

```
# listener.ora Network Configuration File: C:\app\Administrator\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:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\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))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.206)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\Administrator
```

```
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

ORCL_206 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.206)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

```

添加新评论