IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    Oracle 12c DBCA error:The plug-in faild in its perform method

    Adamhuan发表于 2017-03-08 03:55:20
    love 0

    该错误发生在数据库DBCA建库的时候。
    具体错误如下:

    发生该错误的时候,后台日志会如下显示:
    OUI的日志:

    INFO: Read: 35% complete
    WARNING: Skipping line: 35% complete
    INFO: Read: 38% complete
    WARNING: Skipping line: 38% complete
    INFO: Read: DBCA Operation failed.
    INFO: DBCA Operation failed.
    WARNING: Skipping line: DBCA Operation failed.
    INFO: Read: Look at the log file "/home/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
    INFO: Look at the log file "/home/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
    WARNING: Skipping line: Look at the log file "/home/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
    INFO: Completed Plugin named: Oracle Database Configuration Assistant
    INFO: Oracle Database Configuration Assistant failed.
    INFO: Oracle Database Configuration Assistant failed.
    INFO: ConfigClient.executeToolsInAggregate action performed
    INFO: Exiting ConfigClient.executeToolsInAggregate method

    OUI的日志中,提示的更详细的日志信息:

    [root@ora12c-1 ~]# cat /home/app/oracle/cfgtoollogs/dbca/orcl/orcl.log
    [ 2017-03-08 11:36:54.527 CST ] Copying database files
    DBCA_PROGRESS : 1%
    DBCA_PROGRESS : 13%
    DBCA_PROGRESS : 25%
    [ 2017-03-08 11:38:39.475 CST ] Creating and starting Oracle instance
    DBCA_PROGRESS : 26%
    DBCA_PROGRESS : 30%
    DBCA_PROGRESS : 31%
    DBCA_PROGRESS : 35%
    [ 2017-03-08 11:41:35.919 CST ] ORA-12705: Cannot access NLS data files or invalid environment specified
    
    DBCA_PROGRESS : 38%
    [ 2017-03-08 11:41:35.959 CST ] ORA-12705: Cannot access NLS data files or invalid environment specified
    
    [ 2017-03-08 11:41:35.998 CST ] ORA-12705: Cannot access NLS data files or invalid environment specified
    
    [ 2017-03-08 11:41:36.088 CST ] ORA-12705: Cannot access NLS data files or invalid environment specified
    
    [ 2017-03-08 11:41:41.153 CST ] Error while executing "/home/app/oracle/12c/release_2/db_1/rdbms/admin/dbmssml.sql". Refer to "/home/app/oracle/cfgtoollogs/dbca/orcl/dbmssml0.log" for more details. Error in Process: /home/app/oracle/12c/release_2/db_1/perl/bin/perl
    [ 2017-03-08 11:41:41.572 CST ] DBCA_PROGRESS : DBCA Operation failed.
    [root@ora12c-1 ~]#

    可以看到,错误为【ORA-12705: Cannot access NLS data files or invalid environment specified】

    检查NLS相关的环境变量的配置:

    [root@ora12c-1 ~]# su - oracle
    Last login: Wed Mar  8 11:10:04 CST 2017 on pts/2
    [oracle@ora12c-1 ~]$ env | grep NLS_LANG
    NLS_LANG=AMERICAN_AMERICA_ZHS16GBK
    [oracle@ora12c-1 ~]$

    可以看到,NLS_LANG的环境变量配置不正确。

    修改正确:

    [oracle@ora12c-1 ~]$ cat ~/.bash_profile 
    # .bash_profile
    
    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
            . ~/.bashrc
    fi
    
    # User specific environment and startup programs
    
    PATH=$PATH:$HOME/.local/bin:$HOME/bin
    
    export PATH
    
    # for oracle database 12c release 2
    export ORACLE_BASE=/home/app/oracle
    export ORACLE_HOME=$ORACLE_BASE/12c/release_2/db_1
    
    export ORACLE_SID=smo_king
    
    export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
    
    export EDITOR=vi
    
    export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
    [oracle@ora12c-1 ~]$ 
    [oracle@ora12c-1 ~]$ source .bash_profile 
    [oracle@ora12c-1 ~]$ env | grep NLS_LANG
    NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
    [oracle@ora12c-1 ~]$

    然后,【retry】就没问题了。

    ————————————————————
    Done。



沪ICP备19023445号-2号
友情链接