oracle的数据库建立与连接

先找到安装文件中的ADMIN文件夹，如我的E:\oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN中有个tnsnames.ora ，该文件就是配置数据库了。

初始：XE =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = WIN7U-20140628E)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = XE)

    )

  )

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

ORACLR_CONNECTION_DATA = 

  (DESCRIPTION = 

    (ADDRESS_LIST = 

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) 

    ) 

    (CONNECT_DATA = 

      (SID = CLRExtProc) 

      (PRESENTATION = RO) 

    ) 

  ) 

可这样建立：BMS_T =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.13.6.99)(PORT = 1522))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = bms)

    )

  )

BMS_ZS =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.99.115)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = bms)

    )

  )