13 Replies Latest reply: Apr 25, 2013 4:21 AM by )a! RSS

    OEM 11g login error with sys user.

    )a!
      I have two database in my local host. one is created with dbca and another is manually created.
      i am not able to login ONLY with "sys" user in OEM 11g but i can login in sqlplus with the same user(only in database created manually ).
        • 1. Re: OEM 11g login error with sys user.
          Kh$n
          OS version?
          DB version?.
          what error are you getting while login to manualy created db through OEM?
          i.e page not found or password error?
          • 2. Re: OEM 11g login error with sys user.
            Vishnusivathej
            If you trying to login using OEM... make sure you have the enterprise manager repository created for this manually created database and enterprise manager configured properly.

            If you have many databases running on the same host that are being managed by the enterprise manager, then each database has its own separate port number.

            Use the following commands
            emca -repos create
            • 3. Re: OEM 11g login error with sys user.
              )a!
              Db version - 11.2.0.1.0 32bit
              Os version - win7 professional 64bit
              repo created after the installation , even i am able to login with sysman user and system user . problem is only with sys user.
              Error

              Your username and/or password are invalid . but with same user i can able to login sqlplus .
              • 4. Re: OEM 11g login error with sys user.
                Kh$n
                login with sys user in sqlplus and issue below command

                sql> alter user sys identified by <password>;

                than try to login with OEM using new password.

                Edited by: Kh$n on Apr 24, 2013 11:43 PM

                Edited by: Kh$n on Apr 24, 2013 11:43 PM
                • 5. Re: OEM 11g login error with sys user.
                  )a!
                  Still same .....
                  • 6. Re: OEM 11g login error with sys user.
                    Kh$n
                    you are pointing correct OEM page?.i mean the manual db oem port??. check port number from $ORACLE_HOME/install/portlist.ini. and than try it.
                    • 7. Re: OEM 11g login error with sys user.
                      )a!
                      if i point some other point than how could i get login with sysman and system user ?
                      anyway i checked its correct.
                      • 8. Re: OEM 11g login error with sys user.
                        Kh$n
                        just reconfigure your oem
                        emca -deconfig dbcontrol db

                        emca -config dbcontrol db

                        and than try with sys user

                        Edited by: Kh$n on Apr 24, 2013 11:55 PM
                        • 9. Re: OEM 11g login error with sys user.
                          )a!
                          still its same... yesterday onwards i did thrice reconfigured but getting same problem only with SYS user , rest all user is working .
                          • 10. Re: OEM 11g login error with sys user.
                            Osama_Mustafa
                            jaydev trivedi wrote:
                            still its same... yesterday onwards i did thrice reconfigured but getting same problem only with SYS user , rest all user is working .
                            Reconfigured finished Successfully ? what is the user status ? Are you sure you type correct password ?
                            • 11. Re: OEM 11g login error with sys user.
                              )a!
                              yes m giving correct pwd as i mentioned i am bale to login with the same in sqlplus . below is the log details :

                              C:\Users\jatrived>emca -deconfig dbcontrol db

                              STARTED EMCA at Apr 25, 2013 12:33:20 PM
                              EM Configuration Assistant, Version 11.2.0.0.2 Production
                              Copyright (c) 2003, 2005, Oracle. All rights reserved.

                              Enter the following information:
                              Database SID: cgdb

                              Do you wish to continue? [yes(Y)/no(N)]: y
                              Apr 25, 2013 12:33:29 PM oracle.sysman.emcp.EMConfig perform
                              INFO: This operation is being logged at D:\oracle\cfgtoollogs\emca\cgdb\emca_2013_04_25_12_33_19.log.
                              Apr 25, 2013 12:33:30 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
                              INFO: Stopping Database Control (this may take a while) ...
                              Enterprise Manager configuration completed successfully
                              FINISHED EMCA at Apr 25, 2013 12:34:12 PM

                              C:\Users\jatrived>emca -config dbcontrol db

                              STARTED EMCA at Apr 25, 2013 12:34:29 PM
                              EM Configuration Assistant, Version 11.2.0.0.2 Production
                              Copyright (c) 2003, 2005, Oracle. All rights reserved.

                              Enter the following information:
                              Database SID: cgdb
                              Listener port number: 1521
                              Listener ORACLE_HOME [ D:\oracle\product\11.2.0\dbhome_1 ]:
                              Password for SYS user:
                              Password for DBSNMP user:
                              Password for SYSMAN user:
                              Password for SYSMAN user: Email address for notifications (optional):
                              Outgoing Mail (SMTP) server for notifications (optional):
                              -----------------------------------------------------------------

                              You have specified the following settings

                              Database ORACLE_HOME ................ D:\oracle\product\11.2.0\dbhome_1

                              Local hostname ................ ***********.corp.****.com
                              Listener ORACLE_HOME ................ D:\oracle\product\11.2.0\dbhome_1
                              Listener port number ................ 1521
                              Database SID ................ cgdb
                              Email address for notifications ...............
                              Outgoing Mail (SMTP) server for notifications ...............

                              -----------------------------------------------------------------
                              Do you wish to continue? [yes(Y)/no(N)]: y
                              Apr 25, 2013 12:35:12 PM oracle.sysman.emcp.EMConfig perform
                              INFO: This operation is being logged at D:\oracle\cfgtoollogs\emca\cgdb\emca_2013_04_25_12_34_29.log.
                              Apr 25, 2013 12:35:16 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
                              INFO: Uploading configuration data to EM repository (this may take a while) ...
                              Apr 25, 2013 12:36:26 PM oracle.sysman.emcp.EMReposConfig invoke
                              INFO: Uploaded configuration data successfully
                              Apr 25, 2013 12:36:33 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
                              INFO: Software library is already configured.
                              Apr 25, 2013 12:36:33 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
                              INFO: EM_SWLIB_STAGE_LOC (value) will be ignored.
                              Apr 25, 2013 12:36:33 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
                              INFO: Deploying Provisioning archives ...
                              Apr 25, 2013 12:37:29 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
                              INFO: Provisioning archives deployed successfully.
                              Apr 25, 2013 12:37:29 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
                              INFO: Securing Database Control (this may take a while) ...
                              Apr 25, 2013 12:37:36 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
                              INFO: Database Control secured successfully.
                              Apr 25, 2013 12:37:37 PM oracle.sysman.emcp.util.DBControlUtil startOMS
                              INFO: Starting Database Control (this may take a while) ...
                              Apr 25, 2013 12:38:23 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
                              INFO: Database Control started successfully
                              Apr 25, 2013 12:38:23 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
                              INFO: >>>>>>>>>>> The Database Control URL is https://***********.corp.****.com:5500/em <<<<<<<<<<<
                              Apr 25, 2013 12:38:25 PM oracle.sysman.emcp.EMDBPostConfig invoke
                              WARNING:
                              ************************ WARNING ************************

                              Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been pl
                              aced in the file: D:/oracle/product/11.2.0/dbhome_1/***********.corp.****.com_cgdb/sysman/config/emkey.ora. Please ensure this f
                              ile is backed up as the encrypted data will become unusable if this file is lost.

                              ***********************************************************
                              Enterprise Manager configuration completed successfully

                              FINISHED EMCA at Apr 25, 2013 12:38:25 PM


                              -----------------------------------------------------------------------------------------------------
                              portlist details :
                              here now two db having same port , how to remove or change ?

                              D:\oracle\product\11.2.0\dbhome_1\install>more portlist.ini
                              Enterprise Manager Console HTTP Port (ORA10) = 5500
                              Enterprise Manager Agent Port (ORA10) = 1830
                              Enterprise Manager Console HTTP Port (jai) = 1158
                              Enterprise Manager Agent Port (jai) = 3938
                              Enterprise Manager Console HTTP Port (test) = 1158
                              Enterprise Manager Agent Port (test) = 1830
                              Enterprise Manager Console HTTP Port (cgdb) = 5500
                              Enterprise Manager Agent Port (cgdb) = 1831
                              • 12. Re: OEM 11g login error with sys user.
                                Vishnusivathej
                                finally can you try again by recreating the password file.. just in case..
                                • 13. Re: OEM 11g login error with sys user.
                                  )a!
                                  thanx Vishnu.....even my friend suggest me the same and that's works \m/.....