linux下oracle数据库服务和监听的启动停止

最新推荐文章于 2024-06-19 09:54:27 发布

最新推荐文章于 2024-06-19 09:54:27 发布 · 136 阅读

文章标签：

#Oracle #Linux #SQL #C #C++

oracle 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了如何使用Oracle数据库的基本操作步骤，包括启动和关闭数据库实例、启动和停止监听器以及检查监听器的状态。这些命令对于日常管理和维护Oracle数据库非常重要。

[b]1、启动数据库：[/b]

oracle@suse92:~> [color=red]sqlplus /nolog[/color]

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> [color=red]connect /as sysdba[/color]
Connected to an idle instance.
SQL> [color=red]startup[/color]
ORACLE instance started.

Total System Global Area 135352820 bytes
Fixed Size 455156 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 679936 bytes
Database mounted.
[b]2、关闭数据库：[/b]
oracle@suse92:~> [color=red]sqlplus /nolog[/color]

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> [color=red]connect /as sysdba[/color]
Connected to an idle instance.
SQL> [color=red]shutdwon abort;[/color]
[b]3、启动监听器[/b]
oracle@suse92:~> [color=red]lsnrctl start[/color]
[b]4、停止监听器[/b]
oracle@suse92:~>[color=red] lsnrctl stop[/color]
[b]5、查看监听器状态[/b]
　　oracle@suse92:~>[color=red]lsnrctl[/color]
　　LSNRCTL> [color=red]status[/color]
　　LSNRCTL> [color=red]exit[/color]