oracle数据库实例开启操作文档

1、登录服务器，切换oracle用户

Last login: Mon May 29 15:46:09 2023 from 10.2.9.58

[root@oracle12cM ~]# su - oracle

Last login: Mon May 29 15:46:14 CST 2023 on pts/0

2、登录数据库

[oracle@oracle12cM ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue May 30 01:23:38 2023

Connected to an idle instance.

3、启动数据库

SQL> startup

ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size 8622776 bytes

Variable Size 448793928 bytes

Database Buffers 75497472 bytes

Redo Buffers 3956736 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

4.启动监听

[oracle@oracle12cM ~]$ lsnrctl start

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 30-MAY-2023 01:23:57

Starting /u01/app/oracle/product/12/db\_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.2.0.1.0 - Production

System parameter file is /u01/app/oracle/product/12/db\_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/diag/tnslsnr/oracle12cM/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle12cM)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle12cM)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production

Start Date 30-MAY-2023 01:23:59

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12/db\_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/diag/tnslsnr/oracle12cM/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle12cM)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

The listener supports no services

The command completed successfully

[oracle@oracle12cM ~]$

5.查看监听状态，状态ready表示监听启动成功可以连接

[oracle@oracle12cM ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 30-MAY-2023 01:26:44