运行->regedit->local_machine->system->currentcontrolset->services->
oracleorahome81tnslistener看有没有ImagePath这个变量,没有的话加上
值为"..\bin\tnslsnr.exe"就可以了
oracleorahome81tnslistener看有没有ImagePath这个变量,没有的话加上
值为"..\bin\tnslsnr.exe"就可以了
解决方案 »
- oracle sqlldr 报错:SQL*Loader-350
- PL/SQL Developer 7.0.3 大家过来帮帮忙
- 紧急:.dmp文件如何导入到informix数据库中,或者从.dmp中提取原始SQL
- 我要用这个函数,UTL_FILE.PUT_LINE(); 来向文件里写数据,那预先在sql*plus里面打什么命令设置一下,才行呢??
- ORACLE中如何把表导成.DMP文件
- ORACLE中的两个触发器可否放在一个SQL文件中执行,我的好象不能?
- exp能同时对多表进行带条件的导出吗?
- oracle9i的date数据格式问题求救!
- LINUX下倒入(imp)数据字符集问题
- Oracle 9i的日志文件不小心被我删除,我该怎么办。救救我,oracle启不起了。
- 这样的SQL语句怎么写
- 回滚问题
Cause: The SERVICE_NAME in the CONNECT_DATA was not found in the listener's tables.Action: Check to make sure that the SERVICE_NAME specified is correct.
# Generated by Oracle configuration tools.SAVE_CONFIG_ON_STOP_LISTENER1 = TRUELISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1923168.1.164)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.138)(PORT = 1521))
)
)
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = om)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = om)
)
)LISTENERa =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = om)(PORT = 1522))
)
)
)SID_LIST_LISTENERa =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = a)
(ORACLE_HOME = /home/oracle/product/9.2.0)
(SID_NAME = a)
)
)