在 linux 环境下启动 oracle

最新推荐文章于 2024-09-20 17:14:37 发布

iteye_9891

最新推荐文章于 2024-09-20 17:14:37 发布

阅读量85

点赞数

分类专栏： Linux oracle 文章标签：数据库操作系统网络

本文链接：https://blog.csdn.net/iteye_9891/article/details/82547991

版权

oracle 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

Linux

1 篇文章 0 订阅

订阅专栏

启动 oracle 服务

首先，用 oracle 用户登录，SYSDBA 的用户

[oracle@localhost ~]$ sqlplus / AS SYSDBA

登录成功的提示信息

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 6 15:15:49 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

其次，输入以下命令启动oracle

SQL> startup

启动成功的提示信息

ORACLE instance started.

Total System Global Area 859832320 bytes
Fixed Size 2024592 bytes
Variable Size 222301040 bytes
Database Buffers 629145600 bytes
Redo Buffers 6361088 bytes
Database mounted.
Database opened.

再次，退出 sqlplus 输入一下命令

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

最后，启动监听

[oracle@localhost ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-NOV-2013 15:17:42

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 06-NOV-2013 15:17:44
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$

启动成功！