11 Replies Latest reply: Dec 29, 2009 2:07 AM by Pavan Kumar RSS

    The listener supports no services-10g

    609621
      Dear all,

      10g on solaris 10

      I shutdown the db and stop the listener ..when I start the listener using

      lsnrctl start LISTENER

      is starts and displays
      The listener supports no services
      The command completed successfully
      # listener.ora Network Configuration File: /appl/oracle/product/1014/network/admin/listener.ora
      # Generated by Oracle configuration tools.
      
      SID_LIST_LISTENER =
        (SID_LIST =
          (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /appl/oracle/product/1014)
            (PROGRAM = extproc)
          )
          (SID_DESC =
            (GLOBAL_DBNAME = orcl.med.com.sg)
            (ORACLE_HOME = /appl/oracle/product/1014)
            (SID_NAME = orcl)
          )
        )
      
      LISTENER =
        (DESCRIPTION_LIST =
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = tsta02.med.com.sg)(PORT = 1521))
          )
          (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          )
        )
      when am trying to login to db to start the db , am getting the below error :
      export ORACLE_SID=ORCL
      
      sqlplus sys/password as sysdba
      
      ERROR:
      ORA-12545: Connect failed because target host or object does not exist
      
      
      tried 
      
      
      sqlplus sys/password@orcl as sysdba
      
      
      ERROR:
      ORA-12154: TNS:could not resolve the connect identifier specified
      Any idea what am missing ?

      kai