Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c configuration invalid login

Received Response
1
Views
14
Comments
Eric Kundl
Eric Kundl Rank 2 - Community Beginner
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

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

«1

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    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
    Eric Kundl Rank 2 - Community Beginner

    Sherry...

    well bummer.. thanks for the reply...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Of course I have to like that response ;-)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Sherry George Rank 7 - Analytics Coach

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Unfortunately I guess it will be :-(

  • Eric Kundl
    Eric Kundl Rank 2 - Community Beginner

    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
    Gianni Ceresa Mod

    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]
    [Deleted User] Rank 2 - Community Beginner

    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
    Eric Kundl Rank 2 - Community Beginner

    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