Oracle Database Discussions

Hello,

I have been working some time in this and haven't succeded to solve it yet. Maybe more experienced users could help me !?

Well, here is my environment :
- Oracle 11GR2
- Linux CentOS release 5.5

I was stuck in a listener configuration problem. Lot's of ORA-12514 errors.
I could not understand it as i thought my configuration was quite simple and right.

While doing some tests, i noticed that whatever i put in the listener.ora, lsnr doesn't consider it.
It always try to listen on port 1521 whatever if i change the port.
Even when i add a new listener, it doesn't consider it.

Here is the the listener.ora :

-------------------------------------------------------------------------------------------

LS_2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orabox)(PORT = 3251))
)

ADR_BASE_LS_2 = /data/app/oracle

SID_LIST_LS_2 =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /data/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)

)

------------------------------------------------------------------------------------------------------
Here is the start output :


[oracle@orabox admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-OCT. -2012 08:55:47

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Lancement de /data/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: Veuillez patienter...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Le fichier de paramètres système est /data/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Messages de journalisation écrits dans /data/app/oracle/diag/tnslsnr/orabox/listener/alert/log.xml
Ecoute sur : (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orabox)(PORT=1521)))

Connexion à (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUT du PROCESSUS D'ECOUTE
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Date de départ 12-OCT. -2012 08:55:47
Durée d'activité 0 jours 0 heures 0 min. 20 sec
Niveau de trace off
Sécurité ON: Local OS Authentication
SNMP OFF
Fichier de paramètres du processus d'écoute /data/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Fichier journal du processus d'écoute /data/app/oracle/diag/tnslsnr/orabox/listener/alert/log.xml
Récapitulatif d'écoute des points d'extrémité...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orabox)(PORT=1521)))
Le processus d'écoute ne prend en charge aucun service
La commande a réussi

------------------------------------------------------------------------------------------------------

It's still using port 1521 and doesn't consider my new conf :

[oracle@orabox admin]$ netstat -nap | grep 1521
(Tous les processus ne peuvent être identifiés, les infos sur les processus
non possédés ne seront pas affichées, vous devez être root pour les voir toutes.)
tcp 0 0 10.10.27.12:26527 10.10.27.12:1521 ESTABLISHED 4619/ora_pmon_orcl
tcp 0 0 :::1521 :::* LISTEN 7623/tnslsnr
tcp 0 0 ::ffff:10.10.27.12:1521 ::ffff:10.10.27.12:26527 ESTABLISHED 7623/tnslsnr


In the log file,those lines could be usefull :

TNS-12514: TNS : le processus d'écoute ne connaît pas actuellement le service indiqué dans le descripteur de connexion
Thu Oct 11 10:28:15 2012
11-OCT. -2012 10:27:55 * service_register * orcl * 0
Thu Oct 11 10:28:35 2012
11-OCT. -2012 10:28:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.27.12)(PORT=19433)) * establish * orcl * 0
Thu Oct 11 10:28:55 2012
11-OCT. -2012 10:28:55 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.27.12)(PORT=19436)) * establish * orcl * 0
11-OCT. -2012 10:28:55 * service_update * orcl * 0
11-OCT. -2012 10:28:55 * service_update * orcl * 0
11-OCT. -2012 10:28:55 * service_update * orcl * 0




If someone has an idea of where is my error, i'd b grateful !!!

Guillaume