This discussion is archived
1 2 Previous Next 29 Replies Latest reply: Dec 27, 2012 7:22 AM by 515175 RSS

cannot start enterprise manager

847201 Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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
    847201 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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
    650784 Explorer
    Currently Being Moderated
    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
    847201 Newbie
    Currently Being Moderated
    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
    650784 Explorer
    Currently Being Moderated
    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
    847201 Newbie
    Currently Being Moderated
    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
    847201 Newbie
    Currently Being Moderated
    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
    650784 Explorer
    Currently Being Moderated
    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
    650784 Explorer
    Currently Being Moderated
    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
    847201 Newbie
    Currently Being Moderated
    $ 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
    650784 Explorer
    Currently Being Moderated
    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
    847201 Newbie
    Currently Being Moderated
    $ 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
    650784 Explorer
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points