on 09-09-2016 1:43 PM
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
Hello ,
set the parameter in pfile and create the spfile. I hope you got the answer from Regan about the license.
Thanks,
BM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.