Discussion :

[pascalcovolo]

Après une installation de la version 9.5 de TOAD sur une version 8

Je n'arrive plus à me connecter en local à mon client qui est XE

Message d'erreur : ORA-28547 : échec de connexion au serveur; erreur probla de l'administration Oracle net

tnsname.ora :



XE =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = citrix.xxx.be)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = dedicated)
(SERVICE_NAME = XE)
)
)


EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC_FOR_XE)
)
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC_FOR_XE)
)
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


DEPAN_NEW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = NEWBDTECPRO1)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = depan)
)
)


ELEC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = NEWBDTECPRO1)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = ELEC)
)
)


sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES=(NTS)
LOG_DIRECTORY_CLIENT=C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\log
LOG_FILE_CLIENT=sqlnet.log
SQLNET.EXPIRE_TIME=0
TRACE_DIRECTORY_CLIENT=C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\trace
TRACE_FILE_CLIENT=sqlnet.trc
TRACE_FILELEN_CLIENT=100
TRACE_FILENO_CLIENT=3
TRACE_LEVEL_CLIENT=OFF
TRACE_TIMESTAMP_CLIENT=ON
TRACE_UNIQUE_CLIENT=ON
USE_DEDICATED_SERVER=ON


Home information :


SOFTWARE\ORACLE (Oracle Root)
ORACLE_HOME_NAME: DEFAULT_HOME
ORACLE_HOME: C:\orant
ORACLE_SID:
NLS_LANG: FRENCH_FRANCE.WE8ISO8859P1
SQLPATH: C:\orant\DBS
LOCAL:
C:\orant\Bin exists.
C:\orant\Bin is in PATH.
Client DLL: C:\orant\Bin\oci.dll
Client Version: 8.0.6.0.0
Home is valid.
SOFTWARE\ORACLE\HOME0
ORACLE_HOME_NAME: DEFAULT_HOME
ORACLE_HOME: C:\orant
ORACLE_SID:
NLS_LANG: FRENCH_FRANCE.WE8ISO8859P1
SQLPATH:
LOCAL:
C:\orant\Bin exists.
C:\orant\Bin is in PATH.
Client DLL: C:\orant\Bin\oci.dll
Client Version: 8.0.6.0.0
Home is valid.
SOFTWARE\ORACLE\KEY_XE
ORACLE_HOME_NAME: XE
ORACLE_HOME: C:\oraclexe\app\oracle\product\10.2.0\server
ORACLE_SID: XE
NLS_LANG: FRENCH_BELGIUM.WE8MSWIN1252
SQLPATH:
LOCAL:
C:\oraclexe\app\oracle\product\10.2.0\server\Bin exists.
C:\oraclexe\app\oracle\product\10.2.0\server\Bin is in PATH.
Client DLL: C:\oraclexe\app\oracle\product\10.2.0\server\Bin\oci.dll
Client Version: 10.2.0.1.0
Home is valid.


J'aimerais evidemment pouvoir me connecter à XE

Pour info çà fonctionnait avant l'installation de la version 9.5

Merci pour vos réponses

[pascalcovolo]

Voir : http://www.developpez.net/forums/d61...-me-connecter/