Re: dbca error
From: Palooka <nobody_at_nowhere.com>
Date: Sat, 31 Jan 2009 03:17:07 +0000
Message-ID: <XoPgl.8$pR5.2_at_newsfe24.ams2>
macmenco wrote:
> Hello all,
>
> I've been playing around with an 11g DB. I installed it on OEL 5.2 (no
> updates / no subscription) and did a software only install. Then I
> patched it to 11.1.0.7.0. After that I wanted to create a starters
> database, so I fired up DBCA, selected a General Purpose database and
> said "Go !".
> But half way through I got a "Disconnection Forced" message. After
> doing some research/testing, the problem apears only in the templates.
> Yes, also in the Datawarehouse template. The only way to create a
> database, is a custom database. I searched metalink and only found
> something suggesting I changed the blocksize to something different
> then 8K. Well, I didn't. I even tried adding the template datafiles to
> an existing DB and dumped the headers with "alter session set events
> 'immediate trace name FILE_HDRS level 10';". The trace file tells me
> it is 8K. I even tried copying the template again and dump again.
> Still 8K.
>
> Am I missing something, or is there a little bug in DBCA
> (11.1.0.7.0) ? Anybody got the same experience ?
>
> Kind regards,
> Menco
Just a couple of small questions.
Date: Sat, 31 Jan 2009 03:17:07 +0000
Message-ID: <XoPgl.8$pR5.2_at_newsfe24.ams2>
macmenco wrote:
> Hello all,
>
> I've been playing around with an 11g DB. I installed it on OEL 5.2 (no
> updates / no subscription) and did a software only install. Then I
> patched it to 11.1.0.7.0. After that I wanted to create a starters
> database, so I fired up DBCA, selected a General Purpose database and
> said "Go !".
> But half way through I got a "Disconnection Forced" message. After
> doing some research/testing, the problem apears only in the templates.
> Yes, also in the Datawarehouse template. The only way to create a
> database, is a custom database. I searched metalink and only found
> something suggesting I changed the blocksize to something different
> then 8K. Well, I didn't. I even tried adding the template datafiles to
> an existing DB and dumped the headers with "alter session set events
> 'immediate trace name FILE_HDRS level 10';". The trace file tells me
> it is 8K. I even tried copying the template again and dump again.
> Still 8K.
>
> Am I missing something, or is there a little bug in DBCA
> (11.1.0.7.0) ? Anybody got the same experience ?
>
> Kind regards,
> Menco
Just a couple of small questions.
Who uses dbca, other than the DBA 2s of which we hear so much these days?
Does anyone still use sqlplus / as sysdba and create database blah, or have we all been superseded?
Palooka Received on Fri Jan 30 2009 - 21:17:07 CST