Re: Oracle 9i TNS Listener Problem

From: Serhiy Brytskyy <uranium_at_ukr.net>
Date: 16 Jan 2004 01:18:27 -0800
Message-ID: <eff0702.0401160118.2d10d520@posting.google.com>

vslabs_at_onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0312162301.46595f82_at_posting.google.com>...
> Serhiy Brytskyy <uranium_at_ukr.net> wrote i
>
> Always state operating system version and Oracle version up front.

Windows 2000 Professional SP 4, Oracle 9i

> How does your listener.ora file look like?

# LISTENER.ORA Network Configuration File: E:\oracle\ora92\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = boston)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\ora92)
      (PROGRAM = extproc)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = INVERTIX.SOFTSERVECOM.COM)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = INVERTIX)

    )
    (SID_DESC =

      (GLOBAL_DBNAME = IMA.SOFTSERVECOM.COM)
      (ORACLE_HOME = E:\oracle\ora92)
      (SID_NAME = IMA)

    )
  )

>
> When you make the local connection, do you use the same TNSalias as
> you do from the remote machine? How does the definition of that alias
> (from TNSNAMES) look like?
>
> Are you not perhaps using an Oracle Name Server? What does your
> SQLNET.ORA say ito of resolving connection names?
>
> Have you tested the TNSalias on the local machine using TNSPING? What
> is the result?
>
> Have you also tested it using SQL*Plus and not SQlNav4?

I can't even create local database, TNS listener is crashing during database creating. But as a client to remote server all is working well. Received on Fri Jan 16 2004 - 03:18:27 CST