nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c configuration invalid login

Eric Kundl

Windows 7 desktop.

trying to install OBIEE to test its reporting abilities on our databases.

i found a few blogs with installation instructions...and followed their steps.

i installed Oracle 12c without a problem.. and can run SQLplus and SQLdeveloper without a problem.

then installed the JDK8.

then installed the Web Logic Server.

using pretty much the default parameters on both.

then installed OBIEE 12c without a problem.

but when i run the config.cmd file in the \bi\bin\ folder..

when i get to the 'Database Schema' window.. fill it out and hit Next.. i get an invalid login/password error.

i've tried using Username of sys with the default password.

i've tried using Username of system with the password i had changed it to.

my connect string i'm using is localhost:1521:orcl.iis.amadeus.net, which i'm pretty sure is correct.

i can connect from SQLplus and SQLdeveloper with the system user/password...

so what am i doing wrong here.. that i can't get past this window with either of the two users

Find more posts tagged with

Accepted answers

All comments

Sherry George

Hi Eric,

OBIEE 12c is not supported on Windows 7. This has been discussed numerous times here. Take a look at this

https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/

Courtesy: Christian

Eric Kundl

Sherry...

well bummer.. thanks for the reply...

[Deleted User]

Of course I have to like that response ;-)

[Deleted User]

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 :-)

Sherry George

ha ha. Looks like your article is going to be a big hit (hopefully not).

[Deleted User]

Unfortunately I guess it will be :-(

Eric Kundl

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.

Gianni Ceresa

Hi,

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.

[Deleted User]

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.

Eric Kundl

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'?

thanks... eric