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

Hi Jimmy,

I will address the 7.3 part of your question. Instances are usually created by using the Oracle Instance Manager in GUI-mode (just run oradim73.exe without parameters). You should use the advanced tab to specify any non-standard settings. Please note: the init<sid>.ora should already exist. This procedure will generate a createdb on the fly, which in turn will run catalog.sql and catproc.sql.

The createdb you are referring to is a special one. The so-called 'starter' database is stored zipped on the CD-Rom and unpacked to %ORACLE_HOME%\database. The only thing this createdb needs to do is create a controlfile.

Hth,

Sybrand Bakker, Oracle DBA

On Sat, 25 Sep 1999 20:43:28 -0700, Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:

>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 - 08:40:40 CDT