Hello,
Firstly, don't be surprised, i don't speak english very well. Yesterday, everything worked. However, since i updated windows 8 to the 8.1 version, it doesn't work anymore. When i launch sqlplus and i try to access to my database, i get the error below:
D:\>sqlplus
SQL*Plus: Release 12.1.0.1.0 Production on Ven. DÚc. 13 11:20:24 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Entrez le nom utilisateur : SYSTEM@VINOUDB
Entrez le mot de passe :
ERROR:
ORA-12154: TNS : l'identificateur de connexion indiquÚ n'a pas pu Ûtre rÚsolu
When i look at the listener status, i get :
D:\>lsnrctl status
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 13-D╔C. -2013 11:
26:17
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(KEY=EXTPROC1521)))
TNS-01103: Le composant spÚcifique au protocole de l'adresse est incorrect
TNS-12533: TNS : paramÞtres ADDRESS illÚgaux
TNS-12560: TNS : erreur d'adaptateur de protocole
TNS-00503: ParamÞtres ADDRESS illÚgaux
Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS : aucun processus d'Úcoute
TNS-12560: TNS : erreur d'adaptateur de protocole
TNS-00511: Pas de processus d'Úcoute
64-bit Windows Error: 61: Unknown error
Now, i am going to put each configuration file:
| TNSNAMES.ORA |
|---|
# tnsnames.ora Network Configuration File: D:\app\vincent\product\12.1.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) BDVINOU = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BDVINOU) ) ) LISTENER_BDVINOU = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) |
| LISTENER.ORA |
|---|
# listener.ora Network Configuration File: D:\app\vincent\product\12.1.0\dbhome_1\network\admin\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\vincent\product\12.1.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\vincent\product\12.1.0\dbhome_1\bin\oraClr12.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) |
| SQLNET.ORA |
|---|
# sqlnet.ora Network Configuration File: D:\app\vincent\product\12.1.0\dbhome_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) |
Thank you for your help
cordially,
Vincent