Oracle 7.3 (and 8i) files on Solaris, NT questions. Please help ...

From: Jimmy <c6635500_at_comp.polyu.edu.hk>
Date: Sat, 25 Sep 1999 20:41:18 -0700
Message-ID: <37ED95DE.17901855@comp.polyu.edu.hk>

Hello all,

    I used Oracle 7.3 on Solaris 2.5. I know that each instance (in my case) has the following related files:

    init<SID>.ora
    config<SID>.ora
    crdb<SID>.sql
    crdb2<SID>.sql (this file is used to create tablespaces for rollback segments, temporary segments, database tools segments etc. Moroever, it run catalog.sql, catdbsyn.sql etc)

    If I want to create a new instance, just create a new set of these files with the new SID name and run these files manually and it can create another new instance.

    Now, move to Windows NT server 4.0. I find that Oracle 7.3 has only following files:

    init<SID>.ora (this file content, in fact, combine init<SID>.ora and config<SID>.ora as in Solaris)

    createdb.sql (this file content is similiar with crdb<SID>.sql as in Solaris)

    I only want to create a new instance by running these files manually (not using other tools).

    My question is : Why no crdb2<SID>.sql as in Solaris on Windows NT? Is Oracle use another file name on Windows NT? Moreover, there is no SID name in createdb.sql. If I create another new instance, how can I specify which instance use which createdb.sql file?

    The createdb.sql has the following content:

---

spool E:\ORANT\DATABASE\createdb.log
connect internal_at_2:orcl
startup nomount pfile=E:\ORANT\DATABASE\initorcl.ora create controlfile reuse set database oracle

datafile 'E:\ORANT\DATABASE\sys1orcl.ora',


         'E:\ORANT\DATABASE\tmp1orcl.ora',


         'E:\ORANT\DATABASE\rbs1orcl.ora',


         'E:\ORANT\DATABASE\usr1orcl.ora'


logfile  group 1 ('E:\ORANT\DATABASE\log1orcl.ora',
                  'E:\ORANT\DATABASE\log2orcl.ora') size 1M,
         group 2 ('E:\ORANT\DATABASE\log3orcl.ora',
                  'E:\ORANT\DATABASE\log4orcl.ora') size 1M resetlogs;

alter database oracle open resetlogs;
update props$ set VALUE$ = 'WE8ISO8859P1' where NAME = 'NLS_CHARACTERSET';
commit
shutdown
spool off
exit

---

    And Oracle 8i on Windows NT server 4.0. I only find the following file:

    init<SID>.ora. The content of this file is "IFILE='D:\Oracle\admin\CANTONA\pfile\init.ora'".

    And I cannot find other file content like crdb<SID>.sql or createdb.sql.

    What are the file names related with each instance of Oracle 8i?

Thanks,
Jimmy Received on Sat Sep 25 1999 - 22:41:18 CDT