oracle 安装，启动，plsql 连接

1.下载oracle 服务器端，正常安装，在选择桌面类或者是服务器类的时候选择服务器类。

2.下载oracle 客户端解压版下载地址链接：https://pan.baidu.com/s/1miACKiO 密码：fx1z

3.将下载的客户端放在安装的oracle 目录中，我的oracle 目录：D:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN 这里已经到了tnsnames.ora ,listener.ora 目录了

4.解压版的客户端位置 D:\app\product\11.2.0\client32\instantclient_11_2\network\admin 将上面的tnsnames.ora 和 listener.ora 文件拷贝过来，添加服务名称和监听

tnsnames.ora 的配置文件

# tnsnames.ora Network Configuration File: D:\app\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

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

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
(SERVICE_NAME = orcl)
)
)

127.0.0.1 是主机ip 可以是本地主机也可以是远程主机

listener.ora 配置

# listener.ora Network Configuration File: D:\app\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 = D:\app\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(SID_NAME = ORCL)
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\app\product\11.2.0\dbhome_1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)

ADR_BASE_LISTENER = D:\app

将服务添加到监听当中

5.win+r 打开dos 命令，先查看服务是否被装载进入监听文件中：查看状态的命令 lsnrctl status 启动监听的命令 lsnrctl start