Problem summary:
I can not create analysis by -
1. "Create direct database request"
2. "Create Analysis from simple logical SQL"
Problem details:
I have successfully installed OBIEE 11g on RHEL machine. My Oracle database is on a remote machine.
I am able to connect to the db from bi publisher (http://obiee-server-machine:9704/xmlpserver).
But..
1. I can not connect to the db from bi analytics (http://obiee-server-machine:9704/analytics)!
Every time I try New->analysis->Create direct database request - getting a connection pool error!
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27022] Unresolved Connection Pool object: "hostname:port:servicename". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "hostname1:1521:servicename1" SELECt * FROM table_name')}
And,
2. Every time I try New->analysis->Create Analysis from simple logical SQL
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27004] Unresolved table: "table_name". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT * FROM table_name')}
SQL Issued: SELECT * FROM table_name
For More information -
1. In console(http://obiee-server-machine:7001/console), I have setup a Data Source successfully. The datasource name is - "dtsrc1"
2. I have Copied the TNSnames.ora and sqlnet.ora files from my Database's following location: $ORACLE_HOME/network/admin
and pasted these two files in OBIEE installation following two locations:
$OBIEE_HOME\Oracle_BI1\network\admin
$OBIEE_HOME\oracle_common\network\admin
tnsname.ora detail -
dtsrc1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = servicename1)
)
)
Some configuration information -
OBIEE version - OBIEE 11.1.1.7.0
OBIEE machine - RHEL 6.5 (x86-64-bit)
OBIEE Install type - Enterprise Install
Database version - Oracle(11g Enterprise Edition 11.2.0.3.0)
Database Machine - SunOS 5.10 (x86-64-bit).
What should be the Connection pool name?