Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rollback_segment in initdbname_0.ora
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, BCReceived on Fri Jan 31 1997 - 00:00:00 CST