How to delete Oracle SID? - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Database - 数据库

How to delete Oracle SID?

How to delete Oracle SID?# Database - 数据库

g*p2001-05-28 07:05

1 楼

Hi,
I have Oracle Personal Edition on Win98. At the time I set
it up, I somehow set up the SID twice, now I am having
problem, either ASP or Java code that calls the database
will sometimes(not always) caused error when starting up the
database, an error message box for ostart.exe.
I wonder if I just delete one of the SID will work but don't
know how to do that.
Any help is appreciated.

w*h2001-05-28 07:05

2 楼

It's OK you have multiple SID (multiple instances). But you need to
change the envrioment variable ORACLE_SID when you change SID.

【在 g******p 的大作中提到】

: Hi,
: I have Oracle Personal Edition on Win98. At the time I set
: it up, I somehow set up the SID twice, now I am having
: problem, either ASP or Java code that calls the database
: will sometimes(not always) caused error when starting up the
: database, an error message box for ostart.exe.
: I wonder if I just delete one of the SID will work but don't
: know how to do that.
: Any help is appreciated.

g*p2001-05-28 07:05

3 楼

The problem I have is, sometimes it gives errors when java
or asp codes are accessing Oracle. Sometimes startup error.
So I want to have just one so there is no confusion.

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

: It's OK you have multiple SID (multiple instances). But you need to
: change the envrioment variable ORACLE_SID when you change SID.

g*p2001-05-28 07:05

4 楼

I found Oralce Database Configuration Assistant which
can delete a database, which is just what I want.
Unfortunately, it prompts me to enter INTERNAL
password, I remember when installing the database, it
showed up as hidden:******, does anyone know what this
password is?