ORACLE 1

net manage服务命名：LISTENER_YIPARTS 

第一步
D:\oracle\11g\app\product\11.2.0\dbhome_1\NETWORK\ADMIN

tnsnames.ora

LISTENER_YIPARTS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lserver)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = YIPARTS)
    )
  )

sqlplus /nolog

connect / as sysdba

startup

第二步

YIPARTS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lserver)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = YIPARTS)
    )
  )