关于oracle10g监听的问题 oracle 在windows上的监听器常常遇到问题自动启动的时候,有时候没有启动起来,就需要手工启动有时候在服务列表看到已经启动,但是还是Tns错误,就需要重新启动 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 比着下面的看1、LISTENER内容# listener.ora Network Configuration File: /oracle/product/10g/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10g) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.201.128.1)(PORT = 1521)) ) ) )2.TNSNAMES内容# tnsnames.ora Network Configuration File: /oracle/product/10g/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 130.201.128.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) netstat -an看看1521端口有没有打开,没打开就多建几次监听器,直到打开了为止 oracle类型问题 SQLPLUS问题 一个SQL的问题 关于sqlerrd[2]的运用,求助!!! BLOB字段使用问题。 怎么在sql Plus中备份数据表?请指教! 请教,如何再Oracle中实现数据库的备份? 帮我一下?ora-00101:invalid specification for system parameter MTS-DISPATCHERS OraOLEDBpus10.dll: 找不到指定的模块,google好长时间,找不到解决办法 求论坛高手帮忙分析分析 oracle小问题,请高手帮忙!问题解决便可结贴! 2个表联合的视图
1、LISTENER内容# listener.ora Network Configuration File: /oracle/product/10g/network/admin/listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10g)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.201.128.1)(PORT = 1521))
)
)
)
2.TNSNAMES内容# tnsnames.ora Network Configuration File: /oracle/product/10g/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.201.128.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
看看1521端口有没有打开,没打开就多建几次监听器,直到打开了为止