1 2 Previous Next 21 Replies Latest reply: Feb 11, 2013 6:28 PM by ursusca RSS

    Error starting Database control

    alvahtin
      Why Database Configuration Assistant finalizing warining:

      Error starting Database Control. Please execute the following command(s):

      1) Set the environment variable ORACLE_UNQNAME to
      Databse unique name
      2) /u01/app/oracle/product/11.2.0/db_1/bin/emctl
      start dbconsole

      The variables ORACLE_UNQUNAME, ORACLE_HOSTNAME, etc. is set. When I run

      /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole

      writes:

      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
      Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
      https://localhost:1158/em/console/aboutApplication
      - An instance of Oracle Enterprise Manager 11g Database Control is already running.


      This problem arises always when Database Configuration Assistant create new database - during installing (first time) and use after.

      My system: VirtualBox 4.2.6, Oracle Linux Release 5 update 9, Database 11gR2
        • 1. Re: Error starting Database control
          ursusca
          The ORACLE_UNQNAME is just an operating system environment variable. Compare it with db_unique_name:

          select name, db_unique_name
          from v$database;

          It should be the same
          • 2. Re: Error starting Database control
            Osama_Mustafa
            Please refer to understand what ORACLE_UNQNAME name is
            http://blog.mclaughlinsoftware.com/2012/08/23/whats-oracle_unqname/


            Also Post the error as you see it , did you check logs ?
            • 3. Re: Error starting Database control
              alvahtin
              It should be the same
              Yes,

              NAME=ORCL

              db_unique_name=orcl

              ORACLE_UNQNAME=orcl
              • 4. Re: Error starting Database control
                sb92075
                alvahtin wrote:
                It should be the same
                Yes,

                NAME=ORCL
                what is "NAME"?

                >
                db_unique_name=orcl

                ORACLE_UNQNAME=orcl
                on *NIX ORACLE_SID  is CaseSenSitive
                "orcl" is different from "ORCL"
                • 5. Re: Error starting Database control
                  ursusca
                  Well, the DBCA creates the EM repository and starts the DBCONSOLE automatically. You don't need to start it up manually. What is your issue? It says that it's running but it's not available for you?
                  • 6. Re: Error starting Database control
                    ursusca
                    NAME is the name of the database. DB_UNIQUE_NAME specifies a globally unique name for the database within an enterprise. If you are using RAC, data guard and many duplication db_names. It's a case sensitive but it looks like that they are both lower case.
                    • 7. Re: Error starting Database control
                      alvahtin
                      dbconsole starts, because when I try start to print message:

                      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
                      Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
                      https://localhost:1158/em/console/aboutApplication
                      - An instance of Oracle Enterprise Manager 11g Database Control is already running.

                      But when run Database Configuration Assistant (Create database) raise this message (it is snapshot): http://s42.radikal.ru/i097/1302/2d/a021d77042e5.jpg

                      emConfig.log has same errors:

                      --------

                      oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28000: the account is locked

                      <.....>

                      CONFIG: Cannnot parse EMD_URL correctly. No port identified
                      Feb 9, 2013 12:20:31 AM oracle.sysman.emcp.util.FileUtil getProperties
                      CONFIG: Error reading file /u01/app/oracle/product/11.2.0/db_1/install/staticports.ini

                      <.....>

                      CONFIG: Cluster Error Message: PRCD-1027 : Failed to retrieve database hist
                      PRCR-1070 : Failed to check if resource ora.hist.db is registered

                      <....>

                      Feb 9, 2013 12:37:20 AM oracle.sysman.emcp.util.PlatformInterface executeCommand
                      WARNING: Error executing /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole

                      <....>

                      Feb 9, 2013 12:46:39 AM oracle.sysman.emcp.EMDBPostConfig invoke
                      WARNING: Error starting Database Control.Please execute the following command(s).

                      1) Set the environment variable ORACLE_UNQNAME to Database unique name
                      2) /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole
                      Feb 9, 2013 12:46:39 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
                      CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui
                      Feb 9, 2013 12:46:39 AM oracle.sysman.emcp.EMConfig perform
                      CONFIG:

                      Error starting Database Control.Please execute the following command(s).

                      1) Set the environment variable ORACLE_UNQNAME to Database unique name
                      2) /u01/app/oracle/product/11.2.0/db_1/bin/emctl start dbconsole
                      Feb 9, 2013 12:46:39 AM oracle.sysman.emcp.EMConfig perform
                      CONFIG: Passing warning to the caller:
                      Feb 9, 2013 12:46:39 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
                      CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui

                      ---------

                      But database was created, database control is running.
                      • 8. Re: Error starting Database control
                        ursusca
                        Could you please post ~oracle/.bash_profile and /etc/hosts files?
                        • 9. Re: Error starting Database control
                          alvahtin
                          .bash_profile
                          --------------------
                          # .bash_profile

                          # Get the aliases and functions
                          if [ -f ~/.bashrc ]; then
                               . ~/.bashrc
                          fi

                          # User specific environment and startup programs

                          PATH=$PATH:$HOME/bin

                          export PATH


                          # Oracle Parameters

                          umask 022
                          PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
                          ORACLE_BASE=/u01/app/oracle
                          ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
                          ORACLE_SID=orcl
                          ORACLE_UNQNAME=orcl
                          ORACLE_HOSTNAME=localhost

                          PATH=$ORACLE_HOME/bin:$PATH
                          LD_LIBRARY_PATH=$ORACLE_HOME/lib
                          export ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_UNQNAME
                          export PATH LD_LIBRARY_PATH
                          export ORACLE_HOSTNAME

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

                          hosts:
                          ----------------------------------
                          # Do not remove the following line, or various programs
                          # that require network functionality will fail.
                          127.0.0.1          localhost.localdomain localhost
                          ::1          localhost6.localdomain6 localhost6
                          -------------------------------
                          • 10. Re: Error starting Database control
                            ursusca
                            You should give your database server a name :-)))

                            Try to:

                            1. Drop the repository:
                            emca -repos drop

                            2. Stop the database

                            3. Give your box a name:
                            vim /etc/sysconfig/network

                            HOSTNAME=

                            4. Edit the /etc/hosts file
                            # Do not remove the following line, or various programs
                            # that require network functionality will fail.
                            127.0.0.1     localhost.localdomain localhost
                            ::1     localhost6.localdomain6 localhost6

                            <IP ADDRESS> <hostname>.<domainname> <hostname>

                            5. Edit the ~oracle/.bash_profile file
                            ORACLE_HOSTNAME=<hostname>

                            6. Restart the box

                            7. Start the listener and the database

                            8. Create the repository
                            emca -repos create
                            emca -config dbcontrol db
                            • 11. Re: Error starting Database control
                              alvahtin
                              etc/sysconfig/network:

                              NETWORKING=yes
                              NETWORKING_IPV6=yes
                              HOSTNAME=oracle
                              ---------

                              /etc/hosts:

                              # Do not remove the following line, or various programs
                              # that require network functionality will fail.
                              127.0.0.1          localhost.localdomain localhost
                              ::1          localhost6.localdomain6 localhost6


                              10.0.2.15 oracle.localdomain oracle

                              ---------

                              /home/oracle/.bash_profile:

                              # .bash_profile

                              # Get the aliases and functions
                              if [ -f ~/.bashrc ]; then
                                   . ~/.bashrc
                              fi

                              # User specific environment and startup programs

                              PATH=$PATH:$HOME/bin

                              export PATH


                              # Oracle Parameters

                              umask 022
                              PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
                              ORACLE_BASE=/u01/app/oracle
                              ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
                              ORACLE_SID=orcl
                              ORACLE_UNQNAME=orcl
                              ORACLE_HOSTNAME=oracle


                              PATH=$ORACLE_HOME/bin:$PATH
                              LD_LIBRARY_PATH=$ORACLE_HOME/lib
                              export ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_UNQNAME
                              export PATH LD_LIBRARY_PATH
                              export ORACLE_HOSTNAME

                              ---------

                              pp 1-7 no problem.

                              ----------
                              emca -repos create:

                              <....>
                              INFO: Repository successfully created
                              Enterprise Manager configuration completed successfully
                              FINISHED EMCA at Feb 11, 2013 9:45:30 PM

                              -----------
                              emca -config dbcontrol db:


                              <....>
                              SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
                              Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2013_02_11_21_48_20.log for more details.
                              Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2013_02_11_21_48_20.log for more details.

                              ------------
                              /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2013_02_11_21_48_20.log:

                              <...>
                              CONFIG: Marking HTTP port: 1158 from /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl
                              Feb 11, 2013 9:50:16 PM oracle.sysman.emcp.util.PortManager getAgentPort
                              CONFIG: Cannot parse EMD_URL correctly. No port identified
                              Feb 11, 2013 9:50:16 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                              CONFIG: Marking Agent port: null from /u01/app/oracle/product/11.2.0/db_1/sysman/config/emd.properties
                              Feb 11, 2013 9:50:16 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
                              CONFIG: Cannnot parse EMD_URL correctly. No port identified
                              Feb 11, 2013 9:50:17 PM oracle.sysman.emcp.util.FileUtil getProperties
                              CONFIG: Error reading file /u01/app/oracle/product/11.2.0/db_1/install/staticports.ini
                              Feb 11, 2013 9:50:17 PM oracle.sysman.emcp.util.PortManager getFreePorts
                              CONFIG: /u01/app/oracle/product/11.2.0/db_1:oracle:null:orcl:{}:null:{DBCONTROL_HTTP_PORT=5500, RMI_PORT=5521, JMS_PORT=5541, AGENT_PORT=3938}
                              <....>
                              Feb 11, 2013 9:50:48 PM oracle.sysman.emcp.ParamsManager setParam
                              CONFIG: Setting param: REP_DB_RUNNING_HOST value: oracle
                              Feb 11, 2013 9:50:48 PM oracle.sysman.emcp.ParamsManager getRepDbPort
                              CONFIG: Listener Port: 1521
                              Feb 11, 2013 9:50:48 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
                              CONFIG: isLocalConnectionRequired: true
                              Feb 11, 2013 9:50:48 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                              CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
                              Feb 11, 2013 9:50:48 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                              CONFIG: SQLEngine connecting with SID: orcl, oracleHome: /u01/app/oracle/product/11.2.0/db_1, and user: SYSMAN
                              Feb 11, 2013 9:50:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
                              CONFIG: SQLEngine created successfully and connected
                              Feb 11, 2013 9:50:51 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
                              CONFIG: ORA-12541: TNS:no listener

                              oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12541: TNS:no listener

                                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1650)
                                   at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1898)
                                   at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3230)
                                   at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1000)
                                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:345)
                                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
                                   at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
                                   at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
                                   at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                                   at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                                   at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                              Feb 11, 2013 9:50:51 PM oracle.sysman.emcp.EMConfig perform
                              SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
                              Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2013_02_11_21_48_20.log for more details.
                              Feb 11, 2013 9:50:51 PM oracle.sysman.emcp.EMConfig perform
                              CONFIG: Stack Trace:
                              oracle.sysman.emcp.exception.EMConfigException: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
                                   at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3245)
                                   at oracle.sysman.emcp.EMReposConfig.unlockMGMTAccount(EMReposConfig.java:1000)
                                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:345)
                                   at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
                                   at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
                                   at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
                                   at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
                                   at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
                                   at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
                              Feb 11, 2013 9:50:51 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
                              CONFIG: Restoring oracle.installer.oui_loc to /u01/app/oracle/product/11.2.0/db_1/oui

                              ---------

                              I think this exact same error, that was. What else can I do?

                              Edited by: alvahtin on 11.02.2013 12:43
                              • 12. Re: Error starting Database control
                                sb92075
                                post results of following OS commands

                                id
                                env | sort
                                lsnrctl start
                                ### wait 60+ seconds before proceeding
                                lsnrctl status
                                lsnrctl service

                                COPY the results from above then PASTE all back here
                                • 13. Re: Error starting Database control
                                  ursusca
                                  You didn't edit the listener.ora file. Sorry, I forgot to mention that. Change the hostaname/ip address

                                  LISTENER =
                                  (DESCRIPTION_LIST =
                                  (DESCRIPTION =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = <hostname/ip address>)(PORT = 1521))
                                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
                                  )
                                  )

                                  ADR_BASE_LISTENER = /u01/app/oracle

                                  Edited by: ursusca on Feb 11, 2013 4:13 PM
                                  • 14. Re: Error starting Database control
                                    alvahtin
                                    [oracle@oracle ~]$ id
                                    uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
                                    [oracle@oracle ~]$ env | sort
                                    _=/bin/env
                                    COLORTERM=gnome-terminal
                                    CVS_RSH=ssh
                                    DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-BL5jBWK4nn,guid=b6a739c116232b46c6bbf000511931ce
                                    DESKTOP_SESSION=default
                                    DESKTOP_STARTUP_ID=
                                    DISPLAY=:0.0
                                    G_BROKEN_FILENAMES=1
                                    GDMSESSION=default
                                    GDM_XSERVER_LOCATION=local
                                    GNOME_DESKTOP_SESSION_ID=Default
                                    GNOME_KEYRING_SOCKET=/tmp/keyring-FEzyor/socket
                                    GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
                                    HISTSIZE=1000
                                    HOME=/home/oracle
                                    HOSTNAME=oracle
                                    INPUTRC=/etc/inputrc
                                    LANG=en_US.UTF-8
                                    LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/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
                                    ORACLE_BASE=/u01/app/oracle
                                    ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
                                    ORACLE_HOSTNAME=oracle
                                    ORACLE_SID=orcl
                                    ORACLE_UNQNAME=orcl
                                    PATH=/usr/kerberos/bin:/u01/app/oracle/product/11.2.0/db_1/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
                                    PWD=/home/oracle
                                    SESSION_MANAGER=local/oracle:/tmp/.ICE-unix/2954
                                    SHELL=/bin/bash
                                    SHLVL=2
                                    SSH_AGENT_PID=3029
                                    SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
                                    SSH_AUTH_SOCK=/tmp/ssh-PVFoVF2954/agent.2954
                                    TERM=xterm
                                    USERNAME=oracle
                                    USER=oracle
                                    WINDOWID=30408785
                                    XAUTHORITY=/tmp/.gdm3FAASW
                                    XMODIFIERS=@im=none
                                    [oracle@oracle ~]$ lsnrctl start

                                    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-FEB-2013 00:52:51

                                    Copyright (c) 1991, 2009, Oracle. All rights reserved.

                                    TNS-01106: Listener using listener name LISTENER has already been started
                                    [oracle@oracle ~]$ lsnrctl status

                                    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-FEB-2013 00:53:14

                                    Copyright (c) 1991, 2009, Oracle. All rights reserved.

                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
                                    STATUS of the LISTENER
                                    ------------------------
                                    Alias LISTENER
                                    Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
                                    Start Date 11-FEB-2013 22:01:26
                                    Uptime 0 days 2 hr. 51 min. 49 sec
                                    Trace Level off
                                    Security ON: Local OS Authentication
                                    SNMP OFF
                                    Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
                                    Listener Log File /u01/app/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
                                    Listening Endpoints Summary...
                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                                    The listener supports no services
                                    The command completed successfully
                                    [oracle@oracle ~]$ lsnrctl service

                                    LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-FEB-2013 00:53:46

                                    Copyright (c) 1991, 2009, Oracle. All rights reserved.

                                    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
                                    The listener supports no services
                                    The command completed successfully
                                    [oracle@oracle ~]$

                                    Edited by: alvahtin on 11.02.2013 13:25
                                    1 2 Previous Next