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

Thanks Alex:

I know now where I made the mistake. The reason I was using sh is, that a lot of people recommend to install 8.0.5 in the sh shell, since I have to reinstall ora anyway I will try the borne shell. Thanks again.

Bruce
asokol99_at_my-deja.com wrote in message <8dnbmd$q3l$1_at_nnrp1.deja.com>...
>Bruce:
> in Korn (ksh)/Borne (sh) shells you use the following:
> $ ORACLE_SID=sid1; export ORACLE_SID
>
> in C shell (csh) you use the following:
> % setenv ORACLE_SID sid1
>
> since i usually use csh, i have an alias which i created in
> .cshrc file:
> alias sid "setenv ORACLE_SID \!*"
>
> so, when i need to switch to a new database instance i just use:
> % sid newname
>
> RH uses bash as default shell ("Borne again") which behaves like
> regular Borne shell in terms of environment variables.
>
>Alex
>
>In article <sfu1fbqkl6e28_at_corp.supernews.com>,
> "Bruce" <bey_at_3eg.com> wrote:
>> 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.
>> >
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
Received on Fri Apr 21 2000 - 00:00:00 CDT