ZConnection with Oracle keep going in error
lazarus / 16-Databases

----------------------------------------------------------------------
lander · 2021-10-12 20:14

(https://i.postimg.cc/ryPydbTZ/Immagine.png)

I have Win10, Lazarus 2.0.12 32bit (fcup), oci.dll 32 bit of instant
client 19 and 21. When I try retry and retry it then works but
everytime I should lose a lot of time. I don't know the event that
make it works. I simply close lazarus, change oci.dll 10 times...
Is there a way to make it works forever without 100 attempts?

Edit: just another attempt: I duplicated oci.dll with another name, it
connected.

----------------------------------------------------------------------
loaded · 2021-10-13 09:13

I had a similar problem a long time ago, I'm not sure, but some of the
following solved my problem.
-First of all, you can close your antivirus program and try, if the
problem is resolved, add the Lazarus exe path and the project path you
are using to the exclusions.
-Run Lazarus with Administrator Rights. Make this feature permanent in
the compatibility settings.
-Stop the Windows file scanning and indexing service.
If I remember anything else, I'll add it here.

----------------------------------------------------------------------
lander · 2021-10-13 19:10

I applied your suggestions. Thank you!
Consider I'm now using "system" user cause this database is for
development testing purposes. Should I create a new user for testing
or it's not important?

----------------------------------------------------------------------
loaded · 2021-10-14 05:02

I couldn't quite understand what you were saying due to my poor
English (I don't actually have any).
If by User you mean the Win10 side, it doesn't matter as long as you
can interfere with the relevant settings!
But if you are talking about database;
If you have or will add a record deletion in the database, it may be
useful to create a different user to prevent unwanted situations in
the future.
Other than security, you won't notice much difference in terms of
performance.
Of course, these are my thoughts, I don't know what the Masters would
say.

----------------------------------------------------------------------
marsupilami79 · 2021-10-14 15:29

Hello lander,

Quote from: lander on October 12, 2021, 10:14:05
pm(https://i.postimg.cc/ryPydbTZ/Immagine.png)
This could be a windows problem. Zeos generates this error when
Windows fails to load the library. Which version of Zeos do you use?

Best regards,

Jan

----------------------------------------------------------------------
lander · 2021-10-14 17:50

I have solved the problem.
After following loaded suggestions I also applied such queries:

BEGIN
  FOR sess IN (SELECT sid,serial# FROM v$session WHERE
status<>'INACTIVE')
  LOOP
      EXECUTE IMMEDIATE 'alter system kill session ''' || sess.sid  ||
','
        || sess.serial# || ''' immediate';
  END LOOP;
END;

SELECT * FROM V$SESSION

ALTER SYSTEM KILL SESSION WHERE status LIKE '%active%';

ALTER PROFILE DEFAULT LIMIT IDLE_TIME 1;