oracle安装配置

文件示例：

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)  
  
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)

tnsnames.oRA

LISTENER_ORCL =  
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.116)(PORT = 1521))  
ORCL =  
  (DESCRIPTION =  
    (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.116)(PORT = 1521)) 
    )  
    (CONNECT_DATA =  
      (SID = ORCL)  
    )  
  )

LISTENER.ORA

SID_LIST_LISTENER =  
  (SID_LIST =  
    (SID_DESC =  
      (SID_NAME = PLSExtProc)  
      (ORACLE_HOME = G:\app\mamp\product\11.2.0\dbhome_1)  
      (PROGRAM = extproc)  
      (ENVS = "EXTPROC_DLLS=ONLY:G:\app\mamp\product\11.2.0\dbhome_1\BIN\oraclr11.dll")  
    )  
    (SID_DESC =  
      (GLOBAL_DBNAME = orcl)  
      (ORACLE_HOME = G:\app\mamp\product\11.2.0\dbhome_1)  
      (SID_NAME = orcl)  
      (ENVS = "EXTPROC_DLLS=ONLY:G:\app\mamp\product\11.2.0\dbhome_1\BIN\oraclr11.dll")  
    ) 
  )  
  
LISTENER =  
  (DESCRIPTION =  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))  
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.116)(PORT = 1521))  
  )