1、切換到oracle用戶

[root@OracleLinux-R9-U5 ~]# su oracle

2、查看oracle是否配置了ORACLE_SID

[oracle@OracleLinux-R9-U5 root]$ cd ~
[oracle@OracleLinux-R9-U5 ~]$ cat .bash_profile

3、輸出內容如下：

[oracle@OracleLinux-R9-U5 ~]$ cat .bash_profile
# .bash_profile# Get the aliases and functions
if [ -f ~/.bashrc ]; then. ~/.bashrc
fi
export ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree  # 根據實際路徑修改
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=FREE
# User specific environment and startup programs
[oracle@OracleLinux-R9-U5 ~]$ 

4、如果已經設置了ORACLE_SID和oracle環境變量，則刷新環境變量

[oracle@OracleLinux-R9-U5 ~]$ source .bash_profile

5、連接數據庫并且開啟數據庫

[oracle@OracleLinux-R9-U5 ~]$ sqlplus / as sysdbaSQL*Plus: Release 23.0.0.0.0 - Production on Sat Apr 12 09:41:45 2025
Version 23.7.0.25.01Copyright (c) 1982, 2025, Oracle.  All rights reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 1083694712 bytes
Fixed Size                  5422712 bytes
Variable Size             469762048 bytes
Database Buffers          603979776 bytes
Redo Buffers                4530176 bytes
Database mounted.
Database opened.
SQL> 

6、啟動網絡監聽

[oracle@OracleLinux-R9-U5 ~]$ lsnrctl startLSNRCTL for Linux: Version 23.0.0.0.0 - Production on 12-APR-2025 09:43:31Copyright (c) 1991, 2025, Oracle.  All rights reserved.Starting /opt/oracle/product/23ai/dbhomeFree/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 23.0.0.0.0 - Production
System parameter file is /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/OracleLinux-R9-U5/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.101)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.101)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 23.0.0.0.0 - Production
Start Date                12-APR-2025 09:43:33
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           FREE
Listener Parameter File   /opt/oracle/product/23ai/dbhomeFree/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/OracleLinux-R9-U5/listener/alert/log.xml
Listening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.101)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@OracleLinux-R9-U5 ~]$ 

7、自 此數據庫啟動完成