问protocol adapter error 如何解决 启动SQLPLUS时候报错。监听我都配置了啊? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 监听启动成功没?另外,Listener.ora贴出来看看。 如果没有数据库启动,启动数据库c:>sqlplus "/ as sysdba"sql>startup如果监听没有启动,启动监听c:>lsnrctl start 看看实例和服务都启动了不,要不就看看Listener.ora有没问题 # listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )=====================================================================================Listener.ora是要的这个吗?我的服务好想只启动了10G客户端的监听。10G本身的监听貌似没有启动? # listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = D:\oracle\product\10.2.0\db_1) (PROGRAM = extproc) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) )=====================================================================================Listener.ora是要的这个吗?我的服务好想只启动了10G客户端的监听。10G本身的监听貌似没有启动? Oracle中关于权限的问题 oracle 调优 statspack报告分析 数据库升级移植的问题(100分) 求一函数 sql ——语句 同一个数据库orcl,用system用户创建的表,为什么用scott用户登录就访问不了? 高分求PL/SQL脚本,谢谢 本人初学者,请您帮助我解释下这段代码的含义好吗? .net 调用oracle 编写的存储过程,怎样得到表的集合 急!!!那位大哥帮帮忙 触发器的错误,找了半天没发现?急 SQL问题
c:>sqlplus "/ as sysdba"
sql>startup
如果监听没有启动,启动监听
c:>lsnrctl start
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
=====================================================================================
Listener.ora是要的这个吗?我的服务好想只启动了10G客户端的监听。10G本身的监听貌似没有启动?
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
=====================================================================================
Listener.ora是要的这个吗?我的服务好想只启动了10G客户端的监听。10G本身的监听貌似没有启动?