1. 监听端口打开:
192.168.44.97:1521 0.0.0.0:* LISTEN
2. sqlplus 连不上,tnsping也失败
3. alter system set local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.44.97)(PORT=1521))' scope=both;
alter system register;解决,但lsnrctl status发现push service有2条push instance 记录,一个为ready动态注册),另一个为unkown(静态注册)。
======================================================
oracle@uma1:~/product/11.2.0/dbhome_2/network/admin> cat listener.ora
# listener.ora Network Configuration File: /home/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.44.97)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = push)
(SID_NAME = push)
)
)
ADR_BASE_LISTENER = /home/oracle
====================================================================