Re: Create Database issues

<argosy22_at_my-deja.com> wrote in message news:8bp5nc$hon$1_at_nnrp1.deja.com...
> Hi,
>
> On the same Oracle instance, I could create a second database,
> without destroying the first one. Good. :)
>
> However, I can't open it now.
> It gives me a problem on the Rollback space.
>
> To create, I used the statement:
>
> create database ltfd1
> DATAFILE '/data/ltfd1/sys1.dbf' SIZE
> 50M
> MAXLOGFILES 5
> MAXLOGHISTORY 100
> MAXINSTANCES 1
> MAXDATAFILES 10
> ARCHIVELOG
> EXCLUSIVE
> CHARACTER SET AL24UTFFSS
> LOGFILE
> GROUP 1 ( '/work/oralogs/ltfd1/redo01.log') SIZE 4M,
> GROUP 2 ( '/work/oralogs/ltfd1/redo02.log') SIZE 4M,
> GROUP 3 ( '/work/oralogs/ltfd1/redo03.log') SIZE 4M
>
>
>
> When I try to open, this is what I get:
>
> SVRMGR> startup open
> ORACLE instance started.
> Total System Global Area 6092056 bytes
> Fixed Size 39816 bytes
> Variable Size 5527952 bytes
> Database Buffers 491520 bytes
> Redo Buffers 32768 bytes
> Database mounted.
> ORA-01534: rollback segment 'ROLL1_RBS' doesn't exist
>

The init.ora file you are using presumably starts up your first database with a reference to a parameter ROLLBACK_SEGMENTS=, which is set to (at least) ROLL1_RBS. Why you are trying to start a second database with a parameter file used to start a first, I have no idea. It's a big no-no.

You could start by editing out the ROLLBACK_SEGMENTS parameter in your init.ora -but then you will find that the next time you re-start your first database, it will come on-line with zero rollback segments.

Honestly: one database, one parameter file. And one parameter file that has been edited to make sense for the database it supposed to be opening. HJR
>
>
> alter database ltfd1
> mount exclusive
> open
>
> ORA-00933: SQL command not properly ended
>
>
> alter database ltfd1 open
>
> ORA-00704: bootstrap process failure
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00955: name is already used by an existing object
>
>
>
> Create public rollback segment ROLL1_RBS
>
> ORA-01109: database not open
>
>
>
> The database won't open because it doesn't have a
> rollback segment. But I can't create the rollback
> statement without opening the database.
>
> Does anyone have any suggestions?
>
> Thanks,
>
> Argosy
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Mar 31 2000 - 08:20:40 CST