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

Alex,

thanks for your input, I will did it your way before, I think my problem is using the right shell command for switching the instances. Do I use set oracle_sid=xxxx in the sh environment?

Bruce
asokol99_at_my-deja.com wrote in message <8dfnh2$akj$1_at_nnrp1.deja.com>...
>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 Thu Apr 20 2000 - 00:00:00 CDT