Data Loss Prevention

Hi Guru's Is there any way through we can validate that Oracle was installed with response file provided by Symantec and DLP database protect was orignaly created with symantec provided template file.

can someone provide for both Linux and Windows 

Regards

Waqar

Hi waqar, 

Verify the database was created correctly

1 Open a new command prompt and start SQL*Plus: sqlplus /nolog

2 Log on as the SYS user: SQL> connect sys/password@protect as sysdba

• Where password represents the SYS password.

3 Run the following query: SQL> SELECT * FROM v$version;

4 Make sure that the output from the query contains the following information, which identifies the software components as version 12.1.0.2.

• The output information should read:

           BANNER

           --------------------------------------------------------------------------------

           Oracle Database 12c Release 12.1.0.2.0 - 64-bit Production

            PL/SQL Release 12.1.0.2.0 - Production

            CORE 12.1.0.2.0 Production

            TNS for 64-bit Windows: Version 12.1.0.2.0 - Production

            NLSRTL Version 12.1.0.2.0 – Production

5 Exit SQL*Plus: SQL> exit

Hi Aayan P, This is correct when we create DB by overself and know that we performed the installation but How to confirm when installation was already done by someone else and we want to make sure that user who installed Oracle and created protect DB as per symantec provided response file and database template.

Regards

Waqar