手动启动oracle数据库

最新推荐文章于 2022-07-07 08:40:20 发布

yuliming5219

最新推荐文章于 2022-07-07 08:40:20 发布

阅读量1.2k

点赞数

文章标签： oracle database authentication linux system 数据库

本文链接：https://blog.csdn.net/yuliming5219/article/details/1500116

版权

手动启动oracle数据库
用oracle用户身份登陆
su - oracle
password:

sqlplus "/ as sysdba"
sql>startup
sql>quit

lsnrctl start

具体屏幕显示如下：

[oracle@myxinnet-2 bin]$ su - oracle
Password:
[oracle@myxinnet-2 oracle]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 1 16:27:08 2007

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1241513984 bytes
Fixed Size                  1219136 bytes
Variable Size             268436928 bytes
Database Buffers          956301312 bytes
Redo Buffers               15556608 bytes
Database mounted.
Database opened.

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@myxinnet-2 oracle]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2007 16:27:58

Starting /home/database/product/10.2.1//bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /home/database/product/10.2.1/network/admin/listener.ora
Log messages written to /home/database/product/10.2.1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myxinnet-2)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myxinnet-2)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                01-FEB-2007 16:28:00
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /home/database/product/10.2.1/network/admin/listener.ora
Listener Log File         /home/database/product/10.2.1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myxinnet-2)(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