1 2 Previous Next 29 Replies Latest reply: Dec 27, 2012 9:22 AM by user512172 Go to original post RSS
      • 15. Re: cannot start enterprise manager
        user13412148
        $ sqlplus sys@comas as sysdba

        SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 22 15:07:55 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> show parameter remote_login_passwordfile;
        NAME TYPE VALUE
        ----
        remote_login_passwordfile string EXCLUSIVE

        SQL> select * from v$pwfile_users;
        USERNAME SYSDB SYSOP
        ----
        SYS TRUE TRUE
        • 16. Re: cannot start enterprise manager
          JohnJomon
          hmm, does the password file exists?

          Please do following and post the results:-

          ls -lrt $ORACLE_HOME/dbs

          Edited by: JohnJomon on Nov 22, 2011 2:32 PM
          • 17. Re: cannot start enterprise manager
            user13412148
            yea, sure:

            # ls -lrt $ORACLE_HOME/dbs
            insgesamt 7068
            -rw-r----- 1 oracle oracle 8385 11. Sep 1998 init.ora
            -rw-r--r-- 1 oracle oracle 12920 3. Mai 2001 initdw.ora
            -rw-r----- 1 oracle oracle 1552 12. Mai 2011 hc_aem2.dat
            -rw-r----- 1 oracle oracle 24 16. Mai 2011 lkCOMAS
            -rw-rw---- 1 oracle oracle 112 18. Nov 12:00 alert_comas.log
            -rw-r----- 1 oracle oracle 3584 18. Nov 13:10 spfilecomas.ora
            -rw-rw---- 1 oracle oracle 1552 18. Nov 13:10 hc_comas.dat
            -rw-r----- 1 oracle oracle 1536 21. Nov 15:35 orapwcomas
            -rw-rw---- 1 oracle oracle 7159808 22. Nov 10:46 snapcf_comas.f
            -rw-r--r-- 1 oracle oracle 1509 22. Nov 10:50 pfilecomas.ora
            • 18. Re: cannot start enterprise manager
              JohnJomon
              please post the outcome of ps -ef|grep pmon and do following.

              If possible, shutdown the database and start it. Make sure that all env values are correct

              If that doesnt work do following:-

              take a backup of orapwcomas and delete it
              then create a new password file

              example orapwd file=$ORACLE_HOME/dbs/orapwcomas password=syspassword entries=10

              Edited by: JohnJomon on Nov 22, 2011 3:02 PM
              • 19. Re: cannot start enterprise manager
                user13412148
                please post the outcome of ps -ef|grep pmon and do following.
                while running:
                # ps -ef | grep pmon
                oracle 4992 1 0 Nov18 ? 00:00:00 ora_pmon_comas
                If possible, shutdown the database and start it. Make sure that all env values are correct

                If that doesnt work do following:-

                take a backup of orapwcomas and delete it
                then create a new password file

                example orapwd file=$ORACLE_HOME/dbs/orapwcomas password=syspassword entries=10
                I already did this before. But lets have another try...

                Hm, no. Doesn't work even after restarting oracle.

                Maybe I have an useful hint. Before upgrading from 10.2.0.1 to 10.2.0.5 the enterprise manager used the hostname with full qualified domain name that are 35 characters. After the upgrade the hostname could not be more than 32 characters and I changed the position of hostname and hostname.FQDM in /etc/hosts. Now oracle uses the short hostname but the old repository was not working anymore. I could drop it but I cannot create it.
                Any new ideas?

                # emca -config dbcontrol db -repos create

                STARTED EMCA at Nov 23, 2011 11:50:12 AM
                EM Configuration Assistant, Version 10.2.0.5.0 Production
                Copyright (c) 2003, 2009, Oracle. All rights reserved.

                Enter the following information:
                Database SID: comas
                Nov 23, 2011 11:50:17 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
                WARNING: ORA-01031: insufficient privileges

                Nov 23, 2011 11:50:17 AM 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.



                Database is up and ORACLE_HOME does not contain a trailing /.
                • 20. Re: cannot start enterprise manager
                  JohnJomon
                  can you paste the outcome of env
                  • 21. Re: cannot start enterprise manager
                    user13412148
                    nothing fancy:

                    HOSTNAME=<MyHostname>
                    DB_NAME=comas
                    SHELL=/bin/bash
                    TERM=xterm
                    HISTSIZE=1000
                    ODBCINST=/opt/pipelinepilot/apps/scitegic/core/packages_linux64/datadirect/odbcinst.ini
                    SSH_TTY=/dev/pts/2
                    USER=oracle
                    LD_LIBRARY_PATH=/opt/oracle/product/10.2.0/db_1/lib:/opt/oracle/product/10.2.0/db_1/ctx/lib:$LD_LIBRARY_PATH:/opt/pipelinepilot/apps/scitegic/core/packages_linux64/datadirect/lib:/opt/symyx/direct70/lib/
                    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:
                    ORACLE_SID=comas
                    ORACLE_BASE=/opt/oracle
                    DB_UNIQUE_NAME=comas
                    MSM_PRODUCT=MSM
                    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/
                    MAIL=/var/spool/mail/root
                    PWD=/opt/oracle/product/10.2.0/db_1/network/admin
                    LANG=de_DE.UTF-8
                    HOME=/home/oracle
                    SHLVL=2
                    ODBCINI=/opt/pipelinepilot/apps/scitegic/core/packages_linux64/datadirect/odbc.ini
                    MSM_HOME=/usr/local/MegaRAID Storage Manager
                    LOGNAME=oracle
                    CVS_RSH=ssh
                    DISPLAY=localhost:12.0
                    ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
                    G_BROKEN_FILENAMES=1
                    _=/bin/env
                    • 22. Re: cannot start enterprise manager
                      JohnJomon
                      Have your user group of oracle changed by any chance?

                      And can you exit from the server and connect as oracle, and then get the env values? Dont' connect as root
                      • 23. Re: cannot start enterprise manager
                        user13412148
                        Have your user group of oracle changed by any chance?
                        no, just the hostname has changed.
                        And can you exit from the server and connect as oracle, and then get the env values? Dont' connect as root
                        I already did that above as user oracle and not as root
                        • 24. Re: cannot start enterprise manager
                          JohnJomon
                          Is this hostname correct in your tns entry?

                          Again, unset two_task

                          remove and then recreate the password file
                          • 25. Re: cannot start enterprise manager
                            user13412148
                            Is this hostname correct in your tns entry?
                            Now I've removed the FQDN from the hostname in the tnsnames.ora but still no success.
                            Again, unset two_task
                            Never set this before. It's unset.
                            remove and then recreate the password file
                            Done. Nothing. Insufficient privileges.... very strange....
                            • 26. Re: cannot start enterprise manager
                              919402
                              Check to see if your oracle user is part of the The Oracle Inventory "install" group. I ran into this same problem after changing ownership of the Oracle installation files.

                              I determined what group this was by looking at the file $ORACLE_HOME/oraInst.loc ... there is an entry for inst_group=xxxx.

                              I added the oracle user to this group and it fixed this issue for me.

                              -- John
                              • 27. Re: cannot start enterprise manager
                                937709
                                I experienced the exact same errors as described above, and followed the same steps.
                                The only difference in my scenario was that Oracle was running on windows environment.

                                So to resolve this issue on the Windows environment, make sure the windows user you are using to run the command "emca -config dbcontrol db -repos create" is part of the "ora_dba" local group.
                                (in my case it was the local administrator)

                                After further investigation this user was removed from this group as part of a audit.

                                Anyway this resolved the issue for me. Thanks for the above suggestions.
                                • 28. Re: cannot start enterprise manager
                                  onedbguru
                                  As weird as it may seem, when on RAC you can also get the ORA-01031 error when one of the nodes is not in it's own known_hosts file.


                                  from EACH node:
                                  ssh node1 date
                                  ssh node2 date
                                  ssh node3 date

                                  We had added a node and for some reason node2 was not in it's own known_hosts file.

                                  Just thought I would add it here in case someone else ran into this issue on RAC
                                  • 29. Re: cannot start enterprise manager
                                    user512172
                                    Wonderful!
                                    This solved my ORA-01031: insufficient privileges
                                    (Windows authentication problem!)
                                    Thanks!
                                    1 2 Previous Next