Change database in DLP
Created: 27 Dec 2011 | 4 comments
Is it possible to point DLP enforce server to another database?
Also, Is it possible to see the database details (like ip, sid, dbname etc.) from DLP enforce server console?
Discussion Filed Under:
Comments
Hello YusufKhan, The only
Hello YusufKhan,
The only certified Database to use with DLP is Oracle. So if you change the database Symantec is not going to give you technical support.
I'm not a DBA, maybe and just maybe someone with a very deep knowledge of Oracle and other DB could be able to create or migrate the schama and point DLP to another server... Just maybe.... But.... Why do you want to change the DB to another vendor?
In regards of the second question the answer is no, you can not see that information from the Enforce console. However if you need to know or modify which database your Enforce is using as a workaround you may check the jdbc.properties file located on Vontu\protect\config\. Open the file and look for the jdbc.dbalias.oracle-thin line. There you find the SID, port, user nameand address/FQDN information.
I hope this information helps.
Cheers,
Chopper
HI, Sorry for the confusion,
HI,
Sorry for the confusion, I was not referring for pointing to db other than ORacle :-).
I wanted to know if its possible we can point it to another instance of Oracle db.This is in case I have replica of db (4 or 5 days old) on another place (machine) and if I want to connect it in case we need.
Warm regards,
Yusuf
You just need to reinstall
You just need to reinstall enforce server and enter new ip of database but dont check initialize db.
Edit JDBC.properties
To change the database from one backend to another you change the last line in the JDBC.properties file. the format is as follows
jdbc.dbalias.oracle-thin=@(description=(address=(host=hostname)(protocol=tcp)(port=1521))(connect_data=(sid=protect)))
Before you make this change you should stop all the services, scans, etc to ensure the database remains consistant. I would only change in an extreme situation such as a DB failure on the primary DB.
Would you like to reply?
Login or Register to post your comment.