Hyperion Essbase (MOSC)

MOSC Banner

Oracle Call Interface setup

edited Nov 20, 2012 4:35AM in Hyperion Essbase (MOSC) 2 commentsAnswered ✓
Hi,

We're trying to setup an OCI connection between Essbase (v11.1.2.1 and v11.1.2.2) and UNIX/Linux.  (v11.1.2.1 -> UNIX, v11.1.2.2 ->Linux, if that matters).  I've googled the syntax, and have come up with this format: DBSERVERNAME:PORT/SERVICE_NAME.  So, I sent a TNSPING to the server:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (SDU = 32768) (TDU = 32768) (ADDRESS_LIST =
 (ADDRESS = (PROTOCOL = TCP) (HOST = indw-q) (PORT = 1521))) (CONNECT_DATA = (SI
D = INDWQ) (GLOBAL_NAME = INDWQ)))
OK (210 msec)

Makes me think that this would work:  indw-q:1521/INDWQ would work, but it doesn't.  From the app log: EssOCI is initializing the connection to Oracle database on server [indw-q:1521/INDWQ]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center