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? |
|