Solved

Listener.ora Problem

Posted on 2001-08-09
3
1,718 Views
Last Modified: 2008-02-01
LISTENER.ORA Network Configuration File: c:\Oracle\network\admin\listener.ora
 Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.4)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = MyDB.world)
      (SID_NAME = MYDB)
      (ORACLE_HOME = c:\Oracle)
    )
  )

************************************************************************************************************

C:\WINDOWS>lsnrctl status

LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 09-AUG-2001 09:24:03

(c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.4)(PORT=1521))
)
TNS-01103: Protocol specific component of the address is incorrectly specified
 TNS-12541: TNS:no listener
  TNS-12560: TNS:protocol adapter error
   TNS-00511: No listener
    32-bit Windows Error: 61: Unknown error
0
Comment
Question by:rgcomm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Accepted Solution

by:
Bajwa earned 50 total points
ID: 6368275
Is listener running?

Run the following command and post any results

lsnrctl> start listener
0
 

Author Comment

by:rgcomm
ID: 6368329
Well, I feel stupid.

Thank you, that what my problem was. As you can tell, I am new to Oracle.
0
 
LVL 48

Expert Comment

by:schwertner
ID: 6368347
In 8 it is SID, in 8i use SERVICE_NAME


To establish connection to an instance use (with appropriate modifications):

REKS816.DRILA.US =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bigbluenew.drila.us)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = REKS816)
     )
  )
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question