b****e 发帖数: 1275 | 1 i've had this happen to me a couple of times before which
resulted in my refomatting the whole machine.. ie.
svrmgrl or sqlplus can't get me into oracle - instead i get
ORA-03113: end-of-file on communication channel
after the format and clean install everything is fine..
and then i did this: went into services and stopped
oracle (tns listener, web assitstant, and then the
oracle server itself, in that order)
then i'm able to reproduce this ORA-03113 error. any
oracle guys want to help me out?
t |
a*****a 发帖数: 438 | 2 can't you just restart those services that you stopped?
【在 b****e 的大作中提到】 : i've had this happen to me a couple of times before which : resulted in my refomatting the whole machine.. ie. : svrmgrl or sqlplus can't get me into oracle - instead i get : ORA-03113: end-of-file on communication channel : after the format and clean install everything is fine.. : and then i did this: went into services and stopped : oracle (tns listener, web assitstant, and then the : oracle server itself, in that order) : then i'm able to reproduce this ORA-03113 error. any : oracle guys want to help me out?
|
b****e 发帖数: 1275 | 3 no. not even after reboot.
【在 a*****a 的大作中提到】 : can't you just restart those services that you stopped?
|
a***a 发帖数: 39 | 4 Try this...
Problem Description:
====================
You are starting up a database and receive the following
error message:
ORA-3113: end-of-file on communication channel
Problem Explanation:
====================
The services were created by and/or you are logged to NT as
a user
who does not have administrative privileges on the system.
Solution: EXPLICITLY NAME THE OWNER OF THE NT SERVICES
Solution Description:
=====================
You must explicitly name the owner of the NT services. D
【在 b****e 的大作中提到】 : i've had this happen to me a couple of times before which : resulted in my refomatting the whole machine.. ie. : svrmgrl or sqlplus can't get me into oracle - instead i get : ORA-03113: end-of-file on communication channel : after the format and clean install everything is fine.. : and then i did this: went into services and stopped : oracle (tns listener, web assitstant, and then the : oracle server itself, in that order) : then i'm able to reproduce this ORA-03113 error. any : oracle guys want to help me out?
|
T**e 发帖数: 424 | 5 did you try SQL navigator? It's a powerful client
【在 b****e 的大作中提到】 : no. not even after reboot.
|
b****e 发帖数: 1275 | 6 i use toad.. the issue here is not about using a
tool to look at the db.. it's being able to
connect to the db itself
i'll try the other solutin posted earlier :)
【在 T**e 的大作中提到】 : did you try SQL navigator? It's a powerful client
|