修改Oracle的配置文件

点击(此处)折叠或打开

1. --修改/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora,将localhost都改为你的主机名
   
2. LISTENER_TESTDB11 =
   
3.   (ADDRESS = (PROTOCOL = TCP)(HOST = S1011.cuug.net)(PORT = 1521))
   
4. 
   
5. 
   
6. TESTDB11 =
   
7.   (DESCRIPTION =
   
8.     (ADDRESS = (PROTOCOL = TCP)(HOST = S1011.cuug.net)(PORT = 1521))
   
9.     (CONNECT_DATA =
   
10.       (SERVER = DEDICATED)
    
11.       (SERVICE_NAME = TestDB11.cuug.net)
    
12.     )
    
13.   )
    
14.   
    
15. --修改/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora, 将localhost改为你的主机名
    
16. LISTENER =
    
17.   (DESCRIPTION_LIST =
    
18.     (DESCRIPTION =
    
19.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    
20.       (ADDRESS = (PROTOCOL = TCP)(HOST = S1011.cuug.net)(PORT = 1521))
    
21.     )
    
22.   )
    
23. 
    
24. ADR_BASE_LISTENER = /u01/app/oracle

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1073478/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1073478/