Stack Overflow
Stack Overflow

Questions tagged [ora-03114]

ORA-03114: Not connected to ORACLE. A call to Oracle was attempted when no connection was established.

A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.

9 questions
7
votes
2 answers

Idle Oracle connections give error 'ORA-03114: not connected to ORACLE'

We have a Node.js web application that connects to an Oracle DB instance, The problem is after some inactivity, connections of the database is turned to read-only mode. It means SELECT operations work but INSERT and UPDATE transactions encounter…
Amir
  • 341
  • 1
  • 5
  • 16
3
votes
3 answers

ORA-03114 Getting a report

Do you know any reason to get the following error when I'm taking a few Oracle Reports? "FRM-40735: ON-ERROR trigger raised unhandled exception ORA-03114" This happens some times to a few users.
Gui Ferreira
  • 4,367
  • 6
  • 28
  • 41
1
vote
1 answer

Why am I receiving a 255 Record insertion limit on Oracle 10g using DBExpress?

I am hitting an brick wall during normal SQL processing When connected to Oracle 10g from a remote client w/DBEXPRESS, - using the standard dbxpora.dll + oci.dll When in a transaction, after exactly 255 record insertions, the connection hangs…
Shane
  • 83
  • 1
  • 6
1
vote
1 answer

Problem binding with OPEN-FOR-USING statement

I have a cursor in an ORACLE function that I am dynamically generating using the arguments of the function. I define the text of the cursor and in certain cases I include the following statement: sql_stmt := sql_stmt || 'AND MOD ( LOG_ID,…
David
  • 14,047
  • 24
  • 80
  • 101
0
votes
1 answer

Oracle SQL loader Error while loading really huge log files

I have a python script which loops through log files in a directory and uses oracle sqlloader to load the log files to the oracle database. the script works properly and even the sqlloader.. But after loading around some 200k records,the loading…
user747858
0
votes
1 answer

ORA-03114 In ASP.net-Core API after publishing to IIS

I have an ASP.NET Core Web API which works with oracleclient.dll. When I publish this service to IIS, after a while, I get "ORA-03114" errors. But when I recycle the application pool, the API works successfully again. What can I do to fix this…
hamid reza Heydari
  • 56
  • 9
0
votes
1 answer

APScheduler Jobstore Oracle drops "OperationalError ORA-03114" after adding a job (add_job)

Libraries version: APScheduler-3.5.3 SQLAlchemy-1.3.4 cx_Oracle-7.1.3 python-2.7.14 BackgroundScheduler is started (with job_store) and it works successfully (You can add jobs, jobstore works fine, etc) However, when more then 24 hours inactive (no…
Puebla
  • 1
  • 1
0
votes
1 answer

why dosen't oracle database link show column with image type from sqlserver

we have 2 server : 1-sqlserver 2012 on windows 2012 2-oracle 11g on linux we want to show information from table1 in sql server on oracle database and created database link between them when i have a query like "select ID,NAME from TABLE1" in…
Morteza Zahedi
  • 3
  • 1
0
votes
4 answers

ORA-03113: end-of-file on communication channel after ~ 2 hours and 10 mins

I have a sql script with a procedure. I run it using sqlplus -s @script.sql logfile.log myparam1 myparam2 But after ~ 2 hour and 10 mins, my script ends with ERROR: ORA-03114: not connected to ORACLE DECLARE * ERROR at line 1: ORA-03113:…
sattu
  • 632
  • 1
  • 22
  • 37