Forum Stats

  • 3,769,805 Users
  • 2,253,023 Discussions
  • 7,875,211 Comments

Discussions

Oracle credentials are not taking through connection wizard of essbase studio.

User_JL3CW
User_JL3CW Member Posts: 194 Red Ribbon
edited Nov 12, 2019 3:20AM in EPM System Infrastructure

Hi,

I have oracle db 12c(12.1.0.1) and Essbase 11.1.2.4  installed on windows server 2012 R2 in my laptop.

When i was trying to connect oracle db from connection wizard of essbase studio, it's saying provide machine name rather localhost.

my machine name is shubham.

after installation of oracle db the tnsentry is as follows

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

If i give servername as shubham i am not able to connect to db. It's throwing the following error.

pastedImage_0.png

If i give servername as localhost then i am able to get Database name details but when i perform "Test Connection" it says dont user locahost use server as machine name.

Please help to solve this isssue.

Regards,

Chandra.

Answers