Re: Major ORA-12203 Grief

From: Mike <gronlund_at_gte.net>
Date: Sat, 20 Jan 2001 20:53:09 GMT
Message-ID: <VUma6.2642$ip.235823@dfiatx1-snr1.gtei.net>

Martin Haltmayer wrote in message <3A68748A.B6139244_at_0800-einwahl.de>...

>Can you please post
>
>- tnsnames.ora of the client

#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.
#Attention: Do not modify this file yourself. #If you do, your SQL*Net Easy Configuration may not function properly.

Example1.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = Production1)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = SID1)
    )
  )
Example2.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = spx.world)

          (PROTOCOL = SPX)

          (Service = Server_lsnr)

        )    )

    (CONNECT_DATA = (SID = ORCL)
    )
  )
Example3.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = nmp.world)

          (PROTOCOL = NMP)

          (Server = FinanceServer1)

          (Pipe = ORAPIPE)

        )

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

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = 127.0.0.1)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
Beq-Local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = beq.world)

          (PROTOCOL = BEQ)

          (PROGRAM = oracle73)

          (ARGV0 = oracle73ORCL)

          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')

        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
sample.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = testenv)

          (Port = 1521)

        )
        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = testenv)

          (Port = 1526)

        )

    )
    (CONNECT_DATA = (SID = sample)
    )
  )

>- listener.ora of the server
>

# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora # Generated by Oracle configuration tools.

SAMPLE =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = testenv)(PORT = 1521))
      )

    )
  )

SID_LIST_SAMPLE =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = sample)
      (ORACLE_HOME = D:\Oracle\Ora81)
      (SID_NAME = sample)

    )
  )

>- What does "ping TEST" (your hostname from the logfile) from the client  yield?
>

C:\>ping testenv

Pinging testenv [x.x.x.x] with 32 bytes of data:

Reply from x.x.x.x: bytes=32 time<10ms TTL=128
Reply from x.x.x.x: bytes=32 time<10ms TTL=128
Reply from x.x.x.x: bytes=32 time<10ms TTL=128
Reply from x.x.x.x: bytes=32 time<10ms TTL=128

C:\>tnsping sample

TNS Ping Utility for 32-bit Windows: Version 2.3.3.0.0 - Production on 20-JAN-01
 12:50:46

Copyright (c) Oracle Corporation 1995. All rights reserved.

Attempting to contact
(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=testenv) (Port=1521))
OK (1420 msec)

>- What does "ping TEST" from the *server* yield? >

D:\>ping test

Pinging test [x.x.x.x] with 32 bytes of data:

Reply from x.x.x.x: bytes=32 time<10ms TTL=128
Reply from x.x.x.x: bytes=32 time<10ms TTL=128
Reply from x.x.x.x: bytes=32 time<10ms TTL=128
Reply from x.x.x.x: bytes=32 time<10ms TTL=128

D:\>tnsping sample

TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on 20-JAN-20
01 12:44:58

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=testenv)(PORT=1521)) OK (830 ms

ec)

>Martin

Had to pull out the IPs for security reasons.

Thanks For The Help!

Mike Received on Sat Jan 20 2001 - 14:53:09 CST