Data Loss Prevention

Currently, we are running Symantec DLP 15 with Oracle 11g in two-tier installation and now want to upgrade Oracle to 12c. As per the Upgrade checklist for Oracle 11g which upgrade path, we should follow

https://support.symantec.com/en_US/article.TECH247450.html 

1. Upgrade checklist for Oracle 11g SE1 or Oracle 11g SE on servers with 2 (or fewer) CPU sockets.
2. Upgrade checklist for Oracle 11g SE on servers with more than 2 CPU sockets on a two-tier installation

Hi,

Do you know which 11g version you are using at the moment? That will define which upgrade path to take?

If you are unsure you can open cmd type sqlplus /nolog conn sys as sysdba and enter your password when prompted. Once connected type or copy the following:

select * from v$version;

This will give you the version you are on which will determine which upgrade path to use.

I hope this helps.

Thanks

Hi Alan,

Thanks for your reply.

here is the output

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE    11.2.0.4.0      Production
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Hi,

Is is possible you could run this command:

open cmd type sqlplus /nolog conn sys as sysdba and enter your password when prompted

 select * from v$option;

Then look for Real Application Testing
if it is false then it will standard edition one,
if it is true then it is standard edition.

I hope this helps

Thanks

The output is false, it means it is standard edition one.

Hi Tatsavitur,

Yeah if false it means it is Standard Edition One.

Before any upgrade you should always ensure to take a backup of your database incase you need to roll back.

Thanks

Alan

Thanks Alan,

Appreciate your help.

Thanks,

Tatsavitur

Hi Tatsavitur,

Always happy to help. I hope i was able to help solve your issue? If so could you please mark this thread as solved.

Thanks

Alan

Hi Tatsavitur,

Di you get this issue resolved.

If so could you please mark as resolved?

Thanks