Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID

Re: Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID

From: <asokol99_at_my-deja.com>
Date: 2000/04/17
Message-ID: <8dfnh2$akj$1@nnrp1.deja.com>#1/1

Here are the steps to create a new database on Linux:

  1. create a new directory on any mount point, then create sub-directories where you will store your init, config files, as well, as destination directories for bdump, udump, cdump and arch. you may want to have a create directory where you can keep your create sql script. Create directory for your datafiles.
  2. use your appropriate shell command to change ORACLE_SID env to point to a new SID (let's for an example sake call it test1).
  3. start up svrmgrl, issue connect internal, and now run your sql script to create your database (i'm not going to go into the semantics what tablespaces you need etc, i assume you know that).
  4. update your listener.ora and tnsnames.ora files. you may also want to add a link from $ORACLE_HOME/dbs directory to point to your init file, so next time you want to start it you can just startup svrmgrl and issue startup command.

  (if you need a sql script to create a database let us know and we    will post one for you).

Alex Sokol

In article <sfmbnpdo5c246_at_corp.supernews.com>,   "Bruce" <bey_at_3eg.com> wrote:
> Hi,
>
> I was wondering if somebody can tell me how to create a new SID for a
 new
> Database in Linux using RedHat 6.1 and Oracle 8.0.5 Server Edition.
 In NT it
> is easy, but in Linux I am not certain how to do it. I was able to
 create a
> new database beside the default database, but the big question is how
 to
> connect to that database without the SID.
>
> Thanks in advance.
>
> Bruce
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 17 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US