1 Reply Latest reply on Jul 16, 2009 3:40 AM by Aman....

    Problem with ASM page in OEM

    643638
      I created an ASM instance manually. Then I created a database using ASM with DBCA. The installation was good, only I ignored a msgbox about user/password of ASM.

      When I enter to Oracle Enterprise Manager from browser, it seems to work well, but when I click to link ASM page(general section) appears a Actual status is DOWN. I cant see any info about ASM. I checked the alerts an appers the next message: "Failed to connect to the ASM instance. ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)".

      If I use sqlplus to connect to ASM instance, it works very good. ALso, I created an tablespace on diskgroup.

      Any ideas in order to see the ASM info in the OEM?

      ******* version
      The version of linux database is:
      Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
      PL/SQL Release 10.2.0.1.0 - Production
      CORE 10.2.0.1.0 Production
      TNS for Linux: Version 10.2.0.1.0 - Production
      NLSRTL Version 10.2.0.1.0 - Production

      ********listener

      [oracle@localhost admin]$ lsnrctl status

      LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 15-JUL-2009 22:08:20

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER
      Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
      Start Date 15-JUL-2009 21:26:22
      Uptime 0 days 0 hr. 41 min. 57 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
      Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
      Services Summary...
      Service "+ASM" has 2 instance(s).
      Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service...
      Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
      Service "+ASM_XPT" has 1 instance(s).
      Instance "+ASM", status BLOCKED, has 1 handler(s) for this service...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Service "dbsasm" has 1 instance(s).
      Instance "dbsasm", status READY, has 1 handler(s) for this service...
      Service "dbsasmXDB" has 1 instance(s).
      Instance "dbsasm", status READY, has 1 handler(s) for this service...
      Service "dbsasm_XPT" has 1 instance(s).
      Instance "dbsasm", status READY, has 1 handler(s) for this service...
      The command completed successfully