Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID 
Author Message
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID
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



Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID

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



Quote:
> 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.


Wed, 18 Jun 1902 08:00:00 GMT
 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

Quote:

>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



>> 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.



Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID
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



Quote:
> 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

> >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



> >> 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.


Wed, 18 Jun 1902 08:00:00 GMT
 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

Quote:

>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



>> 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

>> >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



>> >> 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.



Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID
Hi Alex,

I saw your Deja post on creating an Oracle DB on
Linux. I recently installed Oracle 8.0.5 on Linux
and was wondering about things like creating new
instances, tablespaces, users, tables, etc. I
sucsessfully set up the test DB and installed
some tables from the O'Reilly SQL*Plus book - but
did it in Scott/Tiger's schema - just was
wondering how to do it for a new
user/schema/instance. Can you recommend a
resource to learn these basics (from the command
line - i don't think my 8.0.5 linux ee comes with
the enterprise manager) or do you know of any
FAQ's, scripts, etc. I'll bet there's loads of
people who could use this info! This is a good
start but more on the other things would be
helpful. Thanks in advance,
Bill Moss

take the . out of bill.moss


Quote:

> 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:
Quote:
>     % sid newname

>    RH uses bash as default shell ("Borne

again") which behaves like
Quote:
>    regular Borne shell in terms of environment
variables.

> Alex



> > 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
Quote:
> set
> > oracle_sid=xxxx in the sh environment?

> > Bruce



Quote:
> > >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
Quote:
> > >   well, as destination directories for

bdump, udump, cdump and arch.
Quote:
> > >   you may want to have a create directory

where you can keep your
Quote:
> > >   create sql script. Create directory for
your datafiles.

> > >2. use your appropriate shell command to

change ORACLE_SID env to
Quote:
> > >   point to a new SID (let's for an example

sake call it test1).
Quote:

> > >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
Quote:
> > >    etc, i assume you know that).

> > >4. update your listener.ora and tnsnames.ora

files. you may also want
Quote:
> > >   to add a link from $ORACLE_HOME/dbs

directory to point to your
Quote:
> > >   init file, so next time you want to start

it you can just startup
Quote:
> > >    svrmgrl and issue startup command.

> > >  (if you need a sql script to create a

database let us know and we
Quote:
> > >   will post one for you).

> > >Alex Sokol

> > >In article


Quote:

> > >> Hi,

> > >> I was wondering if somebody can tell me

how to create a new SID
Quote:
> for a
> > >new
> > >> Database in Linux using RedHat 6.1 and

Oracle 8.0.5 Server Edition.
Quote:
> > >In NT it
> > >> is easy, but in Linux I am not certain how

to do it. I was able to
Quote:
> > >create a
> > >> new database beside the default database,

but the big question is

Quote:
> 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.

Sent via Deja.com http://www.deja.com/
Before you buy.


Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID
Hi Bill,
  well, you asked a question which would require quite a bit
  of time to explain. I will do my best to answer quickly in
  5-10 minutes so i can get back to my job - administering
  Oracle development environment in my company. But before i
  do that i strongly recommend to purchase a book by Michael Ault
  "Oracle 8i Administration and Management" (and don't waste your
  money on any of that Osborne/Oracle garbige). That book covers
  mostly Unix env and should be sufficient for Linux. He has a book
  for NT (I think it's called "Oracle on NT Black Book").
  If you can't get it, the second best are books by Donald Burleson,
  but i would go with Michael Ault first.

  In Oracle world, instance and database sometimes are two different
  meanings and sometimes is the same thing - depending on the
  situation and the subject,mostly because each user essentially
  can have it's own database, refered to as schema. Therefore, when
  someone says instance, he/she means the set of processes and global
  memory, shared by all "databases/schemas" within that instance.
  When you as a SYSDBA, create a new user and grant CONNECT and
  RESOURCE roles to it along with some quota or unlimited quota
  on some tablespace, that user can create objects, which will be
  "stored" in that user's schema and noone except SYSDBA can change
  them or even put any data in it. I mentioned tablespace. It's a
  logical repository for Oracle objects. Different users can share
  the same tablespaces, but if you would like to separate them for
  maintenance purpose you should create separate tablespaces for
  separate schemas, because when/if you need to do online(hot)
  backups of those shared tablespaces noone would be able to change
  any data in them during that time.
  Tablespaces consists of datafiles, which is Oracles's physical storage
  plan carefully how you will spread them across the instance - this is
  where your performance will come (of course, your SQL comes first,
  but we are not touching it here).
  8.0.5 EE comes with Enterprise Manager, and it's not too bad. I
  would strongly suggest to learn Oracle administration from the
  command line if you are planning on making a carrier in that field.
  Mainly because if you ever need to do any type of support remotely
  you probably won't have any graphical interface and if don't
  become intimately familiar with data dictionary and dba and v$ views
  you will be in troubles. Once you are comfortable with those things,
  you can use some GUI to speed up your work and save time.


Quote:

> Hi Alex,

> I saw your Deja post on creating an Oracle DB on
> Linux. I recently installed Oracle 8.0.5 on Linux
> and was wondering about things like creating new
> instances, tablespaces, users, tables, etc. I
> sucsessfully set up the test DB and installed
> some tables from the O'Reilly SQL*Plus book - but
> did it in Scott/Tiger's schema - just was
> wondering how to do it for a new
> user/schema/instance. Can you recommend a
> resource to learn these basics (from the command
> line - i don't think my 8.0.5 linux ee comes with
> the enterprise manager) or do you know of any
> FAQ's, scripts, etc. I'll bet there's loads of
> people who could use this info! This is a good
> start but more on the other things would be
> helpful. Thanks in advance,
> Bill Moss

> take the . out of bill.moss



> > 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



> > > 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


> > > >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


> > > >> 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.

> Sent via Deja.com http://www.deja.com/
> Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID

Quote:

> Hi Bill,

[skip]

Quote:
>   maintenance purpose you should create separate tablespaces for
>   separate schemas, because when/if you need to do online(hot)
>   backups of those shared tablespaces noone would be able to change

                                              ^^^^^^^^^^^^^^^^^^^^^^^
Quote:
>   any data in them during that time.

I think you need read original documentation by Oracle instead of those
books ;)
--
----------------------------

ICQ: 34433616


Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID

Quote:
> >   maintenance purpose you should create separate tablespaces for
> >   separate schemas, because when/if you need to do online(hot)
> >   backups of those shared tablespaces noone would be able to change
>                                               ^^^^^^^^^^^^^^^^^^^^^^^
> >   any data in them during that time.
> I think you need read original documentation by Oracle instead of
those
> books ;)
> --
> ----------------------------

> ICQ: 34433616

What do you mean by "^^^^^^^^^^^^^^^^^" those words?

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID

Quote:

>> >   maintenance purpose you should create separate tablespaces for
>> >   separate schemas, because when/if you need to do online(hot)
>> >   backups of those shared tablespaces noone would be able to change
>>                                               ^^^^^^^^^^^^^^^^^^^^^^^
>> >   any data in them during that time.
>> I think you need read original documentation by Oracle instead of
> those
>> books ;)
> What do you mean by "^^^^^^^^^^^^^^^^^" those words?

I mean a man who read a lot clever books about Oracle must know
that during online (hot) backup it is possibly any data manipulation and
data change too.
--
----------------------------

ICQ: 34433616


Wed, 18 Jun 1902 08:00:00 GMT
 Req help: Oracle 8.0.5 Server Edition and RedHat Linux 6.1, creating a new SID


Quote:

> >> >   maintenance purpose you should create separate tablespaces for
> >> >   separate schemas, because when/if you need to do online(hot)
> >> >   backups of those shared tablespaces noone would be able to
change

^^^^^^^^^^^^^^^^^^^^^^^
Quote:
> >> >   any data in them during that time.
> >> I think you need read original documentation by Oracle instead of
> > those
> >> books ;)
> > What do you mean by "^^^^^^^^^^^^^^^^^" those words?
> I mean a man who read a lot clever books about Oracle must know
> that during online (hot) backup it is possibly any data manipulation
and
> data change too.
> --
> ----------------------------

> ICQ: 34433616

I stand corrected that you CAN make data changes during hot backups
and I tried to relate the point that at some times during tablespace
maintenance when you must put it offline all users with the objects
in them are effected.
My mistake still doesn't make Oracle books any better and noone I know
has anything good to say about them. On the contrary, the books I
suggested earlier (which you labeled as "clever books") used by many
colleagues of mine, who are far more experienced in the subject then
me but still use them routinely (which i can't say about oracle
publications).

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 11 post ] 

 Relevant Pages 

1. Oracle 8.0.5 on Redhat Linux 6.1?

2. Oracle 8i on Redhat LINUX 6.1

3. Oracle 8i on Redhat Linux 6.1

4. PROBLEMS INSTALLING ORACLE 8.05 on LINUX RedHat 6.1

5. Oracle 8.1.5 Installation on RedHat Linux 6.1

6. create new tablespace (redhat linux 6.2 + oracle 8i)

7. Need help on oracle 8i and oas4081 on redhat 6.1

8. OUIProcess error on RedHat Linux 6.1

9. Starting ORB on OAS 4071 on RedHat Linux 6.1

10. Sybase 11.9.2 on Linux 6.1 - RedHat

11. ODBC Setup for Sybase 11.9.2 on RedHat Linux 6.1

12. Enterprise Replication Problems on Linux Redhat 6.1


 
Powered by phpBB® Forum Software