Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

.....product\12.1.0\dbhome_1\bin\perl.exe oracle database 12c error while database configuration

Aditya mishraApr 22 2014 — edited May 5 2014

Hi folks,

When trying to create CDB  on oracle 12c , it is giving me the below error message .It occurs during database configuration . Can anybody please help me on this ?

Error in Process: C:\app\hari\product\12.1.0\dbhome_1\bin\perl.exe. This is the only error and it stops creating the database.

Comments

John_K

Well, if you have two facts and you want to combine them, then they need to contain the same set of dimensions. Imagine you have two facts - cars and people. Cars have a num_wheels dimension and people have a hair_colour dimension. It makes no sense to report how many people have four wheels!!

You can actually combine facts at different dimensionality though using the FILTER clause. See here: Combining Facts/Subject Areas in Oracle OBIEE - Part 2 - Beyond Blog

Christian Berg-0racle

OBI at ist core is a source agnostic query Generator for any source there is.

Logical dimensions and Logical Facts are - as their "Logical" bit of the Name implies - actually completely artificial concepts and have Zero to do with the physical model in the strictest sense of the word. I can happily and easily create a 10 fact, 30 Dimension model where only 4 dims will ever be conformed on one single flat file.

You must comprehend this to comprehend why OBI does things the way it does them.

a) all business model concepts are virtual

b) don't even think "this Logical Dimension just means a dimension table" - through multiple LTSs and multiple tables nested inside each LTS I can create you a "Dimension" which - while a logical entity - is sourced from 20 physical sources, 2 being tables, 4 being cubes, 11 being XML and 3 coming from Hadoop

Yes this is the strongest feature of the NQuire Server which people still don't get comprehend 20 years after its inception.

1 person found this helpful
Thomas Dodds

Every fact has a dimensional context

Every dimensional attribute is related through a fact (conformed dimensions & implicit facts)

Use of information drives fact star design (typically a related set of business questions are answered by a single fact star)

+ to @"Christian Berg"

^ the basic rules

1 person found this helpful
Christian Berg-0racle

True, but contrary to breathing and heartbeat they don't happen automagically

1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 2 2014
Added on Apr 22 2014
#database-key-features, #multitenant
1 comment
3,179 views