启动oracle
启动监听
- oracle用户登录服务器
$ su - oracle
- 打开监听服务
$ lsnrctl start
- 查看监听服务
[oracle@localhost ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-FEB-2021 14:27:04
Copyright (c) 1991, 2016, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kf-esb-db)(PORT=1521)))
STATUS of the LISTENER
------------------------
别名 LISTENER
版本 TNSLSNR for Linux: Version 12.2.0.1.0 - Production
启动日期 22-FEB-2021 14:21:48
运行时间 0 days 0 hr. 5 min. 15 sec
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 /opt/oracle/oraclesvr/product/12.2.0/db_1/network/admin/listener.ora
监听程序日志文件 /opt/oracle/oraclesvr/diag/tnslsnr/db/listener/alert/log.xml
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db..qtest)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
`The listener supports no services`
命令执行成功
The listener supports no services, 监听器没有任何服务实例
接下来就要启动实例
启动数据库实例
- 启动sqlplus ,但不连接数据库
$ sqlplus /nolog
SQL>
登录数据库会报错没有实例, 需要启动实例
SQL> conn /as sysdba
Connected to an idle instance.
- startup命令启动实例
SQL> startup
Total System Global Area 1660944384 bytes
Fixed Size 8621376 bytes
Variable Size 1493172928 bytes
Database Buffers 150994944 bytes
Redo Buffers 8155136 bytes
Database mounted.
Database opened.
SQL> quit
- 此时再查看监听服务, 发现有了实例
[oracle@localhost ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-FEB-2021 14:33:09
Copyright (c) 1991, 2016, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kf-esb-db)(PORT=1521)))
STATUS of the LISTENER
------------------------
别名 LISTENER
版本 TNSLSNR for Linux: Version 12.2.0.1.0 - Production
启动日期 22-FEB-2021 14:21:48
运行时间 0 days 0 hr. 11 min. 20 sec
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 /opt/oracle/oraclesvr/product/12.2.0/db_1/network/admin/listener.ora
监听程序日志文件 /opt/oracle/oraclesvr/diag/tnslsnr/db/listener/alert/log.xml
监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db..qtest)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
` (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=db..qtest)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/oraclesvr/admin/esbdb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
服务摘要...
服务 "orcl" 包含 1 个实例。
实例 "orcl", 状态 READY, 包含此服务的 1 个处理程序...
服务 "orclXDB" 包含 1 个实例。
实例 "orcl", 状态 READY, 包含此服务的 1 个处理程序...
`
命令执行成功
关闭oracle
关闭数据库实例
- 以SYS用户身份登录Oracle
$ sqlplus /nolog
SQL> conn /as sysdba
Connected to an idle instance.
- shutdown命令关闭实例
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> quit
关闭监听器
$ lsnrctl stop