Posted by Mladen Gogala on 02/07/07 04:56

On Tue, 16 Jan 2007 00:56:20 -0800, danish wrote:

> ocilogon(): ORA-12514: TNS:listener does not currently know of service
> requested in connect descriptor in /home/danish/htdocs/test.php

That is a TNS configuration error. You need to properly configure the
database entry in the tnsnames.ora. Essentially, TNS entry has 3 parts:
1) The hostname of the database server
2) Port at which Oracle listener is listening, usually 1521.
3) Service name of the service to which to connect.
Here is an example:
MEDO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = medo.noip.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = brundo.noip.com)
)
)

Service names are defined by the SERVICE_NAMES Oracle parameter for RDBMS
version 9 and 10 or by MTS_SERVICE parameter for RDBMS 8i. An alternative
method is to supply a SID instead of the service name, but that is
deprecated.

--
http://www.mladen-gogala.com

[Back to original message]