Pb de configuration Oracle Net et connection a BDD distant via commande dos "sqlplus"

bjour
j'ai un probleme de connection a la base de donner oracle a distance.
j'ai deux machine , une dans laquel est installé oracle complet et la deuxieme dans la quel est installé oracle client
et j'ai pu connecté avec la commande sous dos "sqlplus system/manager@10.17.1.223/BDD. vers la premiere machine a traver la machine cliente
listener :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = sweet-2424d1783)(PORT = 1521))
      )
    )
  )
 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\ora92)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = BDD)
      (ORACLE_HOME = C:\oracle\ora92)
      (SID_NAME = BDD)
    )
  )

sqlnet.ora :

Code:

1
2
3
4
5
6
7
8
9
10
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
 
SQLNET.AUTHENTICATION_SERVICES= (NTS)
 
# 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.
 
NAMES.DIRECTORY_PATH= (HOSTNAME)

tnsnames.ora:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
 
INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sweet-2424d1783)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
 
BDD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sweet-2424d1783)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = BDD)
    )
  )

la question????????????????!!!!!!!!!!!!!

configuration du client

bjour ,la question c de comment configurer le client pour qu'il puisse se connecter a la BDD a distance et Merci d'avance

Bonjour,
il faut modifier dans le fichier tnsnames.ora de ton client comme suit:

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
 
# TNSNAMES.ORA Network Configuration File: E:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
 
Alias_ServiceName =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Adresse_IP_Serveur_Oracle)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = Alias_ServiceName
    )
  )

sinon tu peux passer par Net Manager ..
Bon courage !

configuration Oracle Net pour connection a BDD distant via commande dos "sqlplus"

merci thanks c resolu
sa marche tres bien :D