Re: creating 2nd instance of Oracle?

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? (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
>:
>:
>:
Received on Tue May 14 1996 - 00:00:00 CEST