TNS-01150 - THE ADDRESS OF THE SPECIFIED LISTENER IS INCORRECT.

From: larry ndango <larryndango_at_netscape.net>
Date: 14 May 00 08:20:26 PDT
Message-Id: <10497.105596@fatcity.com>

HAVE TWO DATABSES ON MY NT MACHINE NAMED CLE AND ORCL RESPECTIVELY BUT WHEN I TRY TO START LISTERNER SO THAT I CAN CHECT THE STATUS , I GET THIS ERROR TNS-01150 THE ADDRES OF THE SPECIFIED LISTENER = ISINCORRECT.
NL-003N00-SYNTAX ERROR IN NV STRING HELP WILL BE APPRECIATED.
THESE ARE MY ENTRIES
LISTENER =3D
(ADDRESS_LIST =3D

        (ADDRESS=3D


          (PROTOCOL=3D IPC)

          (KEY=3D oracle.world)

        )
        (ADDRESS=3D


          (PROTOCOL=3D IPC)

          (KEY=3D ORCL)

        )
        (ADDRESS=3D


          (COMMUNITY=3D NMP.world)

          (PROTOCOL=3D NMP)

          (SERVER=3D NTWORK)

          (PIPE=3D ORAPIPE)

        )
 **        LISTENER2 =3D


          (ADDRESS=3D

          (PROTOCOL=3D IPC)

          (KEY=3D CLE)

      )

)

STARTUP_WAIT_TIME_LISTENER =3D 0
CONNECT_TIMEOUT_LISTENER =3D 10
TRACE_LEVEL_LISTENER =3D 0
SID_LIST_LISTENER =3D
(SID_LIST =3D
(SID_DESC =3D

      (GLOBAL_DBNAME =3D NTWORK)
      (SID_NAME =3D ORCL)

)

SID_LIST_LISTENER2 =3D (SID_LIST =3D (SID_DESC =3D (GLOBAL_DBNAME =3D NTWORK) (SID_NAME =3D CLE) )

(SID_DESC =3D

      (SID_NAME =3D extproc)
      (PROGRAM=3Dextproc)

)
)
PASSWORDS_LISTENER =3D (oracle)

Tnsnames file:

Beq-local.world =3D
(DESCRIPTION =3D
(ADDRESS_LIST =3D

        (ADDRESS =3D


          (PROTOCOL =3D BEQ)

          (PROGRAM =3D oracle80)

          (ARGV0 =3D oracle80ORCL)

          (ARGS =3D '(DESCRIPTION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3Db=

eq)))')
        )

    )
    (CONNECT_DATA =3D (SID =3D ORCL)
    )
  )
Tcp-loopback.world =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D

        (ADDRESS =3D


          (PROTOCOL =3D TCP)

          (Host =3D 127.0.0.1)

          (Port =3D 1521)

        )

    )
    (CONNECT_DATA =3D (SID =3D ORCL)
    )
  )

*Cle.world =3D
(DESCRIPTION =3D
(ADDRESS_LIST =3D

        (ADDRESS =3D


          (PROTOCOL =3D TCP)

          (Host =3D 127.0.0.1)

          (Port =3D 1521)

        )

    )
    (CONNECT_DATA =3D (SID =3D CLE)
    )
  )

TcpExample.world =3D
(DESCRIPTION =3D
(ADDRESS_LIST =3D

        (ADDRESS =3D


          (PROTOCOL =3D TCP)

          (Host =3D Production1)

          (Port =3D 1521)

        )

    )
    (CONNECT_DATA =3D (SID =3D SID1)
    )
  )
SpxExample.world =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D

        (ADDRESS =3D


          (PROTOCOL =3D SPX)

          (Service =3D Server_lsnr)

        )

    )
    (CONNECT_DATA =3D (SID =3D ORCL)
    )
  )
NmpExample.world =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D

        (ADDRESS =3D


          (PROTOCOL =3D NMP)

          (Server =3D FinanceServer1)

          (Pipe =3D ORAPIPE)

        )

    )
    (CONNECT_DATA =3D (SID =3D ORCL)
    )
  )
CMExample.world =3D
  (DESCRIPTION=3D(address_list=3D

      (ADDRESS=3D


          (PROTOCOL=3Dtcp)(PORT=3D1610)(HOST=3DCM_SERVER))

      (ADDRESS=3D


          (PROTOCOL=3Dtcp)(PORT=3D1521)(HOST=3DLSNR_SERVER)))

      (CONNECT_DATA=3D(SID=3DORCL))
         (SOURCE_ROUTE=3Dyes)

  )
extproc_connection_data.world =3D
  (DESCRIPTION =3D
    (ADDRESS =3D

        (PROTOCOL =3D IPC)
        (KEY =3D ORCL)

    )
    (CONNECT_DATA =3D (SID =3D extproc)
    )
  )

Get your own FREE, personal Netscape WebMail account today at http://webm= ail.netscape.com.

From: Alex Hillman <alex_hillman_at_physia.com> Date: Sun, 14 May 2000 13:37:15 -0400
Subject: Primary key type selection

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFBDCB.0B34DFA0
Content-Type: text/plain;

charset="iso-8859-1"

Is there any advantages and disadvantages (performance? , ...) between NUMBER and VARCHAR2 for primary key column?

Alex Hillman

------_=_NextPart_001_01BFBDCB.0B34DFA0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">

<TITLE>Primary key type selection</TITLE>
</HEAD>
<BODY>

Is there any advantages and = disadvantages (performance? , ...) between NUMBER and VARCHAR2 for = primary key column?

Alex Hillman Received on Sun May 14 2000 - 10:20:26 CDT