Symantec DLP 15.1 - cannot login to sqlplus on Enforce Server

[gal segal]

Hello All,

I'm getting errors :
Code 4050 - Agent data batch persist error:
Unexpected error occured while agent data being persisted : Could not get JDBC Connection; nested exception is java.sql.SQLException: Database connection failed. Please look at the detection server controller logs for more information.

In addition to that, I cannot login to SQLplus from my Enforce Server , i get the error-
ORA-12560 : TNS : protocol adapter error

I can only login from oracle db server itself .

Can someone please advise?

Thanks,

[Paul Evans]

Hi Gal,

Make sure you have the Oracle client installed on the enforce server and that you have the environment variables set.

Assuming you do, I've seen where you need to copy the tnsnames.ora file from Oracle server to the Oracle client location on enforce.  In my test lab this is the location on Oracle server.

C:\oracle\product\12.2.0.1\db_1\network\admin\tnsnames.ora

On my enforce:

C:\app\client\Administrator\product\12.2.0\client_1\network\admin\

If the file isn't there then just copy it there and try to login.  That may not be the issue but it is something you can try.  Also check the tnsnames to make sure it is pointing to the IP/hostname of the Oracle box.

I hope that helps.

Paul Evans

.

[gal segal]

Hi Paul,

Thanks for stepping in.

Can you please elaborate which system vars do I need to verify exist on the Enforce server?

Rest of the things are OK.

Thanks,

[Moustafa Salah]

Hello,

i have the same issue in my lab and I followed these procedurals but the issue didn't solved yet, I'm using Symantec DLP v 15.1 any recommendation please.

[Paul Evans]

You could try logging in using the string in the jdbc.properties and see if that works.  See this technote.

https://knowledge.broadcom.com/external/article/160251/test-the-oracle-database-connection-stri.html

Thanks,

Paul 

.