在 Linux 上配置 Oracle 监听(Listener),通常分为以下几个步骤。以 Oracle 11g/12c/19c 为例,适用于大多数情况。
ORACLE_HOME 和 PATH)oracle 用户操作su - oracle
查看环境变量:
echo $ORACLE_HOME
echo $ORACLE_SID
如果有图形界面:
netca
按向导:
完成后监听自动启动。
路径:
$ORACLE_HOME/network/admin/listener.ora
示例(最基础配置):
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)
(SID_NAME = orcl)
)
)
HOST 写服务器 IP 或主机名
SID_NAME 写你的实例名
lsnrctl start
查看状态:
lsnrctl status
lsnrctl stop
lsnrctl start
文件位置:
$ORACLE_HOME/network/admin/tnsnames.ora
示例:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
测试连接:
tnsping ORCL
/etc/orataborcl:/u01/app/oracle/product/19.0.0/dbhome_1:Y
最后一项为 Y
dbstart $ORACLE_HOME
netstat -tunlp | grep 1521
firewall-cmd --add-port=1521/tcp --permanent
firewall-cmd --reload
sqlplus / as sysdba
startup
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
)
如果你愿意,可以告诉我:
我可以给你 精确配置示例。