这是报错框
这是listener.ora的全部内容{
# listener.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\app\orcl\product\12.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\orcl\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)}
这是tnsnames.ora的全部内容{
# tnsnames.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
}
别的东西我都没动过 ,这两个文件的host值原来是localhost我改成了我的主机名。我是java初学者 今天刚学到oracle, 本来好好的可以用 , 到了要用DESC读取表格的时候就怎么也读不出来(写出来的表格是正常的)。后来DQL Developer程序就卡住了 。我强退了一下再进就这样了,求指教, 谢谢。
这是listener.ora的全部内容{
# listener.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\app\orcl\product\12.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\orcl\product\12.2.0\dbhome_1\bin\oraclr12.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)}
这是tnsnames.ora的全部内容{
# tnsnames.ora Network Configuration File: E:\app\orcl\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.124.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
}
别的东西我都没动过 ,这两个文件的host值原来是localhost我改成了我的主机名。我是java初学者 今天刚学到oracle, 本来好好的可以用 , 到了要用DESC读取表格的时候就怎么也读不出来(写出来的表格是正常的)。后来DQL Developer程序就卡住了 。我强退了一下再进就这样了,求指教, 谢谢。
解决方案 »
- 编译php5.2.8时,加上--with-oci8选项后make出错
- 有关在tomcat中设置oracle连接池的问题
- 程序中调用这个存储过程 ,要传进去 prmdormcode 等于 类似 "3,5,7,9"一组楼号集合字串,怎么办?
- sqlserver转oracle的问题:sqlserver的自增列的处理
- oracle往一张有130+万记录的表增加一个字段时遇到的问题
- 如何写这样的sql 在线等待
- 求思路、方案:组合表中的每个字段内容成一个长的字符串?
- 用一年了都没有问题今天突然出错,大家帮人看看
- 在EXP数据库时,含有CLOB字段的表备份不出来,具体报下面的错误!
- 如何解决并发访问问题?? 急!!!
- weblogic控制台中菜单点击没反应了,求解救。
- select j.user_id,s.username from AR_JPUSH_USER j join sysuser s on s.userid = j.
(ADDRESS = (PROTOCOL = TCP)(HOST = 194.168.124.2)(PORT = 1521))这个配置是错误的,缺少DESCRIPTION = 。很多信息。
你把它删除后,看下能不能登录。