Oracle 报ORA-12514:TNS:listenendoes not currently know of service requested in connect descriptor# listener.ora Network Configuration File: D:\oracle\network\admin\listener.ora
# Generated by Oracle configuration tools.根据网上的资料,我将D:\oracle\NETWORK\ADMIN\listener.ora改成如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = DataBaseName)
(ORACLE_HOME = D:\oracle)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
)接着就报以下错误:
ORA-01034:ORACLE not available请各位帮忙看看........
# Generated by Oracle configuration tools.根据网上的资料,我将D:\oracle\NETWORK\ADMIN\listener.ora改成如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = DataBaseName)
(ORACLE_HOME = D:\oracle)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
)接着就报以下错误:
ORA-01034:ORACLE not available请各位帮忙看看........
解决方案 »
- oracle 存储过程
- oracle 迁移 大家能否讲点经验 谢!急!
- 数据库装在本地和远程,存储检索效率哪个高?
- 如何将一个表中检索的值作为另一个表的字段列表?
- sql语句执行效率的问题
- 我们的论坛正式运行,希望大家踊跃注册.
- 我的是ORACLE8.16+WIN2000SER,一般提到的PRO*C,如何预编译?
- 初学求教,Oracle中如何从一个*.dmp文件中恢复一个表的结构?
- 这句语句那错了!!select Z.zzqc,Zzzmc from t_bds B,t_bm_zzjg Z where B.zzjg_yx=Z.zzjg_id GROUP BY Z.zzqc
- 关于 pl/sql 中的问题,请高手们尽快答复,急!
- 问两个SQL语句的区别
- 批量把表导成文件,高手进来
SQL> alter DATABASE open;再试下,不行的话重新启动一下你的数据库