为什么换个IP或者拔掉网线,oracle就不能启动了呢? 如题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 把你的tnsname.ora及监听文件中host改成主机名 修改 listener.ora 把IP改成主机名 # tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora# Generated by Oracle configuration tools.LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = 29fcfb22c60f486)(PORT = 1522))ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 29fcfb22c60f486)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_2\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\oracle\product\10.2.0\db_2) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 29fcfb22c60f486)(PORT = 1522)) ) )按楼上说的方法改了,然后拔掉网线,启动,其他的服务都能启动,只有OracleDBConsoleorcl无法启动,提示“发生服务特定错误:2.请键入NET HELPMSG 3547以获得更多的帮助”。请问这是怎么回事?难道oracle不能脱机运行?我的oracle10g是装在本机上的,学习用的。 db control启不动是正常的哦.因为这个过程中需要ip hostname之类的信息. 那怎么办呢?难到说如果想脱机运行oracle真的是不可能的? OracleDBConsoleorcl这个服务不启动的情况下有没有试过连接一下? 问大家个问题 Oracle ExecuteNonQuery()执行成功,但是数据库里面没有更新 急!!!!!!!oracle Help me !!! oracle8倍份的奇怪问题! 如何启用/禁止并行服务器。 请教高手:Oracle中ADO查询记录是否存在的问题 如何在PD中导入Oracle8i的数据源 定义什么样的字段类型,可以存储1万字的中文字符? 这个sql语句有会把问题?老报错,请大侠帮忙改下 条件判断中的 IN 的使用 ORACLE数据导入SQL SERVER
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 29fcfb22c60f486)(PORT = 1522))
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 29fcfb22c60f486)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_2)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 29fcfb22c60f486)(PORT = 1522))
)
)按楼上说的方法改了,然后拔掉网线,启动,其他的服务都能启动,只有OracleDBConsoleorcl无法启动,
提示“发生服务特定错误:2.请键入NET HELPMSG 3547以获得更多的帮助”。
请问这是怎么回事?难道oracle不能脱机运行?
我的oracle10g是装在本机上的,学习用的。