found a way to corrupt oracle on NT - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

found a way to corrupt oracle on NT

found a way to corrupt oracle on NT# Database - 数据库

b*e2000-08-05 07:08

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*a2000-08-05 07:08

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*e2000-08-05 07:08

3 楼

no. not even after reboot.

【在 a*****a 的大作中提到】

: can't you just restart those services that you stopped?

a*a2000-08-05 07:08

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 的大作中提到】

T*e2000-08-05 07:08

5 楼

did you try SQL navigator? It's a powerful client

【在 b****e 的大作中提到】

: no. not even after reboot.

b*e2000-08-05 07:08

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