OBIEE 12c is not supported on Windows 7. This has been discussed numerous times here. Take a look at this
well bummer.. thanks for the reply...
Of course I have to like that response ;-)
Habediehre Herr Kundl,
It's really preferable to keep things in a bespoke app server VM rather than just on your main host OS if it's a desktop.
Nice to see another Austrian in her :-)
ha ha. Looks like your article is going to be a big hit (hopefully not).
Unfortunately I guess it will be :-(
i'll need to try and get a server to use.. although the IT people are normally not happy to setup a server just for testing a product.
and glad you noticed my name.. although i've never been to Austria, its a goal for when i retire.
my Father has visited Kundl Austria a few times, but the family has been in the US for the last 3 generations.
No need to get a physical server, the idea is more to get yourself a VM with a server OS ...
If your laptop / workstation has only 8Gb you will anyway struggle to install and run OBIEE (it takes looooot of RAM), and if you have 16Gb of RAM you can easily have 10-12 for the VM and so no real issue.
Hah I thought "austrian name, subsidiary of Amadeus....fits" :-)
As Gianni says you don't need a server. We continuously use multiple different VMs which Oracle provides for free on our laptops.
hi.. i'm back...
i can't use a VM on my laptop.. its not allowed in the company.
so i got use of one of our labs servers that is Windows Server 2008 R2...
installed the JDK, WebLogicServer and the OBIEE 12c
the prerequisites didn't say they needed the Oracle database installed, but when i got to the config.cmd in OBIEE, it wanted to write its configuration to an Oracle database.
so i installed the Oracle database 12x.
got back to the config.cmd in OBIEE.. and i'm getting the same error i was getting on the laptop...
on the step4, where i enter parms for 'Create new schemas'..
if i enter the system username and password, i get an error that the username and password is invalid... but i know its not because i can connect with SQLplus using it.
on this server i'm using the connection string of localhost:1521:orcl.lab.local, which was in the summary when i installed the Oracle DB.
and i'm not getting an error that the connection string is not valid, it is saying the username/password is invalid.
should i try creating a new username?
if i create a new username in the OracleDB.. what permissions should i give it to satisfy the requirement to 'be able to create schemas'?
Are you connecting to a CDB or PDB?
ok.. created a new user with sysdba role...
used this user in the step 4.. worked.. got past that window...
so why didn't the system user work?
Sherry.. i'm not sure.. but i believe i unchecked the box for CDB when i installed Oracle?
anyway... the OBIEE install seems to be proceeding now.. hopefully it will work when i get done.
this whole exercise is just to see how OBIEE will connect to our SQL Server Databases for reporting.. and whether our table structure is suitable.
which it probably is not.. we'll see how it works, but the odds are not good that we will end up using this.
currently our reports is using a in-house modified Microsoft SSRS installation.
Thanks for updating us Eric. Keep us posted on your progress and I'd especially be interested in your structures in that case. Modeling (no, not THAT kind) is my passion and I love a challenge :-D