Re: Oracle TNS Listner Error

In article <32F7A8E2.2778_at_netspace.net.au>,   claudio_at_netspace.net.au wrote:
>
> I have just installed Oracle 7.3.2 on a Sun system running Solaris 2.5.
>
> When trying to connect to Oracle using SQL*Net from another Sun box,
> the TNS Listener gives the following error:
>
> "ORA-12538. TNS: No such protocol adapter"
>
> What does this error mean? The manuals are not terribly helpful.
> What protocol adapter is it talking about (TCP??)?
> How do I find out if the protocol adapter has been installed?

Not only do you need to install SQL*Net, you also need to install an adapter for any communications protocol you want it to run on top of, obviously TCP/IP. The architecture works something like: - TCP/IP (or IPX/SPX, etc. if you were to use SQL*Net on PCs) does the "dirty job transport - SQL*Net creates a "Transparent Network Substrate" which hides all those details and provides a uniform way to access databases in any server with any protocol - The protocol adapters glues the two of them together, coming in as many flavours as protocols are supported

That translates to your putting the installation disk back, running the installer, selecting to install something like "SQL*Net TCP/IP adapter 2.x.x.x" and make sure you ended up with that line and "SQL*Net 2.x.x.x" BOTH in your server database box and the client.

You will also need to configure the listener.ora and make the listener work in the server side, and configure the tnsnames.ora in the client side. If you´ve no clue about them, you may drop an email.

Good luck!
  Bruno.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet