OraFAQ Forum: Server Administration » How to avoid the clear password in checkpoint file with oracle DBCA

Home » RDBMS Server » Server Administration » How to avoid the clear password in checkpoint file with oracle DBCA

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to avoid the clear password in checkpoint file with oracle DBCA [message #531391]

Tue, 15 November 2011 14:12

casttree
Messages: 83
Registered: August 2008

Member

I found there is clear password in the xml file in the process of Oracle instance creating.

The process like below

1, when using the following process to create the instance

Login as user Oracle

/home/Oracle11home/bin/dbca -createDatabase -silent  -templateName /home/Oracle11home/assistants/dbca/templates/Small.dbt -gdbName testDB -sid testSID -sysPassword [b]testpwd[/b] -systemPassword [b]testpwd[/b]

2. Found the file in $ORACLE_HOME/checkpoints/dbca/OraDb11g_home2_oracle_creation_checkpoint.xml , it listed the sys and system passwd (like testpwd for sys and system password) directly.

   <CHECKPOINT LEVEL="MAJOR" NAME="db_oracle" DESC="db creation checkpoint" STATE="FAIL">
      <PROPERTY_LIST>
         <PROPERTY NAME="command" TYPE="STRING" VAL=" -silent -createDatabase -templateName Small.dbt -gdbName testDB -sid testpwd -sysPassword testpwd -systemPassword testpwd"/>
      </PROPERTY_LIST>
   </CHECKPOINT>

I hope to confirm :

1. what is the purpose for oracle to genate the checkpoint.

2, can we remove the file safely ?

3, if there is configuration that we can avoid to show clear password in checkpoint file?

Thanks

[Updated on: Tue, 15 November 2011 18:32]

Report message to a moderator