Re: creating 2nd instance of Oracle?

In article <4nac1t$m82_at_usenetp1.news.prodigy.com> WBRD34A_at_prodigy.com (Yuri Ludevig) writes:
>Thanks, to everybody who answered my note. We were able to pass thru the
>first hurdle (startup nomount).
>The problem was that our init.ora file was named init.sid.ora (I could
>not find any reference to any particular name conventions in AIX) and
>Oracle expected the initsid.ora. As a result Oracle was going into
>default dir /oracle_home/dbs and
>picking up syst(first sid).dbf from there.
>I have another question. We created file system for system catalog with
>exaclty 40M size. On the create database we specified 40M on the datafile.
> The create fails saying that there is not enough space available. We
>reduced the size on the create one M at a time until 37M, and that worked.
> There are no other files in that file system. Who swallowed the 3 M?

I'd take a wild guess and say an oversized inode structure for the application. In other words, space for directories that you will never need.

>(The same situation was also true for the log files...).
>Thanks for your help, (Oracle still did not get back to us).
>Yuri in NY
>ccisaac_at_mtu.edu (Chuck Isaacson) wrote:
>>
>> Check the ifile file that you have referenced in the init.ora file.
>>The file names referenced must be unique to an instance. Especially
>>the control files and the ARCHPROD.
>>
>>Yuri Ludevig (WBRD34A_at_prodigy.com) wrote:
>>: I'm trying to create a second instance and database for the server
 that
>>: already has one. I'm running into problems already just by executing
>>: command "startup nomount pfile=(my startup file with a new sid in my
 

>>: directory)". It looks like Oracle is trying to read smth from the
 catalog
>>: of the first instance. I can't figure out why. What am I doing wrong?
 

>>: Manuals are pretty vague on the exact steps of creating 2nd instance.
 

>>: I've got a tar assigned but nobody called me back for a loooong time...
 

>>: Please H-E-L-P!!!
>>: Yuri in NY
>>:
>>:
>>:
>

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O