当点击完 finishbutton后,dbca 或者dbua hang住
来源于: DBCA/DBUA APPEARS TO HANG AFTER CLICKING FINISH BUTTON (文档 ID 727290.1)适用于:
Oracle Database Configuration Assistant - Version 10.2.0.1 to 11.2.0.1 [Release 10.2 to 11.2] Information in this document applies to any platform.症状:
Trying to create a database using the DBCA. After configuring all options successfully, clicking finish does nothing.This can also happen when using DBUA to upgrade a database.
There is no progress, and no errors are returned.
Looking at the dbca trace.log does not show any errors, just the following: [AWT-EventQueue-0] [11:20:29:828] [DBCAWizard.onFinish:1139] m_bFinishClicked: true [AWT-EventQueue-0] [11:20:30:2] [DBCAWizard.onFinish:1139] m_bFinishClicked: true [AWT-EventQueue-0] [11:20:35:126] [SQLEngine.done:1958] Done calledIn 10.2 trace information should be written automatically to the following location
$ORACLE_HOME/cfgtoollogs/dbca/trace.log
In 11g, the location of trace.log has changed to:
$ORACLE_BASE/cfgtoollogs/dbca/<DBNAME>/trace.log
原因:
In most cases, it appears that an X client is being used to run the DBCA, like Xming.When using Xming, this behaviour can occur if some Xming fonts are missing as discussed in unpublished Bug 6714527 (closed at status 'Not a Bug').
In case several Xwindows clients are tested to fail, the problem could also be caused by the next environment variable when using a recent Oracle release, e.g. 11gR2 :
ORA_NLS10=/nls/data/9idata
In this case, you may also encounter an error:
ORA-12705: Cannot access NLS data files or invalid environment specified解决方式:
To use Xming, you have to install the complete font package. Updating Xming to a newer version has also been known to resolve the issue.Optionally, run DBCA locally from the console, using a different X client or using VNC.
Reflections X and Exceed are also known to work.
However, problems have been reported with Exceed version 13.0.0 which seems not compatible with Oracle 11g. Exceed version 14.0.0 is reported to work, so please use that version when using Exceed.If the environment variable
ORA_NLS10=/nls/data/9idata is set, unset it and retry. 參考: NOTE:188134.1 - Tracing the Database Configuration Assistant (DBCA)