刚安装完oracle,但是启动sqlplus时出了问题,请各位前辈帮帮忙。谢谢了。 我在命令行里已经启动监听程序成功了:显示使用名称listener的监听程序已经启动。可是我在sqlplus里输入用户名和口令后却显示:ORA-12541:TNS:无监听程序。请问这是怎么回事啊?应该怎么修正呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 oracle 工作必须打开3个进程,名字我忘了........ lsnrctl status 命令检查监听状态。如果正常,检查 tnsnames.ora 配置 tnsnames.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME =orcl) (ORACLE_HOME = F:\oracle\product\10.1.0\db_1) # (PROGRAM = extproc) ) )LISTENER =(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = orcl)) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ))listener.oraORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME=orcl) ) ) 请教一个sql效率的问题,关于常量表达式的 oracle 存取blob字段 求提高搜索速度的方案 oracle小數點的位數設定 Oracle有没有工具查看表和表之间的关系? 小弟求救 想做一个触发器:发现表中的一个字段被改了,对应将另一个字段也改过来。如何实现? 如何通过Redo Log文件来恢复数据库? linux下的备份工具rman在哪里? 这种语句如何写 ORA-12541:TNS:无监听程序”错误 问个oracle的小问题
(SID_LIST =
(SID_DESC =
(SID_NAME =orcl)
(ORACLE_HOME = F:\oracle\product\10.1.0\db_1)
# (PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
listener.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME=orcl)
)
)