Re: create two db on the personal oracle

John,

thanks for your reply. Since I am not very familiar with the oracle running on pc, therefore, I don't know how to get all the environment variable set correctly. I use the

set ORACLE_SID=test

in the dos prompt and I assume this will set the ORACLE_SID to my desired instance name.

but while I use the svrmgr and connect internal, it prompts me for password. I don't know what should be the password for it. Therefore, I cannot create the database manually myself. Appreciate for your help in advance if you have any to share. many thanks.

Ken Chow

ps. I have the orcl database created on my pc now and wanna to create one more called "test"

Jurij Modic wrote in message <36a1d367.6688137_at_news.siol.net>...
>On Sun, 17 Jan 1999 17:40:01 -0800, John Koo <johnkoo_at_i-wave.net>
>wrote:
>
>>ba la wrote:
>>>
>>> Hi,
>>>
>>> I wanna to create two database on my pc where the personal oracle 8
>>> was installed. But I don't know where or how to set the ORACLE_SID.
>>> Appreciate for your information. thanks.
>>>
>>> Ken Chow
>>
>>Personal Oracle ?? as far as I can remember, it is not able to create
>>more than one instance. Get standard / enterprise edition instead. And it
>>is not able to change SID other than ORCL in personal oracle. I hope this
>>can help.
>
>You can create more than one instance of PO, however because you have
>to have a separate ORACLE_HOME for each instance you are able to run
>only one of them simultaneously.
>
>And yes, you can name your SID whatever you want it (mine for example
>is named "PO73"). But to achieve this, you must create your database
>manualy, defaultly instaled instance is allways named ORCL. This is
>true for PO 7.3, I don't know if it's changed in PO8.
>
>>John Koo
>>johnkoo_at_i-wave.net
>
>Regards,
>Jurij Modic <jmodic_at_src.si>
>Certified Oracle7 DBA (OCP)
>================================================
>The above opinions are mine and do not represent
>any official standpoints of my employer
Received on Sun Jan 17 1999 - 09:17:39 CST