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

Home -> Community -> Usenet -> c.d.o.server -> Re: rollback_segment in initdbname_0.ora

Re: rollback_segment in initdbname_0.ora

From: Barry P. Grove <barry_grove_at_mindlink.bc.ca>
Date: 1997/01/31
Message-ID: <32F2C60E.1FA2@mindlink.bc.ca>#1/1

Oliver Belikan wrote:
>
> the initdbname_0.ora sets rollback_segment =().
> Starting the db, the error ORA-1534 Rollback segement '' doesn´t exist
> occur.
> What is the cause ? How could i solve the Problem ?

Hi Oliver,

Usually during Oracle install, two init.ora files are created:   initdbname_0.ora
and
  initdbname.ora
The first is used during the initial creation of the database before other
rollback segments have been created: only SYSTEM will exist after the create database command. The second init.ora file is the one used by default when use startup your database and do not name an initialization file. Whatever rollback segments you create should be listed in the   rollback_segment=()
parameter.

Remember you need to have two rollback segments defined in SYSTEM tablespace
before creating other tablespaces: the SYSTEM rb is there, create another
BOOTSTRAP rollback segment, then create tablespace(s) to hold your other rollback segments.

-- 
Barry P. Grove                                  BCTEL  (604)432-4468
barry_grove_at_mindlink.bc.ca                      Human Resources
Consulting
Developer, Oracle DBA, Unix Sysadmin            6-3777 Kingsway,
Burnaby, BC
Received on Fri Jan 31 1997 - 00:00:00 CST

Original text of this message

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