初学:登录Dba Studio连接数据库时发生"包写入失败"错误? 检查你的tns的配置是不是有问题! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我的tnsnames.ora文件如下:# TNSNAMES.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\tnsnames.ora# Generated by Oracle configuration tools.O8IBEGIN = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = soft1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = o8ibegin) ) )ORADB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = soft1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = oradb) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )********************************************************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 = soft1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = soft1)(PORT = 2481)) ) )SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = d:\Oracle\Ora81) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = oradb) (ORACLE_HOME = d:\Oracle\Ora81) (SID_NAME = oradb) ) (SID_DESC = (GLOBAL_DBNAME = o8ibegin) (ORACLE_HOME = d:\Oracle\Ora81) (SID_NAME = o8ibegin) ) )有什么问题吗? 我建议你还是重新设置一下,反正不是太烦,再说从你报错的现象看多数是你的tns配置有问题! 你确定Oracle Service起来了嘛? OracleWebAssistant0OracleServiceORADBOracleServiceO8IBEGINOracleOraHome81TNSListener这几个服务我都起来了呀 tnsname.ora中的SERVICE_NAME在那看啊?本人初学不好意思 各位大侠帮帮忙,求方法 ,着急,在线等 求一sql语句,在线等待 相同的表结构,存储过程可以在817上编译9i上为什么不行? oracle10g 有这个工具 logminer viewer 吗? 只剩一个数据文件了,怎么恢复 sqlserver2000导入数据到Oracle9i?急 在线等侯:安装完oracle 9i以后,忘记了sid该如何得到? 奇怪的ORACLE客户端连接问题,HELP oracel自增长报错 如何删除一个表空间文件啊? 关于oracle 配置的问题
# TNSNAMES.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.O8IBEGIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = soft1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = o8ibegin)
)
)ORADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = soft1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oradb)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
********************************************************
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 = soft1)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = soft1)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oradb)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = oradb)
)
(SID_DESC =
(GLOBAL_DBNAME = o8ibegin)
(ORACLE_HOME = d:\Oracle\Ora81)
(SID_NAME = o8ibegin)
)
)有什么问题吗?
OracleServiceORADB
OracleServiceO8IBEGIN
OracleOraHome81TNSListener这几个服务我都起来了呀