Re: Ora 10.2.0.1, Error ORA-12514

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sun, 02 Mar 2008 22:07:18 -0600
Message-ID: <RNKyj.5119$pl4.4334@newssvr22.news.prodigy.net>

Ana C. Dent wrote:

> PCarrilho <carrilho.paulo_at_gmail.com> wrote in news:ecc1f4ad-3199-46f2-8d4f-
> 016b7051f9f5_at_i12g2000prf.googlegroups.com:
> 

>> Hi,
>>
>> perhaps the error which I'm issuing is well known by you. I'm new
>> about DB Administration.
>>
>> I'm trying to install an Oracle Database version 10.2.0.1, Standard
>> Edition, on a XP SP2 Professional OS based machine.
>>
>> The installation process was successful, however when I try to connect
>> to the Database I get this error:
>>
>> (SQLPlus)
>>
>> SQL> CONNECT SYS/SADMIN_at_siebel AS SYSDBA
>> ERROR:
>> ORA-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>>
>> I've already "googled" it, with no satisfactory conclusion.
>>
>> These are my Database configuration files:
>>
>> ############
>> listener.ora:
>> ############
>>
>> # listener.ora Network Configuration File: D:\oracle\product
>> \10.2.0\db_1\network\admin\listener.ora
>> # Generated by Oracle configuration tools.
>>
>> SID_LIST_LISTENER =
>> (SID_LIST =
>> (SID_DESC =
>> (SID_NAME = PLSExtProc)
>> (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
>> (PROGRAM = extproc)
>> )
>> )
>>
>> LISTENER =
>> (DESCRIPTION_LIST =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>> )
>> )
>>
>>
>> ############
>> tnsnames.ora:
>> ############
>>
>> # tnsnames.ora Network Configuration File: D:\oracle\product
>> \10.2.0\db_1\network\admin\tnsnames.ora
>> # Generated by Oracle configuration tools.
>>
>> SIEBEL =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = siebel)
>> )
>> )
>>
>> EXTPROC_CONNECTION_DATA =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
>> )
>> (CONNECT_DATA =
>> (SID = PLSExtProc)
>> (PRESENTATION = RO)
>> )
>> )
>>
>>
>> ############
>> sqlnet.ora:
>> ############
>>
>> # sqlnet.ora Network Configuration File: D:\oracle\product
>> \10.2.0\db_1\network\admin\sqlnet.ora
>> # Generated by Oracle configuration tools.
>>
>> # This file is actually generated by netca. But if customers choose
>> to
>> # install "Software Only", this file wont exist and without the
>> native
>> # authentication, they will not be able to connect to the database on
>> NT.
>>
>> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>>
>> NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
>>
>> ########################################################################
>>
>>
>> The listener.log:
>>
>> ...
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>> 02-MAR-2008 22:38:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)
>> (USER=))(SERVICE_NAME=siebel)) * (ADDRESS=(PROTOCOL=tcp)
>> (HOST=127.0.0.1)(PORT=2497)) * establish * siebel * 12514
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>> 02-MAR-2008 22:38:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)
>> (USER=))(SERVICE_NAME=siebel)) * (ADDRESS=(PROTOCOL=tcp)
>> (HOST=127.0.0.1)(PORT=2499)) * establish * siebel * 12514
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>> 02-MAR-2008 22:38:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)
>> (USER=))(SERVICE_NAME=siebel)) * (ADDRESS=(PROTOCOL=tcp)
>> (HOST=127.0.0.1)(PORT=2500)) * establish * siebel * 12514
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>>
>>
>> which is always increasing with same messages.
>>
>>
>> Might you help me, please? What did I make wrong?
>>
>> The database should is named as SIEBEL.
>>
>> PS: I've 4 services running: OracleServiceSIEBEL,
>> OracleOraDb10g_home1TNSListener, OracleOraDb10g_home1iSQL*Plus,
>> OracleDBConsolesiebel
>>
>>

> 
> I see two different areas which have me concerned.
> 1) (HOST = localhost)
> I have always used a host name which resolves to a valid IP# or a valid IP#  
> 

In some environments, the only host I want accessing a particular listener is localhost (don't want other servers using this box as a gateway to another external source for example). The listeners from 9.2.0.6, 9.2.0.8, 10.2.0.2, 10.2.0.3 on UNIX seem to change this functionality depending on the day (or so it seems). If the only applications accessing this are on the localhost - then this is valid. If you need to access it from outside - it may or may not work. Received on Sun Mar 02 2008 - 22:07:18 CST