Modifié par Kurca, le 17 Feb 2014

Oracle10g



Chapitre 1 : Migration from Oracle9i to Oracle10g

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)