Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03114: not connected to ORACLE

576499May 14 2007 — edited Jul 14 2009
HI,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2009
Added on May 14 2007
6 comments
14,485 views