2. 安装Oracle 产品 时的注意事项：

 1. 由于安装Oracle DB 10.2
   会出现：ORA： 安全验证的问题。
   （1）需要把Configuartion  and Migration ---> Net Manager 中的Profile 设置成为： 没有NST的类型。。
   （2）需要把 NetWork 中的Admin中的三个文件进行改动：
                  listener.ora:
                   LISTENER1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1521))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1522))
    )
  )

<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
sqlnet.ora:
# sqlnet.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/sqlnet.ora
# Generated by Oracle configuration tools.

# 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= (TNSNAMES, EZCONNECT)

<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
   tnsnames.ora
 
# tnsnames.ora Network Configuration File: C:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

XE =
  (DESCRIPTION =
   
    (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

SSMDEV =
  (DESCRIPTION =
   
    (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ssmdev)
    )
  )

YINJUN_SSM=
  (DESCRIPTION =
   
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.222.48.157)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ssmdev)
    )
  )

SSMDEV.hklxdv49 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hklxdv49)(PORT = 1521))
    )
    (CONNECT_DATA =
     (SERVICE_NAMES=ssmtrain.oocl)
     (SID=ssmtrain)
    )
 )


LISTENER_XE =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1522))
  )

LISTENER_SSMDEV =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = jiaobe.corp.oocl.com)(PORT = 1522))
  )

ZHCS2QA3 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zhaoracdb01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ZHCS2QA3)
    )
  )

MCCI_ZHA_CSLAB02 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zha-cslab02)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

SSMDEV_HKGSUDV5 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkgsudv5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = SSMDEV)
    )
)

CS1_Q3=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ICSSQA3.oocl)
    )
  )

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

ORA9I.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = QINYH_2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora9i.qinyh_2)
    )
  )

ICSSQA1.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssqa1.oocl)
    )
  )

INST1_HTTP.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = QINYH_2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

PM_ICSS1.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linsa)(PORT = 7090))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pm_icss1.oocl)
    )
  )
QADB01.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = linsa)(PORT = 7090))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssprd.oocl)
    )
  )
OMCDDEV3 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = tmpcorp5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = OMCDDEV3)
    )
  ) 
 ORCL1_ZHADB01 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = zhadb01)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl1)
    )
  )
BCKWANPR.SHK_HOGE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SHK_HOGE.corp.oocl.com)(PORT = 1523))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bckwanpr.sedi)
    )
  )
CS2INT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = cs2dbint1)(PORT = 1521))
    (CONNECT_DATA =
      (SID = cs2int1)
    )
  ) 
ICSSUTF8.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 146.222.121.192)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssutf8)
    )
  )

ICSSFT.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssft.oocl)
    )
  )
ICSSFD.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssfd.oocl)
    )
  )
ICSSQA2.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssqa2.oocl)
    )
  )

EXTPROC_CONNECTION_DATA.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ICSSPRD.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssprd.oocl)
    )
  )

ICSSAD.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssad.oocl)
    )
  )

ICSSQA3.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssqa3.oocl)
    )
  )

ICSSINT2.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssint2.oocl)
    )
  )

ICSSINT3.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssint3.oocl)
    )
  )
ICSSprd3.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssprd.oocl)
    )
  )
ICSSDEVHKG.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv31)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssdevhkg.oocl)
    )
  )

ICSSQA4.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssqa4.oocl)
    )
  )

ICSSDEV3.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sjccsdb6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssdev3.oocl)
    )
  )

ICSSDEV1.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sjccsdb6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssdev1.oocl)
    )
  )

ICSSDEV2.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sjccsdb6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssdev2.oocl)
    )
  )
RACPOC.CORP.OOCL.COM  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45.oocl.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = racpoc.oocl)
    )
  )
RACPOC_L.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST=
      (LOAD_BALANCE=ON)
      (ADDRESS = (PROTOCOL = TCP)(HOST = hklxd40v.oocl.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hklxd41v.oocl.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hklxd42v.oocl.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hklxd43v.oocl.com)(PORT = 1521))
  )
    (CONNECT_DATA =
      (SERVICE_NAME = racpoc.oocl.com)
    )
  )
ICSSDEV4.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = sjccsdb6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = icssdev4.oocl)
    )
  )

HuJoe.CORP.OOCL.COM =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hujo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

 
RACPOC.CORP.OOCL.COM  =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv45.oocl.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = racpoc.oocl)
    )
  )
BCKWANPR =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SHK_HOGE.corp.oocl.com)(PORT = 1523))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bckwanpr.sedi)
    )
  )

CS2INT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cs2dbint1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cs2int1)
    )
  )

ICSSFD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HKHPDV45)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = icssfd)
    )
  )

CS2PRD.ZHAORACDB01 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = zhaoracdb01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cs2prd)
    )
  )

CS2INT1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cs2dbint1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cs2int1)
      (SERVER = DEDICATED)
    )
  )
 
cs2qa1.CORP.OOCL.COM =
        (DESCRIPTION=
                (ADDRESS=
                        (PROTOCOL=TCP)(HOST=cs2dbqa1)(PORT=1521)
                )
                (CONNECT_DATA=
                        (SID=cs2qa1)
                )
        ) 

b2bdev.cs2DevInt=

            (DESCRIPTION=

                        (ADDRESS=

                                    (PROTOCOL=TCP)(HOST=hklxdv16)(PORT=1521)

                        )

                        (CONNECT_DATA=

                                    (SID=cs2test)

                        )

            )

           
b2bqa2.cs2DevInt=

            (DESCRIPTION=

                        (ADDRESS=

                                    (PROTOCOL=TCP)(HOST=hklxdv16)(PORT=1521)

                        )

                        (CONNECT_DATA=

                                    (SID=cs2qa2)

                        )

            )
CS2DevInt1.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv19)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cs2int1.oocl)
    )
  )

CS2QA1.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv19)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cs2qa1)
    )
  )

CS2QA2.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hklxdv16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cs2qa2)
    )
  )

CS2QA3.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hklxdv16)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = cs2qa3)
    )
  )           
B2B.CORP.OOCL.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hkhpdv19)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = cs2int1)
    )
  )