1 2 Previous Next 29 Replies Latest reply: Dec 27, 2012 9:22 AM by 515175 RSS

    cannot start enterprise manager

    user13412148
      Hello,

      I need some help to get the enterprise manager working. After upgrading from Oracle 10.2.0.1 to 10.2.0.5 the enterprise manager does not start anymore. I've checked all possibilities in the metalink 'ORA-01031: insufficient privileges' error when using EMCA to Create or Drop DBconsole [ID 358201.1] but I do not find the wrong setting.


      Trying to drop and create the enterprise manager repostitory I always get the message 'ORA-01031: insufficient privileges'.
      I've created a new password file with 'orapwd file=orapw<sid> password=XXXXX in $ORACLE_HOME/dbs, but still no change.


      $ emca -deconfig dbcontrol db -repos drop

      STARTED EMCA at Nov 21, 2011 2:46:38 PM
      EM Configuration Assistant, Version 10.2.0.5.0 Production
      Copyright (c) 2003, 2009, Oracle. All rights reserved.

      Enter the following information:
      Password for SYS user:
      Password for SYSMAN user:

      ----------------------------------------------------------------------
      WARNING : While repository is dropped the database will be put in quiesce mode.
      ----------------------------------------------------------------------

      Do you wish to continue? [yes(Y)/no(N)]: y
      Nov 21, 2011 2:46:44 PM oracle.sysman.emcp.EMConfig perform
      INFO: This operation is being logged at /opt/oracle/product/10.2.0/db_1/cfgtoollogs/emca/comas/emca_2011-11-21_02-46-38-PM.log.
      Nov 21, 2011 2:46:44 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
      WARNING: ORA-01017: invalid username/password; logon denied

      Nov 21, 2011 2:46:44 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
      WARNING: Error initializing SQL connection. SQL operations cannot be performed
      Nov 21, 2011 2:46:45 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
      WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
      1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
      2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
      Nov 21, 2011 2:46:45 PM oracle.sysman.emcp.EMReposConfig invoke
      INFO: Dropping the EM repository (this may take a while) ...
      Nov 21, 2011 2:46:45 PM oracle.sysman.emcp.EMReposConfig dropRepository
      INFO: Dropping the EM repository (this may take a while) ...
      Nov 21, 2011 2:46:45 PM oracle.sysman.emcp.EMReposConfig invoke
      INFO: Repository successfully dropped
      Enterprise Manager configuration completed successfully
      FINISHED EMCA at Nov 21, 2011 2:46:45 PM





      $ emca -config dbcontrol db -repos create
      STARTED EMCA at Nov 21, 2011 2:37:50 PM
      EM Configuration Assistant, Version 10.2.0.5.0 Production
      Copyright (c) 2003, 2009, Oracle. All rights reserved.

      Enter the following information:
      Nov 21, 2011 2:37:50 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
      WARNING: ORA-01031: insufficient privileges

      Nov 21, 2011 2:37:50 PM oracle.sysman.emcp.DatabaseChecks throwDBUnavailableException
      SEVERE:
      Database instance is unavailable. Fix the ORA error thrown and run EM Configuration Assistant again.

      Some of the possible reasons may be :

      1) Database may not be up.
      2) Database is started setting environment variable ORACLE_HOME with trailing '/'. Reset ORACLE_HOME and bounce the database.

      For eg. Database is started setting environment variable ORACLE_HOME=/scratch/db/ . Reset ORACLE_HOME=/scratch/db and bounce the database.



      ---------------------------
      The database is running and everything but the enterprise manager works fine:


      $ sqlplus sys as sysdba

      SQL*Plus: Release 10.2.0.5.0 - Production on Mon Nov 21 14:39:47 2011

      Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

      Enter password:

      Connected to:
      Oracle Database 10g Release 10.2.0.5.0 - 64bit Production

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

      INSTANCE_NAME STATUS VERSION
      ------------
      comas OPEN 10.2.0.5.0


      $ echo $ORACLE_HOME
      /opt/oracle/product/10.2.0/db_1


      Any hints appreciated
        • 1. Re: cannot start enterprise manager
          Srini Chavali-Oracle
          Pl apply the patch mentioned in MOS Doc 1217493.1 (ATTENTION - Enterprise Manager Database Control 10.2.0.4 Or 10.2.0.5 - Patch Required from 31-Dec-2010 onwards), then retry

          HTH
          Srini
          • 2. Re: cannot start enterprise manager
            user13412148
            Thank you for your answer. I've already installed the patch set 10.2.0.5.4 which includes the patch 8350262 recommended in [ID 1217493.1].
            There has to be another patch...
            • 3. Re: cannot start enterprise manager
              19426
              Are you sure you use the correct password for SYS and the password file is working?

              Assuming you are connected as a privileged OS user (member of group 'dba'), for such a connection password is irrelevant (because you use OS authentication):

              sqlplus sys as sysdba

              SQL*Plus: Release 10.2.0.4.0 - Production on Tue Nov 22 11:12:38 2011

              Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

              Enter password: <each_input_works>

              Connected to:

              ====================================

              Test it, type what you want as password. But emca uses a listener based connection, here a wrong password creates this output:

              sqlplus sys@fpsp as sysdba

              SQL*Plus: Release 10.2.0.4.0 - Production on Tue Nov 22 11:14:38 2011

              Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

              Enter password: <must_be_correct>
              ERROR:
              ORA-01031: insufficient privileges

              ========================================

              Make a test on your site with sqlplus. And double-check password file creation.

              Werner
              • 4. Re: cannot start enterprise manager
                JohnJomon
                Hi,

                I had this problem before (long before)

                You need to check following:-

                1. Can you connect to the database as sysdba?

                2. Do you have your dbname in tnsnames.ora?

                3. Are you doing sqlplus with the same user who owns the oracle binaries?

                Please respond, we can fix this problem.

                Regards
                Jomon
                • 5. Re: cannot start enterprise manager
                  user13412148
                  No, any password doesn't work (user oracle in group dba):


                  $ sqlplus sys as sysdba

                  SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 22 12:09:28 2011

                  Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

                  Enter password:
                  ERROR:
                  ORA-01017: invalid username/password; logon denied



                  But with the correct password the login is working:

                  $ sqlplus sys as sysdba

                  SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 22 12:11:12 2011

                  Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

                  Enter password:

                  Connected to:
                  Oracle Database 10g Release 10.2.0.5.0 - 64bit Production



                  As I said - everything seems to be fine and working except the enterprise manager. The password is correct - I've checked it many times and recreated the password file without success.
                  • 6. Re: cannot start enterprise manager
                    JohnJomon
                    Try this

                    export ORACLE_HOME=_your database home value_

                    export PATH=$ORACLE_HOME/bin:$PATH

                    sqlplus /nolog

                    connect /as sysdba

                    Edited by: JohnJomon on Nov 22, 2011 11:27 AM
                    • 7. Re: cannot start enterprise manager
                      user13412148
                      You need to check following:-

                      1. Can you connect to the database as sysdba?
                      Yes, no problem here. The database is running fine.
                      2. Do you have your dbname in tnsnames.ora?
                      Hm no, in section CONNECT_DATA I only have the SERVICE_NAME that is the same as the global_name of the database. That one is consisting of the db_name and the db_domain.
                      Isn't that correct?
                      3. Are you doing sqlplus with the same user who owns the oracle binaries?
                      yes, I'm trying to do this as root and as user oracle. The binaries belong to oracle.


                      I'm very curious about the solution. Thanks in advance!
                      • 8. Re: cannot start enterprise manager
                        user13412148
                        Hm, insufficient privileges!

                        $ sqlplus /nolog

                        SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 22 12:32:15 2011

                        Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

                        SQL> connect / as sysdba
                        ERROR:
                        ORA-01031: insufficient privileges
                        • 9. Re: cannot start enterprise manager
                          JohnJomon
                          Here is a typical tns entry. Make sure you have a similar entry in tnsnames.ora (please change the underlined values with yours')

                          DBNAME =
                          (DESCRIPTION =
                          (ADDRESS_LIST =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERNAME)(PORT = _1521_))
                          )
                          (CONNECT_DATA =
                          (SERVICE_NAME = DBNAME)
                          )
                          )

                          If you are connected to the server as root and the Oracle binaries are own by oracle you will have problems. Therefore make sure you are doing everything by the same user who own the oracle binaries.

                          Please clarify on above, so that I can go to the next step.

                          Edited by: JohnJomon on Nov 22, 2011 11:40 AM
                          • 10. Re: cannot start enterprise manager
                            JohnJomon
                            ok.

                            post the result of following

                            echo $ORACLE_HOME

                            echo $PATH

                            echo $LD_LIBRARY_PATH

                            echo $ORACLE_SID

                            Also let me know if you can connect to the database as any user

                            Edited by: JohnJomon on Nov 22, 2011 11:39 AM
                            • 11. Re: cannot start enterprise manager
                              user13412148
                              $ echo $ORACLE_HOME
                              /opt/oracle/product/10.2.0/db_1
                              $ echo $PATH
                              /usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/opt/oracle/product/10.2.0/db_1/bin/:/root/bin:/opt/oracle/product/10.2.0/db_1/bin/
                              $ echo $LD_LIBRARY_PATH
                              $LD_LIBRARY_PATH:/opt/pipelinepilot/apps/scitegic/core/packages_linux64/datadirect/lib:/opt/symyx/direct70/lib/
                              $ echo $ORACLE_SID
                              comas

                              Yes, I can connect as user:

                              sqlplus scott/tiger@comas

                              SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 22 12:44:28 2011

                              Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


                              Connected to:
                              Oracle Database 10g Release 10.2.0.5.0 - 64bit Production
                              • 12. Re: cannot start enterprise manager
                                JohnJomon
                                Please do following and post the outcome:-

                                1. export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:$LD_LIBRARY_PATH

                                2. unset TWO_TASK

                                3. sqlplus /nolog

                                4. connect /as sysdba

                                5. exit from sqlplus

                                6. tnsping comas
                                • 13. Re: cannot start enterprise manager
                                  user13412148
                                  $ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib:$LD_LIBRARY_PATH
                                  $ unset TWO_TASK
                                  $ sqlplus /nolog

                                  SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 22 14:20:03 2011

                                  Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

                                  SQL> connect /as sysdba
                                  ERROR:
                                  ORA-01031: insufficient privileges

                                  $ tnsping comas

                                  TNS Ping Utility for Linux: Version 10.2.0.5.0 - Production on 22-NOV-2011 14:20:24

                                  Copyright (c) 1997, 2010, Oracle. All rights reserved.

                                  Used parameter files:
                                  /opt/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


                                  Used TNSNAMES adapter to resolve the alias
                                  Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <MyHOSTNAME>)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = comas.<MyHOSTNAME>)))
                                  OK (0 msec)
                                  • 14. Re: cannot start enterprise manager
                                    JohnJomon
                                    Try connect sys/password@database as sysdba
                                    If that fails, try to connect as system/password@database and then type following on sql prompt.

                                    show parameter remote_login_passwordfile

                                    select * from v$pwfile_users;


                                    Post the results here
                                    1 2 Previous Next