1 2 Previous Next 22 Replies Latest reply on Aug 5, 2013 3:13 AM by 5cce2963-bb2c-40f4-b50b-c3c0908e6fbb Go to original post
      • 15. Re: Error while configuring Enterprise manager
        889465
        yes its up and running, i am able to access my database.
        i created a listener successfully.


        How to check that, my listener running or not???

        Regards,
        Praveen.
        • 16. Re: Error while configuring Enterprise manager
          889465
          Hi Rob Zoeteweij ,

          i got this message, my listener running.


          C:\>lsnrctl status

          LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 23-SEP-2011 04:20
          :40

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

          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
          STATUS of the LISTENER
          ------------------------
          Alias KUMAR
          Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
          ction
          Start Date 22-SEP-2011 17:44:58
          Uptime 0 days 10 hr. 35 min. 44 sec
          Trace Level off
          Security ON: Local OS Authentication
          SNMP OFF
          Listener Parameter File C:\oracle\product\11.2.0\dbhome_1\network\admin\listen
          er.ora
          Listener Log File c:\oracle\diag\tnslsnr\praveenkumarg\kumar\alert\log.x
          ml
          Listening Endpoints Summary...
          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=praveenkumarg)(PORT=1521)))
          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
          Services Summary...
          Service "CLRExtProc" has 1 instance(s).
          Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
          Service "praveen" has 1 instance(s).
          Instance "praveen", status READY, has 1 handler(s) for this service...
          Service "praveenXDB" has 1 instance(s).
          Instance "praveen", status READY, has 1 handler(s) for this service...
          The command completed successfully

          C:\>lsnrctl start

          LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 23-SEP-2011 04:21
          :40

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

          TNS-01106: Listener using listener name KUMAR has already been started

          C:\>
          • 17. Re: Error while configuring Enterprise manager
            889465
            I got this, after running "emctl status dbconsole"


            C:\>emctl status dbconsole
            Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da
            tabase unique name.
            • 18. Re: Error while configuring Enterprise manager
              889465
              Hi Rob Zoeteweij,

              i created a new database now, while creating database itself, i configured enterprise manager, so it gave me a link
              https://praveenkumarg:1158/em/

              I opened the browser and entered user name as "sysman"
              Password as "praveenkumar"
              connect as "sysdba"

              but its showing invalid username or password


              C:\Users\praveen kumar gogula>emctl status dbconsole
              Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
              Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
              https://praveenkumarg:1158/em/console/aboutApplication
              Access is denied.
              Oracle Enterprise Manager 11g is running.
              ------------------------------------------------------------------
              Logs are generated in directory C:\oracle\product\11.2.0\dbhome_1/praveenkumarg_praveenkumar/sysman/log


              still is there any problem, why its not connecting
              • 19. Re: Error while configuring Enterprise manager
                889465
                Hello friends, while again recreating i got is error.

                its saying
                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 .



                ----------------------------------------------------------------
                C:\Users\praveen kumar gogula>set ORACLE_SID=praveenkumar

                C:\Users\praveen kumar gogula>emca -repos recreate

                STARTED EMCA at Sep 23, 2011 5:17:48 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: praveenkumar
                Listener port number: 1158
                Password for SYS user:
                Password for SYSMAN user:
                Password for SYSMAN user:
                Do you wish to continue? [yes(Y)/no(N)]: Y
                Sep 23, 2011 5:18:25 PM oracle.sysman.emcp.EMConfig perform
                INFO: This operation is being logged at C:\oracle\cfgtoollogs\emca\praveenkumar\
                emca_2011_09_23_17_17_48.log.
                Sep 23, 2011 5:18:32 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 C:\oracle\cfgtoollogs\emca\praveenkumar\emca_2011_09_23
                _17_17_48.log for more details.
                Could not complete the configuration. Refer to the log file at C:\oracle\cfgtool
                logs\emca\praveenkumar\emca_2011_09_23_17_17_48.log for more details.

                C:\Users\praveen kumar gogula>
                ---------------------------------------------------------------------------


                Help me friends,



                Regards,
                Praveen.
                • 20. Re: Error while configuring Enterprise manager
                  vmahawar
                  Check whether you ORACLE_SID environment variable is set to 'praveenkumar' and its up and running.
                  Also make sure listener is up and running and registered to above oracle instance.

                  If everything above is already set.

                  Try one more thing are you able to connect as sys using oracle_sid like as follows:

                  $ conn sys@praveenkumar as sysdba

                  Thanks,
                  Viju.
                  blog: http://whizdba.wordpress.com

                  글 수정: user8384465

                  글 수정: user8384465
                  • 21. Re: Error while configuring Enterprise manager
                    889465
                    Hi, My database up and running,
                    You can see that, my listener also running.




                    C:\Users\Praveen Kumar Gogula>set ORACLE_SID=praveen

                    C:\Users\Praveen Kumar Gogula>lsnrctl status

                    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 24-SEP-2011 15:01
                    :58

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

                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                    STATUS of the LISTENER
                    ------------------------
                    Alias GOGULA
                    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
                    ction
                    Start Date 24-SEP-2011 04:02:20
                    Uptime 0 days 10 hr. 59 min. 42 sec
                    Trace Level off
                    Security ON: Local OS Authentication
                    SNMP OFF
                    Listener Parameter File c:\oracle\praveen\product\11.2.0\dbhome_1\network\admin\listener.ora
                    Listener Log File c:\oracle\praveen\diag\tnslsnr\PraveenKumar\gogula\alert\log.xml
                    Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=PraveenKumar)(PORT=1521)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                    Services Summary...
                    Service "CLRExtProc" has 1 instance(s).
                    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                    Service "praveen" has 1 instance(s).
                    Instance "praveen", status READY, has 1 handler(s) for this service...
                    Service "praveenXDB" has 1 instance(s).
                    Instance "praveen", status READY, has 1 handler(s) for this service...
                    The command completed successfully

                    C:\Users\Praveen Kumar Gogula>lsnrctl start

                    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 24-SEP-2011 15:02
                    :03

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

                    TNS-01106: Listener using listener name GOGULA has already been started

                    C:\Users\Praveen Kumar Gogula>emca -config dbcontrol db -repos create

                    STARTED EMCA at Sep 24, 2011 3:02:08 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: praveen
                    Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableExcep
                    tion: Database instance unavailable.
                    at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(Databas
                    eChecks.java:151)
                    at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChe
                    cks.java:144)
                    at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.
                    java:163)
                    at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.jav
                    a:582)
                    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAss
                    istant.java:1272)
                    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.jav
                    a:574)
                    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)


                    C:\Users\Praveen Kumar Gogula>emctl status dbconsole
                    Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da
                    tabase unique name.


                    I am getting the above error.


                    help me guys.

                    Note: While creating database, i did't configured enterprise manager
                    • 22. Re: Error while configuring Enterprise manager
                      5cce2963-bb2c-40f4-b50b-c3c0908e6fbb

                      配置一个tnsnames.ora文件应该就好了吧。。。

                      1 2 Previous Next