Data Loss Prevention

Guys,

One of our clients has complete DLP Suite deployed version 11.2. They are using Oracle instance provided by their DB team. Now we are planning to upgrade to version 12.0. For that we require Oracle 11.2.0.3 version. Client's DB team has created a separate Oracle server with required version and will restore the backup of DLP DB from existing instance to the new one.

My question is how can we configure or upgrade Enforce server with new DB server. Will upgrade wizard ask for DB parameter during upgrade and if not how can we change the DB info on Enforce for upgrade? Should we first change the DB parameters from backend and then run upgrade wizard or should we do vice versa?

Atif

first make the changes in the jdbc file to point to the correct oracle server name/ip. once enforce is connected to the newly moved DB then upgrade the enforce and detection server to 12.

hi,

as i experience upgrade oracle,  i did the service name for the communication of DB to the DLP.

it seems working. 

you can also see this through my bookmark, dlp upgrade

https://www-secure.symantec.com/connect/articles/upgrade-dlp-latest-version-graphical-steps

Hi Pete and naobra,

Thanks for your feedback. Pete.. can you please specify which jdbc file is that exactly and its location.

It is located in the Vontu or Symantec  directory..

Symantec\Protect\config

jdbcconnection.properties it has jdbc at the beginning.

righto! thumbs up!

you need to edit the file accordingly and recycle the services. Make sure you make a copy of the working file as well.

hi welcome :)

Thanks Guys... Appreciate your help and support.

Hi Atif,

first you need to create oracle DB schema and tables as per DLP DB. you need to import

Oracle_11g_Database_for_Vontu_v11_64_bit.dbt and create DLP DB to store incidents.

refer oracle installation guide and consult symantec support for the same . post this you can export the DB incidents in new oracle. This is not tested so please do first on test environment.

@Sharma...

Thanks for your feedback. My question is that in this case client is already using DLP 11.2 and Oracle DB is already populated. We have to migrate existing DB to new Oracle server with version 11.2.3 and then restore DB backup on new server.

Is it required in this case to create the schema using above instructions before restoring the backup? or just restoring the backup will do the job?

Atif,

Is there a reason why you created a BRAND new DB. You can upgrade the existing DB to the new version. Unless you are migrating from a 32bit to 64bit verison of the DB.

If you are restoring a DB from 1 server to another, you DO NOT need to create the schema. The restore will do that for you.

After re-reading your post, I have a lot of questions on why you are doing what you are doing.

Why did the DB team create a new server and instance????

ronak

The reason for creating a new DB server is that current DLP DB is hosted on an instance which was created on a DB cluster. DB team can not upgrade their Oracle cluster to required version because there are many other DB instances running on the same cluster. That is why they are going to provide us a new server on which we will export current runnign DLP DB and configure Enforce server to connect to new DB.

Now please confirm in the above mentioned scenario, do we still need to recreate a new schema?

the restore DB has to be on same version of Oracle before it is upgraded.

hi,

hmm??

to be able to restore the DB? you need same version???

before doing an upgrade?

Please confirm that we have to first restore current DB on new server with same Oracle version running on the cluster... right? then after restoring we would be upgrading new server Oracle version???

Hello-

First, create a cold backup of the old database. I'm guessing that it's a 10.2.0.4 or 11.2.0.1 DB. Is the current database 32 bit or 64 bit? If 32, you will need a new 32 bit Oracle Instance of the same version as on the cluster, then you will upgrade that DB instance to 11.2.0.3. Cold backup again (11.2.0.3 backup), then install a new Oracle DB instance on a 64 bit box, don't forget the template, as v12 only supports 64 bit.  Then you will need to restore the 32 bit backup to the 64 bit server, both 11.2.0.3. Be sure not to initialize the database when re-installing Enforce.

If 64 bit version, then install the same Oracle DB version on the new server, be sure to apply the database template, then restore the cold backup. Then you will need to upgrade the DB to 11.2.0.3.

Hope this helps.

Best,

Ryan

Thanks Ryan..

By template I believe you meant schema? Can you please reconfirm schema/template location on media/storage path?

Hi Atif-

The file I am referring to is named, "Oracle_11g_Database_for_Vontu_v11_64_bit_Lnx.dbt" or "Oracle_11g_Database_for_Vontu_v11_64_bit_Win.dbt". It is found as part of the 11g_r2_64_bit_Installation_Tools.tar.gz, or 11g_r2_64_bit_Installation_Tools.zip. Once these files are extracted to oracle_install/templates/Oracle_11g_Database_for_Vontu_v11_64_bit_Lnx.dbt. This database template file (.dbt), is used to create the schema.

I hope this answers your question.

Best,

Ryan