cmd命令oracle账号创建oracle配置tnsnames

oracle配置tnsnames

 

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora 

# Generated by Oracle configuration tools. 

 

MYSCOTT = 

  (DESCRIPTION = 

    (ADDRESS = (PROTOCOL = TCP)(HOST = ibm-PC)(PORT = 1521)) 

    (CONNECT_DATA = 

      (SERVER = DEDICATED) 

      (SERVICE_NAME = myscott) 

    ) 

  ) 

 

EXTPROC_CONNECTION_DATA oracle账号= 

  (DESCRIPTION = 

    (ADDRESS_LIST = 

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 

    ) 

    (CONNECT_DATA =  www.2cto.com

      (SID = PLSExtProc) 

      (PRESENTATION = RO) 

    ) 

  ) 

 

chem =//此处为plsql中的引用sid 

  (DESCRIPTION = 

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

    (CONNECT_DATA = 

      (SERVER = DEDICATED) 

      (SERVICE_NAME = myscott)//myscott是系统的sid,即真正的sid 

    ) 

  ) 

 

 

 

 

作者 409304740

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。