由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - How to delete Oracle SID?
相关主题
Asking help for Access!:([转载] Oracle Database Administrator (DBA) and Developer
问一个转行到数据库方面的事,急求大家建议!新手求助: 学那个DATABASE软件好呢?
Re: How to populate data from text or MS ACCESS file to Oracle Database?How come I don't see Database Engine under MSSQLSERVER
Help needed: MS Access 2000Oralce for Linux 的问题
ASP可以用Oracle为数据库吗?Re: recursive sql?
how to remove oracle completelyDoes anybody have a certificate of MSDBA?
orcale 10g的问题oralce 9i certificate
安装Oracle 9i 在 XP home上总是出问题oralce 9i 必须装在professional 的windows 版本上?
相关话题的讨论汇总
话题: sid话题: oracle话题: delete话题: database话题: error
进入Database版参与讨论
1 (共1页)
g******p
发帖数: 18
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*****h
发帖数: 139
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******p
发帖数: 18
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******p
发帖数: 18
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?
1 (共1页)
进入Database版参与讨论
相关主题
oralce 9i 必须装在professional 的windows 版本上?ASP可以用Oracle为数据库吗?
Help for VB 6 and MS Access DBhow to remove oracle completely
analyze 在oracle里怎么用?orcale 10g的问题
Oracle DBA or MS SQL DBA? Which career path to choose?安装Oracle 9i 在 XP home上总是出问题
Asking help for Access!:([转载] Oracle Database Administrator (DBA) and Developer
问一个转行到数据库方面的事,急求大家建议!新手求助: 学那个DATABASE软件好呢?
Re: How to populate data from text or MS ACCESS file to Oracle Database?How come I don't see Database Engine under MSSQLSERVER
Help needed: MS Access 2000Oralce for Linux 的问题
相关话题的讨论汇总
话题: sid话题: oracle话题: delete话题: database话题: error