DBUA : InitParamAttributes.loadInitParams java.util.NoSuchElementException java.util.StringTokenizer

Error:

DBUA : /u01/app/oracle/cfgtoollogs/dbua/logs/trace.log

[Thread-12] [ 2017-06-09 21:49:22.063 WAT ] [InitParamAttributes.loadInitParams:1984]  DBParameter created:=open_cursors = 1000

java.util.NoSuchElementException

        at java.util.StringTokenizer.nextToken(StringTokenizer.java:332)

        at oracle.sysman.assistants.util.attributes.InitParamAttributes.loadInitParams(InitParamAttributes.java:1976)

        at oracle.sysman.assistants.dbma.backend.Database.updateNonDefaultInitParams(Database.java:1188)

        at oracle.sysman.assistants.dbma.backend.CompManager.obtainGenericDbInfo(CompManager.java:2456)

        at oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:4255)

        at oracle.sysman.assistants.dbma.ui.DatabasesPage.doProcessing(DatabasesPage.java:811)

        at oracle.sysman.assistants.util.WaitDialog.run(WaitDialog.java:187)

        at java.lang.Thread.run(Thread.java:637)

Diag:

select NAME||'|'||nvl((translate(VALUE,chr(13) || chr(10),' ')), 'DBUA_NULL') from v$parameter where isdefault='FALSE' and name!='ifile'

and name!='spfile' and name!='event' and name!='_trace_events' union select NAME||'|'|| nvl((translate(VALUE,chr(13) || chr(10),' ')), 'DBUA_NULL')

from v$parameter where ismodified!='FALSE' and isdefault='FALSE' and name!='ifile' and name!='spfile' and name!='event' and name!='_trace_events';

audit_file_dest|/u01/app/oracle/admin/n013bans/adump

audit_trail|DB

compatible|11.2.0.0.0

control_files|/oradata/N013BANS/controlfile/o1_mf_8r72rt04_.ctl

db_block_size|8192

db_create_file_dest|/oradata

db_domain|DBUA_NULL

db_name|n013bans

diagnostic_dest|/u01/app/oracle

dispatchers|(PROTOCOL=TCP) (SERVICE=n013bansXDB)

local_listener|LISTENER_N013BANS

log_archive_dest_1|LOCATION=/archive/n013bans

open_cursors|500

os_authent_prefix|

pga_aggregate_target|268435456

processes|300

remote_login_passwordfile|EXCLUSIVE

remote_os_authent|TRUE

sessions|472

sga_target|805306368

undo_tablespace|UNDOTBS1

21 rows selected.

Solution:

The above error is checking the init parameters using above query,One of the parameter is having issue with DBUA like special

character.

In my case after open_cursors i get the "java.util.NoSuchElementException" ,By checking the output of the above query ,after open_cursors i see the parameter

os_authent_prefix ,So i reset the value os_authent_prefix.Then i restarted the database after that DBUA go through.