Re: Probleme de connexion à Oracle |
Sujet: Re: Probleme de connexion à Oracle par marco26 sur 10/3/2006 9:33:13 Vérifie les 3 fichiers de configuration Oracle tnsnames.ora sqlnet.ora listener.ora ils sont présents dans le répertoire <ORA_HOME>\network\ADMIN Exemple, mes fichiers de conf (2 bases actives) Listener.ora STARTUP_WAIT_TIME_LISTENER = 0 # Listener_header CONNECT_TIMEOUT_LISTENER = 10 # Listener_header TRACE_LEVEL_LISTENER = OFF # Listener_header LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = TCP.world)(PROTOCOL = TCP)(HOST = developpement)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = NMP)(SERVER = DEVELOPPEMENT)(PIPE = ORAPIPE)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\ora817) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = test) (ORACLE_HOME = E:\ora817) (SID_NAME = test) ) (SID_DESC = (GLOBAL_DBNAME = MECOPRO.world) (ORACLE_HOME = E:\ora817) (SID_NAME = MECOPRO) ) ) tnsnames.ora MECOPRO.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DEVELOPPEMENT)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = MECOPRO) ) ) TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = developpement)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = test) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = developpement)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = test) (PRESENTATION = http://admin) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) sqlnet.ora SQLNET.AUTHENTICATION_SERVICES= (NTS) AUTOMATIC_IPC = OFF TRACE_LEVEL_CLIENT = OFF SQLNET.EXPIRE_TIME = 0 NAMES.DEFAULT_DOMAIN = world NAME.DEFAULT_ZONE = world NAMES.DIRECTORY_PATH = (TNSNAMES) Si tu n'y arrives pas, contactes moi en privé, j'essaierai de t'aider Bons dev |