怎么说ORACEL 8.16 支持中文计算机名?????急得直冒汗! 将LISTENER的HOSTNAME换成IP地址试试。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我也换过了!还是不行呀!急死了呀!还有没有其它办法!如果能进入企业管理器或SQL*Pluse也好嘛!但就是不让进! LSNRCTL》START,能不能启动,估计还是你的网络有问题,TNSPING HOSTNAME能不能通,PING 呢?将你的LISTENER。ORA帖出来看看 。 中文,英文都是可以的。还是检查一下你的LISTENER.ORA文件是不是正确了 # LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 唐逃旺)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = 唐逃旺)(PORT = 2481)) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\Oracle\Ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = DATABASE) (ORACLE_HOME = D:\Oracle\Ora81) (SID_NAME = DATABASE) ) )"唐逃旺"是我的计算机名!服务器就在这个机子上!登录的时候始终出现:没有监听程序的错误!其它设置我都没改动! 方法一、你在Oracle菜单->Net8 Assistant中添加一个“监听程序”,然后配置正确的主机名(建议用IP地址,或者改成:127.0.0.1)->配置“服务命名”(主机名用:127.0.0.1)方法二、备份listener.ora文件,然后修改LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 2481)) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\Oracle\Ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = DATABASE) (ORACLE_HOME = D:\Oracle\Ora81) (SID_NAME = DATABASE) ) ) oracle 使用left join Win7旗舰版在安装Oracle11g R2时出现的问题 ubuntu安装oracle 10g:runInstaller无法找到文件 一个表中的某个列对应多个数据怎么设计表? 有关oracle数据库体系结构的问题 请问oracle9i里面内置了正则表达式函数嘛? 小问题! 请问metalink有没有中文的? proc 编译没错,执行出错,兄弟们看看,很简单的程序! 如何创建一个新表,其表结构和一个已有表的结构相同? 请问Oracle是如何实现乘方的 怎样判断表是否存在??
将你的LISTENER。ORA帖出来看看 。
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 唐逃旺)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 唐逃旺)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = DATABASE)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = DATABASE)
)
)
"唐逃旺"是我的计算机名!
服务器就在这个机子上!
登录的时候始终出现:没有监听程序
的错误!
其它设置我都没改动!
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = DATABASE)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = DATABASE)
)
)