3 Replies Latest reply: Mar 25, 2014 9:15 PM by Krishna-Oracle RSS

    DBCA stuck at 85%

    ajayb

      I have created a two node RAC using Linux 64 Bit.  Everything i.e. Clusterware and Database Software installation for 11G R2 64 BIT went smooth, but the DBCA is stuck at 85 %.  Given below are the details from log files -

       

      oracle@ol5-112-rac1 RAC]$ tail -f cloneDBCreation.log

              20 oracle@ol5-112-rac1.localdomain (RECO)                                                                                                                    1

              21 oracle@ol5-112-rac1.localdomain (RBAL)                                                                                                                    1

              22 oracle@ol5-112-rac1.localdomain (ASMB)                                                                                                                    1

              23 oracle@ol5-112-rac1.localdomain (MMON)                                                                                                                    1

              25 oracle@ol5-112-rac1.localdomain (MMNL)                                                                                                                    1

              26 oracle@ol5-112-rac1.localdomain (MARK)                                                                                                                    1

              29 oracle@ol5-112-rac1.localdomain (O000)                                                                                                                    5

              30 oracle@ol5-112-rac1.localdomain (O001)                                                                                                                    2

              32 oracle@ol5-112-rac1.localdomain (QMNC)                                                                                                                    1

      AL16UTF16

       

      oracle@ol5-112-rac1 RAC]$ tail postDBCreation.log

      utl_recomp_end: 07:18:46

      Database closed.

      Database dismounted.

      ORACLE instance shut down.

      ERROR:

      ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

       

       

      DB_RUNNING

               1

               1

       

      [oracle@ol5-112-rac1 RAC]$ tail trace.log

      [Thread-99] [ 2014-03-24 20:03:18.398 IST ] [RuntimeExec.runCommand:164]  https://ol5-112-rac1.localdomain:1158/em/console/aboutApplication

      [Thread-99] [ 2014-03-24 20:03:18.398 IST ] [RuntimeExec.runCommand:164]  Starting Oracle Enterprise Manager 11g Database Control ............................................................................................. failed.

      [Thread-99] [ 2014-03-24 20:03:18.398 IST ] [RuntimeExec.runCommand:164]  ------------------------------------------------------------------

      [Thread-99] [ 2014-03-24 20:03:18.398 IST ] [RuntimeExec.runCommand:164]  Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/ol5-112-rac2_RAC/sysman/log

      [Thread-99] [ 2014-03-24 20:03:18.399 IST ] [RuntimeExec.runCommand:170]  RunTimeExec: error>

      [Thread-99] [ 2014-03-24 20:03:18.399 IST ] [RuntimeExec.runCommand:192]  Returning from RunTimeExec.runCommand

      [Thread-99] [ 2014-03-24 20:03:18.399 IST ] [NativeSystem.rununixcmd:1058]  NativeSystem.rununixcmd: RetString 0|Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.https://ol5-112-rac1.localdomain:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 11g Database Control ............................................................................................. failed. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/ol5-112-rac2_RAC/sysman/log  :failed

      [Thread-99] [ 2014-03-24 20:03:18.400 IST ] [NativeResult.<init>:91]  NativeResult: The String obtained is0|Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.https://ol5-112-rac1.localdomain:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 11g Database Control ............................................................................................. failed. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/ol5-112-rac2_RAC/sysman/log  :failed

      [Thread-99] [ 2014-03-24 20:03:18.400 IST ] [NativeResult.<init>:99]  The status string is: 0

      [Thread-99] [ 2014-03-24 20:03:18.400 IST ] [NativeResult.<init>:112]  The result string is: Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0 Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.https://ol5-112-rac1.localdomain:1158/em/console/aboutApplicationStarting Oracle Enterprise Manager 11g Database Control ............................................................................................. failed. ------------------------------------------------------------------Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/ol5-112-rac2_RAC/sysman/log  :failed 1

       

      oracle@ol5-112-rac1 RAC]$ tail emConfig.log

      Mar 24, 2014 8:03:18 PM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList

      CONFIG: Value for env var 'TZ' is 'null', discarding the same

      Mar 24, 2014 8:03:18 PM oracle.sysman.emcp.util.PlatformInterface addEnvVarToList

      CONFIG: Value for env var 'NLS_LANG' is 'null', discarding the same

      Mar 24, 2014 8:03:18 PM oracle.sysman.emcp.util.PlatformInterface getEnvProps

      CONFIG: Returning env array from cache

      Mar 24, 2014 8:03:18 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray

      CONFIG: New Env List: [BASE_PATH=/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin, CLASSPATH=/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/jlib/dbca.jar:/u01/app/oracle/product/11.2.0/db_1/assistants/jlib/assistantsCommon.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ewt3.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ewtcompat-3_3_15.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/share.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/help4.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/jewt4.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/oracle_ice5.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/kodiak.jar:/u01/app/oracle/product/11.2.0/db_1/lib/xmlparserv2.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/orai18n.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ldapjclnt11.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/netcfg.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/ojmisc.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/oraclepki103.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/opm.jar:/u01/app/oracle/product/11.2.0/db_1/jdbc/lib/ojdbc5.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/srvm.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/srvmhas.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/srvmasm.jar:/u01/app/oracle/product/11.2.0/db_1/classes:/u01/app/oracle/product/11.2.0/db_1/jlib/oemlt.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/emca.jar:/u01/app/oracle/product/11.2.0/db_1/sysman/jlib/emCORE.jar:/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/home/oc4j.jar:/u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/home/db_oc4j_deploy.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/emConfigInstall.jar:/u01/app/oracle/product/11.2.0/db_1/oui/jlib/OraInstaller.jar:/u01/app/oracle/product/11.2.0/db_1/oui/jlib/OraPrereq.jar:/u01/app/oracle/product/11.2.0/db_1/inventory/prereqs/oui/OraPrereqChecks.jar:/u01/app/oracle/product/11.2.0/db_1/oui/jlib/OraPrereqChecks.jar:/u01/app/oracle/product/11.2.0/db_1/oui/jlib/OraCheckPoint.jar:/u01/app/oracle/product/11.2.0/db_1/jlib/cvu.jar:/u01/app/oracle/product/11.2.0/db_1/dv/jlib/dvca.jar, COLORTERM=gnome-terminal, CVS_RSH=ssh, DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-adaf9CNM1D,guid=d3387d784624507fa8d3580053300ee1, DB_HOME=/u01/app/oracle/product/11.2.0/db_1, DESKTOP_SESSION=default, DESKTOP_STARTUP_ID=, DISPLAY=:0.0, GDMSESSION=default, GDM_XSERVER_LOCATION=local, GNOME_DESKTOP_SESSION_ID=Default, GNOME_KEYRING_SOCKET=/tmp/keyring-4JYBzj/socket, GRID_HOME=/u01/app/11.2.0/grid, GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2, G_BROKEN_FILENAMES=1, HISTSIZE=1000, HOME=/home/oracle, HOSTNAME=ol5-112-rac1.localdomain, INPUTRC=/etc/inputrc, KDEDIR=/usr, KDE_IS_PRELINKED=1, KDE_NO_IPV6=1, LANG=en_US.UTF-8, LC_ALL=, LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/jdk/jre/lib/amd64/server:/u01/app/oracle/product/11.2.0/db_1/jdk/jre/lib/amd64:/u01/app/oracle/product/11.2.0/db_1/jdk/jre/../lib/amd64:/u01/app/oracle/product/11.2.0/db_1/lib:/u01/app/oracle/product/11.2.0/db_1/network/lib:/u01/app/oracle/product/11.2.0/db_1/lib:/u01/app/oracle/product/11.2.0/db_1/network/lib, LESSOPEN=|/usr/bin/lesspipe.sh %s, LOGNAME=oracle, LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:, MAIL=/var/spool/mail/oracle, NEED_EXIT_CODE=1, NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat, ORACLE_BASE=/u01/app/oracle, ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1, ORACLE_HOSTNAME=ol5-112-rac1.localdomain, ORACLE_SID=RAC, ORACLE_TERM=xterm, ORACLE_UNQNAME=RAC, PATH=/u01/app/oracle/product/11.2.0/db_1/bin:/usr/bin:/usr/bin:/usr/ccs/bin:/u01/app/oracle/product/11.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin:/grid_soft/database/install, PWD=/u01/app/oracle/product/11.2.0/db_1/bin, SESSION_MANAGER=local/ol5-112-rac1.localdomain:/tmp/.ICE-unix/2674, SHELL=/bin/bash, SHLVL=3, SSH_AGENT_PID=2749, SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass, SSH_AUTH_SOCK=/tmp/ssh-mpFZGe2674/agent.2674, TERM=xterm, TMP=/tmp, TMPDIR=/tmp, USER=oracle, USERNAME=oracle, WINDOWID=29398445, XAUTHORITY=/tmp/.gdmTU9QDX, XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt, XMODIFIERS=@im=none]

      Mar 24, 2014 8:03:18 PM oracle.sysman.emcp.util.PlatformInterface executeCommand

      CONFIG: Starting execution: /u01/app/oracle/product/11.2.0/db_1/bin/emctl config emkey -remove_from_repos

       

      SQL> select inst_name from v$active_instances;

       

      INST_NAME

      --------------------------------------------------------------------------------

      ol5-112-rac1.localdomain:RAC1

      ol5-112-rac2.localdomain:RAC2

       

      SQL> select instance_name, host_name, status from v$instance;

       

       

      INSTANCE_NAME----------------HOST_NAME                                                        STATUS

      ---------------------------------------------------------------- ------------

      RAC2                            ol5-112-rac2.localdomain                                         OPEN

       

      Please let me know how to troubleshoot this issue.