ORA-03114: not connected to ORACLE
576499May 14 2007 — edited Jul 14 2009HI,
Installed OBI EE, with 10g , i have created ODBC connection and i tested it and it was working fine.
When I try to right click and view data on physical layer throwing following error
Query Status: Query Failed: [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 17001] Oracle Error code: 3114, message: ORA-03114: not connected to ORACLE
at OCI call OCIStmtExecute.
[nQSError: 17010] SQL statement preparation faile
===========================
Sytem DSN name ORCL
instance orcl
=====================================
copying tsnnames.ora entry
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MEENAKSHI)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
========================================
BI EE Connectionpool properties
Call interface OCI10g
datasourcename ORCL
pl help me to fix the error
thanka
ram