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

    Unanswered: login problem to oracle 11g

    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>


    i went to sql plus but it is showing
    SQL*Plus: Release 11.1.0.6.0 - Production on Sun Nov 28 02:17:02 2010

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

    Enter user-name: / as sysdba
    ERROR:
    ORA-12560: TNSrotocol adapter error

    PLease Help

  2. #2
    Join Date
    Jan 2010
    Posts
    64
    its sorted now .. thanks!

Posting Permissions

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