Home >Database >Oracle >How to start Oracle?

How to start Oracle?

Guanhui
GuanhuiOriginal
2020-06-15 17:34:346469browse

How to start Oracle?

How to start Oracle?

First use the "su oracle" command to switch to the oracle account;

[root@oracle-server ~]# su oracle

Then log in to the "sqlplus" tool;

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 6月 24 11:04:29 2019

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

Then log in to the database;

请输入用户名:  XX
输入口令: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
进程 ID: 0
会话 ID: 0 序列号: 0

Then use the command "conn / as sysdba" to connect to sysdba;

SQL> conn / as sysdba
已连接到空闲例程。

Finally, use the "startup" command to start the database.

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
SQL> startup
ORACLE 例程已经启动。

Total System Global Area 1586708480 bytes
Fixed Size		    2213736 bytes
Variable Size		 1107298456 bytes
Database Buffers	  469762048 bytes
Redo Buffers		    7434240 bytes
数据库装载完毕。
数据库已经打开。

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to start Oracle?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn