Re: Urgent Help!! Creating a new instance.

From: Feher Lajos <feherl_at_finit.hu>
Date: Wed, 08 Sep 1999 21:14:53 +0200
Message-ID: <37D6B5AD.97B99190@finit.hu>

Did you ever create instance on Digital. On Linux you must do similar than on Digital.
but anyway:
1. create a "home" directory for new instance. maybe $ORACLE_BASE/admin/<SID> with some subdir - create, pfile, exp, bdump, cdump, udump 2. create initSID.ora in pfile directory 3. create a script for CREATE DATABASE statement in create directory connect internal/oracle

---

startup nomount pfile=/oracle/app/oralce/admin/home/pfile/inithome.ora

CREATE DATABASE home

    DATAFILE '/u1/oradata/home/sys1home.ora' SIZE 50 M     LOGFILE GROUP 1 (/'u1/oradata/home/log11home.ora') SIZE 1M,

             GROUP 2 ('/u1/oradata/home/log21home.ora') SIZE 1M     CHARACTER SET EE8ISO8859P2
/

@?/rdbms/admin/catalog;
@?/rdbms/admin/catproc;
@?/rdbms/admin/catexp;
@?/rdbms/admin/utlxplan;
@?/rdbms/admin/catblock;

connect system/manager
@?/sqlplus/admin/pupbld;
connect internal/oracle

------------------ for a very small DB
4. create directory for db_files
5. set ORACLE_SID to your SID

6. svrmgrl, and run the script above
7. add new tablespaces - CREATE TABLESPACE DATA DATAFILE ' .....' SIZE 10M; - for example
8. create new rollback segments and take online them 9. make a simlink: .../pfile/initSID.ora ...8.0.5/dbs/initSID.ora 10. create a password file with orapwd utility 11. modify your oratab file
that's all i think

I hope this help you

feherl

Alicia Irvin wrote:

> I am running Oracle 8.0.5 on Digital Unix and need to create a new instance
> using Linux.
>
> Exactly how do I create the instance?
>
> All documentation I have on Instances points to the 'system specific'
> manuals which unfortunately are unavailable to me at this time.
>
> Thanks for any help given,
> Alicia.
Received on Wed Sep 08 1999 - 14:14:53 CDT