ORACHK  VERSION: 12.1.0.2.1_20141009: Verify no duplicate parameter entries in database init.or

Database Check "Verify no duplicate parameter entries in database init.ora(spfile)" fails even if there is no duplicate parameter in the spfile/initfile.

 

Here is test the result.  Also attached full report generated by orachk.

 

 

Verify no duplicate parameter entries in database init.ora(spfile)

Recommendation
Needs attention on	dubordbs02:dubcnn1_dub
Passed on	dubordbs01:dubcnn1_dub

 

Status on dubordbs01:dubcnn1_dub: PASS => There are no duplicate parameter entries in the database init.ora(spfile) file

DATA FROM DUBORDBS01 - DUBCNN1_DUB DATABASE - CHECK   dubcnn11.__db_cache_size=469762048 dubcnn12.__db_cache_size=536870912 dubcnn11.__java_pool_size=33554432 dubcnn12.__java_pool_size=16777216 dubcnn11.__large_pool_size=16777216 dubcnn12.__large_pool_size=16777216 dubcnn11.__oracle_base='/install01/oracle/app'#ORACLE_BASE set from environment dubcnn11.__pga_aggregate_target=738197504 dubcnn12.__pga_aggregate_target=738197504 dubcnn11.__sga_target=1409286144 dubcnn12.__sga_target=1409286144 dubcnn11.__shared_io_pool_size=0 dubcnn12.__shared_io_pool_size=0 dubcnn11.__shared_pool_size=838860800 dubcnn12.__shared_pool_size=822083584 dubcnn11.__streams_pool_size=33554432 dubcnn12.__streams_pool_size=0 *.audit_file_dest='/install01/oracle/app/admin/dubcnn1_dub/adump' *.audit_trail='DB' *.cluster_database=true *.compatible='11.2.0.0.0' *.control_file_record_keep_time=31 *.control_files='+DBDATA01/dubcnn1_dub/controlfile/current.306.816021137','+DBFRA01/dubcnn1_dub/controlfile/current.400.816021137' *.db_block_size=8192 *.db_create_file_dest='+DBDATA01' *.db_domain='corp.tullowoil.local' *.db_flashback_retention_target=10080 *.db_name='dubcnn1' *.db_recovery_file_dest='+DBFRA01' *.db_recovery_file_dest_size=21474836480 *.db_unique_name='dubcnn1_dub' *.diagnostic_dest='/misc01/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=dubcnn1XDB)' *.filesystemio_options='SETALL' *.global_names=TRUE dubcnn11.instance_number=1 dubcnn12.instance_number=2 *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' *.log_archive_dest_2='' *.log_archive_format='%t_%s_%r.dbf' *.memory_target=2147483648 *.nls_language='ENGLISH' *.nls_territory='UNITED KINGDOM' *.open_cursors=300 *.processes=500 *.remote_listener='dubordbj01-scan.corp.tullowoil.local:5531' *.remote_login_passwordfile='exclusive' *.sessions=555 dubcnn12.thread=2 dubcnn11.thread=1 dubcnn12.undo_tablespace='UNDOTBS2' dubcnn11.undo_tablespace='UNDOTBS1'