求教一ORACLE问题 - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

求教一ORACLE问题

求教一ORACLE问题# Database - 数据库

s*i2001-07-03 07:07

1 楼

我上次LOGIN ORACLE时候,一切还非常的正常;但是,今天开机,再次LOGIN,想做完那份ASSIGNMENT时,居然给了我两个错误信息
1. ORA-01034 ORACLE not available
2. ORA-27101 shared memory realm does not exist
无论我如何重启,它还是给我同样的错误信息......
求教各鑫淮笙有没有什么解救方法,文欠軦SSIGNMENT我才做了1/3呀......
顺便一提,我的O/S是WINDOWS2000,装的ORACLE是8.1.7.0.0
谢了,谢了......

a*w2001-07-03 07:07

2 楼

First, find all the Oracle processes and kill all of them.
Then, try to use "svrmgrl" to shutdown and restart. If
still error, try to reinstall.

【在 s*****i 的大作中提到】

: 我上次LOGIN ORACLE时候,一切还非常的正常;但是,今天开机,再次LOGIN,想做完那份ASSIGNMENT时,居然给了我两个错误信息
: 1. ORA-01034 ORACLE not available
: 2. ORA-27101 shared memory realm does not exist
: 无论我如何重启,它还是给我同样的错误信息......
: 求教各鑫淮笙有没有什么解救方法,文欠軦SSIGNMENT我才做了1/3呀......
: 顺便一提,我的O/S是WINDOWS2000,装的ORACLE是8.1.7.0.0
: 谢了,谢了......

s*i2001-07-03 07:07

3 楼

i've tried that out, but when i was in the process running
the "svrmgrl", it gave me this error: "ORA-01031:
insufficient privileges". what should i do now? :(

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

: First, find all the Oracle processes and kill all of them.
: Then, try to use "svrmgrl" to shutdown and restart. If
: still error, try to reinstall.

a*w2001-07-03 07:07

4 楼

type svrmgrl
> connect as system/manager as sysdba;
then you should have system privileges.

【在 s*****i 的大作中提到】

: i've tried that out, but when i was in the process running
: the "svrmgrl", it gave me this error: "ORA-01031:
: insufficient privileges". what should i do now? :(