17,377
社区成员
发帖
与我相关
我的任务
分享关于oracle的配置问题
我的电脑在登陆到域的情况下无法使用oracle（可以启动服务，但是连接sql/plus总是提示监听程序有问题，如果登陆到本机就没有问题了），具体应该怎样配置，请大虾指点！
...全文
请发表友善的回复…
发表回复
sdjiang2004 2004-09-23
- 打赏
- 举报
自己顶一下
sdjiang2004 2004-09-18
- 打赏
- 举报
还是搞不定啊，总是报ORA-03113的错啊，郁闷中。。。
sdjiang2004 2004-09-18
- 打赏
- 举报
请问hepctyg(tang)，那么这个trace file 的文件名是什么呢？*.log?
tyg 2004-09-18
- 打赏
- 举报
ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support
huyi_1978 2004-09-18
- 打赏
- 举报
监听器损坏，使用“Net Configuration Assistant”工具向导的“监听程序配置”增加一个监听器即可。（在添加之前可能需要把所有的监听器先删除！）
zhaokeke2004 2004-09-16
- 打赏
- 举报
在tnsname.ora中把service_name后面的domain去掉.
zhaokeke2004 2004-09-16
- 打赏
- 举报
连接sql/plus时在service_name写成你原来的servive_name+domain
goldenwater78 2004-09-16
- 打赏
- 举报
在 sqlnet.ora 文件中（与tnsnames.ora在同一目录下）添加一行“NAMES.DEFAULT_DOMAIN = domain name” 其中domain name 为 本机所属的域名。
chanet 2004-09-16
- 打赏
- 举报
在配置网络服务名时，HOST参数 用 IP 方式
sdjiang2004 2004-09-16
- 打赏
- 举报
感谢楼上各位的帮助，明天去试看。
dinya2003 2004-09-16
- 打赏
- 举报
把你自己的administrator的权限添加到组权限中/.
