Re: create two db on the personal oracle

OK, there is no way I'm gonna claim any expertise here, so take everything with a LARGE BAG OF SALT...... BUT, I'm running PO 8.0.4 and I have 4 instances including the ORCL one and the D703 that Designer uses, as well as two for projects I'm fiddling with........

In the file that creates the oracle instance (not the database one, but the one thats an NT command) it has a line that sets the oracle_sid. Then it does the create and startup for the instance)... At least that's how all mine have worked. When I've had to delete an instance because of moving the database (I don't know WHY I had to, but I did...) I just ran the command file and things were fine again.......

I've created instances manually and had them created by other Oracle tools. So far no problem... OH, one thing... I can go into server manager and connect as internal. BUT, if I want to start the database with just a 'startup' instead of 'startup open pfile=...' I have to have the initfile for the database in the n:\orant\database directory.......... This APPEARS to hold true even when the instance was created with the pfile pointing to some other directory.......

OH, and I frequently have between 2 and 4 of the instances up and running concurrently.........

On 17 Jan 99 19:08:12 +0500, "Ewan Parker" <ewan_at_chimera.u-net.com> wrote:

>On 17-Jan-99 20:17:39, ba la said about 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"
>
>Server manager is looking for a password for "connect internal". You will
>need to create a pasword file in orawin95\database called pwdtest.ora. Use
>orapwd73 to do this. You will then be able to enter your chosen password and
>startup the instance "test".
>
>Regards,
>Ewan.
>
>--
><mailto:ewan_at_chimera.u-net.com>
>
Received on Sun Jan 17 1999 - 20:08:34 CST