Re: oracle 9i help?

From: Jerry Dubuke <jdubuke_at_not.gpdservices.com>
Date: Tue, 25 Jan 2005 08:29:54 -0500
Message-ID: <41f66dea$0$12604$afc38c87@>

> You have two issues here:
> - you get an error 12514 (which is a network error, as
> all 125xx errors), you provide the exact error message.
> - you get an error, that the error message for error #12514
> cannot be found.
> This indicates an installation/configuration problem.
>
> Please reveal how you connect from the 806 client to the
> two other servers, and where you found the tnsnames.ora
> file.
> Please check the registry for an entry, called tns_admin.
> If there is one, provide it's value.
>
> For now, there are simply too many variables.
>
> --
> Regards,
> Frank van Bortel

Hi Frank,
Please bear with me - I know enough to be dangerous, but that is it. The 8.06 was put in place before I got here 3 years ago. I looked in one of the working 8.06 servers, and found SQLNET.ora in d:\orant\net80\admin. Could this be shedding some light on how I am connecting?
*-*-*-*-*-*-*-*-*-*-* start of file *-*-*-*-*-*-*-*-*-* names.directory_path = (TNSNAMES, HOSTNAME) names.default_domain = world
name.default_zone = world
automatic_ipc = off
*-*-*-*-*-*-*-*-*-*-* end of file *-*-*-*-*-*-*-*-*-* I have no registry entry on the client called tns_admin, nor do I have an environment varialbe set at the client for that. TNSNames.ora - I found it in the client at c:\ORANT\net80\admin, and the contents appear to be the original sample. Here it is in all its ugliness: *-*-*-*-*-*-*-*-*-*-* start of file *-*-*-*-*-*-*-*-*-* Beq-local.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = BEQ)
          (PROGRAM = oracle80)
          (ARGV0 = oracle80ORCL)
          (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
        )

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

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )

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

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = Production1)
          (Port = 1521)
        )

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

        (ADDRESS =
          (PROTOCOL = SPX)
          (Service = Server_lsnr)
        )

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

        (ADDRESS =
          (PROTOCOL = NMP)
          (Server = FinanceServer1)
          (Pipe = ORAPIPE)
        )

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

      (ADDRESS=
          (PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
      (ADDRESS=
          (PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
      (CONNECT_DATA=(SID=ORCL))
         (SOURCE_ROUTE=yes)

  )
extproc_connection_data.world =
  (DESCRIPTION =
    (ADDRESS =

        (PROTOCOL = IPC)
        (KEY = EXTPROC0)

    )
    (CONNECT_DATA = (SID = extproc)
    )
  )
*-*-*-*-*-*-*-*-*-*-* end of file *-*-*-*-*-*-*-*-*-* As usual, thank you for any help you can provide! Jerry Received on Tue Jan 25 2005 - 07:29:54 CST