0


Linux下oracle数据库启动

一、在Linux下启动Oracle

1.登录到Linux服务器(ssh)
2.切换到oracle用户权限
(命令是:**# su –l oracle**)
在这里插入图片描述

3.进入sqlplus界面(命令是:$ sqlplus /nolog 或 sqlplus / as sysdba)
在这里插入图片描述
原本的画面会变为
SQL>
接着请输入

SQL>conn / as sysdba ;
输入

SQL> startup (作用:启动数据库实例)

在这里插入图片描述

另外停止数据库的指令如下:
SQL> shutdown immediate

二、检查Oracle 数据库是否启动

回到终端机模式,输入:ps -ef|grep ora_ (作用是:查看是否有Oracle的进程,如果有,大多数情况说明启动了。)

[oracle@localhost ~]$ ps -ef|grep ora_

oracle 121931011:00 ? 00:00:00 ora_pmon_orcl
oracle 121951011:00 ? 00:00:00 ora_vktm_orcl
oracle 121991011:00 ? 00:00:00 ora_gen0_orcl
oracle 122011011:00 ? 00:00:00 ora_diag_orcl
oracle 122031011:00 ? 00:00:00 ora_dbrm_orcl
oracle 122051011:00 ? 00:00:00 ora_psp0_orcl
oracle 122071011:00 ? 00:00:00 ora_dia0_orcl
oracle 122091011:00 ? 00:00:00 ora_mman_orcl
oracle 122111011:00 ? 00:00:00 ora_dbw0_orcl
oracle 122131011:00 ? 00:00:00 ora_lgwr_orcl
oracle 122151011:00 ? 00:00:00 ora_ckpt_orcl
oracle 122171011:00 ? 00:00:00 ora_smon_orcl
oracle 122191011:00 ? 00:00:00 ora_reco_orcl
oracle 122211011:00 ? 00:00:00 ora_mmon_orcl
oracle 122231011:00 ? 00:00:00 ora_mmnl_orcl
oracle 122251011:00 ? 00:00:00 ora_d000_orcl
oracle 122271011:00 ? 00:00:00 ora_s000_orcl
oracle 122391011:00 ? 00:00:00 ora_qmnc_orcl
oracle 122571011:00 ? 00:00:00 ora_cjq0_orcl
oracle 122771011:00 ? 00:00:00 ora_q000_orcl
oracle 122791011:00 ? 00:00:00 ora_q001_orcl
oracle 1238910058011:01 pts/0 00:00:00 grep--color=auto ora_

[oracle@localhost ~]$

三、检查Oracle DB监听器是否正常

输入:$ lsnrctl status (作用是:检查监听是否启动。) 以下为没有启动。

[oracle@localhost ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-MAR-2022 11:03:33
 
Copyright © 1991, 2009, Oracle. All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@localhost ~]$ ^C
[oracle@localhost ~]$

如果没有启动,可以输入:$ lsnrctl start (作用是:启动监听器)

[oracle@localhost ~]$ lsnrctl start
 
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-MAR-2022 11:04:48
 
Copyright © 1991, 2009, Oracle. All rights reserved.
 
Starting /data/oracle/product/11.2.0/bin/tnslsnr: please wait…
 
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /data/oracle/product/11.2.0/network/admin/listener.ora
Log messages written to /data/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 17-MAR-2022 11:04:48
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data/oracle/product/11.2.0/network/admin/listener.ora
Listener Log File /data/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@localhost ~]$

另外停止监听的指令如下:

$ lsnrctl stop

标签: 数据库 linux oracle

本文转载自: https://blog.csdn.net/weixin_43828467/article/details/131891481
版权归原作者 九尾小白 所有, 如有侵权,请联系我们删除。

“Linux下oracle数据库启动”的评论:

还没有评论