我是新手,想问一个奇怪的10g,网页模式下的登录问题

显示全部楼层 · 2007-9-1 11:14:00

oracle 10g ie管理页面.如下图,我不知道里面的host内容是在什么地方改的我找了tnsnames.ora,listener.ora我的host都是127.0.0.1,我是在公司局域网装的所以产生的ip,是公司dhcp给我的ip地址.我现在想把这个host改掉,否则我不连入局域网,我在ie模式就不能管理oracle了,谢谢大家了.图片怎么上传啊?晕,发贴子上传图片的地方找不到
http://bbs.chinaunix.net/thread-984878-1-1.html

千问 · 2007-9-1 11:14:00

我不连入局域网也出现172.100.6.200
这是我的tnsnames.ora和listener.ora
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL-Normal =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ccjg-xxzx-wj)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

ORCL-LocalHost =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
GWWuJun=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =

(COMMUNITY = tcp.world)

(PROTOCOL = TCP)

(Host = ccjg-xxzx-wj)

(Port = 1521)
)
)
(CONNECT_DATA = (SID = orcl)
)
)

===========================================
# listener.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.100.0.1)(PORT = 1521))
)
)
)