查看:listener.ora(去掉多余的条目,并且改PROTOCOL 为TCP)
# 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 = TCP)(HOST = yang)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
# 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 = TCP)(HOST = yang)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
解决方案 »
- 这个sql语句该怎么写?!!!
- 这个sql语句老报错,应该怎样改?
- merge into语句操作一个表产生重复记录的问题
- 如何终止JOB执行、查看jobno?
- 如何提取oracle中每隔10分钟添加的纪录数
- Oracle中,VARCHAR2类型的变量如何可以比较大小么?可以选定一个范围么?
- varchar2 的字段为空在查询的时候应该怎么写条件?
- function 中是否不能用 dbms_sql啊
- select 里面可以嵌套吗?
- 谁有通过tuxedo,采用fml传送数据的例子。
- 无法启动OracleOraHome81ManagementServer服务
- 請問怎樣用ASP ﹐JSP 中的方法或函數將"字符型"轉成"數字型 ",謝謝
properly in the registry.
If you are using terminal services client to login to
a remote server, You will get this error. You can't
terminal service client to use server level utilities
like svrmgrl, rman etc... Please do this on the
server.Hope this helps
(2)listener.ora配置问题,贴出来看看!
(3)输入了错误的服务名或者实例名,这是最可能出现的问题
(4)通讯协议的问题,在监听配置中确保只有一个TCP协议,1521端口的监听器,删除掉所有其它的监听器,我记得每次装好了以后,系统都会装几个不用的监听器,请删除他们!
tns还有错是我的话 调不好就重装 windows一起重装最好你是单机用 不用tns也可用sqlplus操作数据库的嘛 windows不是有什么ps补丁之类的什么东西 装装看