doubt to set /reset Oracle Parameters in 12c

[former_member190251]

Hello Team,

We have executed the oracle parameter script for 12c to check the missing parameter and the parameter requires to be deleted from the oracle database.

the details taken as per the note 1888485 - Database Parameter for 12.1.0.2

parameters

_advanced_index_compression_options

heat_map

Please let me know how to check whether Advanced Compression License is enabled or not

if not, can we set heat_map parameter alone.

Parameter

db_files - Currently the value set to 200, Do we need to set to >=11 or can we leave it as it is (200)

for most of the parameters

for example When i tried to delete the db_file_multiblock_read_count , i am getting the below error.

SQL> show parameter db_file_multiblock_read_count

NAME                                 TYPE        VALUE

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

db_file_multiblock_read_count        integer     128

SQL> alter system reset db_file_multiblock_read_count scope =spfile;

alter system reset db_file_multiblock_read_count scope =spfile

*

ERROR at line 1:

ORA-32010: cannot find entry to delete in SPFILE

SQL> alter system reset db_file_multiblock_read_count scope=spfile sid='*';

alter system reset db_file_multiblock_read_count scope=spfile sid='*'

*

ERROR at line 1:

ORA-32010: cannot find entry to delete in SPFILE

When i list out show parameter, i could see the parameter exists

Please let me know how to reset these parameter mentioned in the note

Regards

Subb

[Brindavan_M]

Hello ,

set the parameter in pfile and create the spfile.  I hope you got the answer from Regan about the license.

Thanks,

BM

[kaus19d]

adding to my friends, here,

would like to add the below, hope it helps,

SQL> connect as sysdba

SQL> create pfile='C:\ora\pfile\initSID.ora'

SQL> CREATE SPFILE 'spfileSID.ora'  FROM PFILE = '\ORACLE_HOME\work\initSID.ora

So, here in your case the matter would look like

SQL> startup pfile='C:\ora\pfile\initSID.ora';

SQL> create spfile from pfile='C:\ora\pfile\initSID.ora'

Followin your OS, lets say my case is windows, so will be able to locate PFILE in ORACLE_HOME\database

Here I think you already know spfile<SID>.ora is the Oracle Binary parameter file. For initSID.ora it gets into spfileSID.ora & then the parameters gets into initSID.sap

Thanks,

Kaushik

[kaus19d]

also supporting my words, for commands you can follow, could have googled it a bit for this kind of issues,

Thanks,

Kaushik

[Reagan]

If the database is licensed through SAP then the compression is part of that.

105047 - Support for Oracle functions in the SAP environment

Regarding the parameters, it is very clear from the script output.

The parameter db_file_multiblock_read_count is not an issue. You are trying to reset a parameter which is not set and the system throws the error.

[Former Member]

Hello Subb,

Q1) Compression Licensing

A1) See note: 2254866 - Using Oracle Database 12c Automatic Data Optimization with SAP NetWeaver.

Q2) db_files

A2) You really are taking this too literally. ">=11" means a value greater than or equal to 11. As your value = 200 you are fine.

Q3) db_file_multiblock_read_count

A3) The error is quite simply telling you that the parameter isn't set in the spfile (correct). You see the parameter with a value of 128 as it is being automatically calculated as opposed to being explicitly set in the spfile. You have nothing to change.

KR,

Amerjit