Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

oracle10g [2016/12/16 10:15] (Version actuelle)
Ligne 1: Ligne 1:
 +Modifié par Kurca, le 17 Feb 2014\\
 +\\
 +
 +====== Oracle10g ======
 +
 +\\
 +\\
 +
 +====== Chapitre 1 : Migration from Oracle9i to Oracle10g ======
 +
 +=====  $TNS_ADMIN ​ =====
 +
 +As the service name is different from the host name (wasn'​t the case for ccora9i),\\
 +service name has to added to the file **tnsnames.ora** in $TNS_ADMIN directory.\\
 +**Attention**\\
 +1. on 2 places!\\
 +- locally for user sam\\
 +- on AFS for general user and user d0prod\\
 +2. for all our sam-stations;​ ccd0, ccsvli02, ccsvli16 (will be replaced by a new machine)\\
 +\\
 +**tnsnames.ora**\\
 +\\
 +...\\
 +CCDEV10G.IN2P3.FR =\\
 +(DESCRIPTION =\\
 +(ADDRESS_LIST =\\
 +(ADDRESS = (PROTOCOL = TCP)(HOST = ccdbcl01.in2p3.fr)(PORT = 1521))\\
 +(ADDRESS = (PROTOCOL = TCP)(HOST = ccdbcl02.in2p3.fr)(PORT = 1521))\\
 +(LOAD_BALANCE = yes)\\
 +)\\
 +(CONNECT_DATA =\\
 +(SERVICE_NAME = ccdev10g.in2p3.fr)\\
 +)\\
 +)\\
 +\\
 +CCORA10G.IN2P3.FR =\\
 +(DESCRIPTION =\\
 +(ADDRESS_LIST =\\
 +(ADDRESS = (PROTOCOL = TCP)(HOST = ccdbcl01.in2p3.fr)(PORT = 1521))\\
 +(ADDRESS = (PROTOCOL = TCP)(HOST = ccdbcl02.in2p3.fr)(PORT = 1521))\\
 +(LOAD_BALANCE = yes)\\
 +)\\
 +(CONNECT_DATA =\\
 +(SERVICE_NAME = ccora10g.in2p3.fr)\\
 +)\\
 +)
 +
  
  • oracle10g.txt
  • Dernière modification: 2016/12/16 10:15
  • (modification externe)