Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2010
    Posts
    64

    Unanswered: The listener supports no services

    Hi,

    I am not able to connect to database.

    I am getting below mentioned error.

    LSNRCTL> status listener
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC15 21)))
    STATUS of the LISTENER
    ------------------------
    Alias listener
    Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production
    Start Date 16-SEP-2010 21:16:16
    Uptime 0 days 0 hr. 7 min. 24 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File D:\app\Subho\product\11.1.0\db_1\network\admin\lis tener.ora
    Listener Log File d:\app\subho\diag\tnslsnr\Subho-PC\listener\alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\EXTPROC1521ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Subho-PC)(PORT=1521)))
    The listener supports no services
    The command completed successfully
    LSNRCTL>


    PLease Help

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    sqlplus
    / as sysdba
    startup
    exit
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2010
    Posts
    64

    not working

    D:\app\Subho\product\11.1.0\db_1\BIN>sqlplus

    SQL*Plus: Release 11.1.0.6.0 - Production on Thu Sep 16 22:13:41 2010

    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    Enter user-name: / as sysdba
    Connected to an idle instance.

    SQL> start up
    SP2-0310: unable to open file "up.sql"
    SQL>

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    too bad for all concerned that COPY & PASTE are broken for you.

    not

    START UP

    but

    STARTUP
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •