急问:没有图形界面的情况下,如何配置监听服务

显示全部楼层 · 2006-4-12 17:38:17

我没有图形界面,安装完oracle后被人删了
现在我发现监听没有配,想运行netca才报错

请问不进图形界面能配置吗?

千问 · 2006-4-12 17:38:17

window下没有netca , 直接修改文件！

千问 · 2006-4-12 17:38:17

我的数据库是装在ＬＩＮＵＸ下的，没有ＸＷＩＮＤＯＷＳ
我的数据库实例名是egpdb1，应该怎样修改文件？
我修改后启动lsnrctl start
说不成功

千问 · 2006-4-12 17:38:17

cd$ORACLE_HOME/network/admin
vilistener.ora

LISTENER =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = PNPKEY))
)
(SID_DESC=
(SID_NAME=DB name)
(ORACLE_HOME=/opt/oracle/ora817)
)

千问 · 2006-4-12 17:38:17

我的listener.ora的内容，看看是不是有问题
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 19.200.1.14)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = EGPDB1)
(ORACLE_HOME = /opt/oracle/product/9.2.0.4)
(SID_NAME = EGPDB1)
)
)

千问 · 2006-4-12 17:38:17

参考一下：
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.85.4)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/oracle/app/oracle/product/9.2.0.1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = 20000.hecz.cn)
(ORACLE_HOME = /oracle/oracle/app/oracle/product/9.2.0.1)
(SID_NAME = 20000)
)
)

千问 · 2006-4-12 17:38:17

可用lsnrctl status/start/stop进行一下测试