Oracle环境变量、监听listener.ora、tnsnames.ora、sqlnet.ora配置

点击(此处)折叠或打开

1. NLS_DATE_FORMAT=YYYY-MM-DD HH24:mi:ss
   
2. NLS_LANG=AMERICAN_CHINA.ZHS16GBK
   
3. ORACLE10G=D:\Program files\app\oracle\product\10.2.0\db_1
   
4. ORACLE11G=D:\Program files\app\oracle\product\11.2.0.1\dbhome_1
   
5. ORACLE8I=D:\Program files\app\oracle\product\ora8i
   
6. ORACLE9I=D:\Program files\app\oracle\product\ora92
   
7. ORACLE_HOME=D:\Program files\app\oracle\product\11.2.0.1\dbhome_1
   
8. PATH=%ORACLE_HOME%\bin
   
9. TNS_ADMIN=%ORACLE_HOME%\NETWORK\ADMIN
   
10. 
    
11. 
    
12. 
    
13. 
    
14. ---------cmd下设置用户环境变量
    
15. SETX "NLS_DATE_FORMAT" "YYYY-MM-DD HH24:MI:SS"
    
16. SETX "NLS_LANG" "AMERICAN_CHINA.ZHS16GBK"
    
17. SETX "ORACLE10G" "D:\Program files\app\oracle\product\10.2.0\db_1"
    
18. SETX "ORACLE11G" "D:\Program files\app\oracle\product\11.2.0.1\dbhome_1"
    
19. SETX "ORACLE8I" "D:\Program files\app\oracle\product\ora8i"
    
20. SETX "ORACLE9I" "D:\Program files\app\oracle\product\ora92"
    
21. SETX "ORACLE_HOME" "D:\Program files\app\oracle\product\11.2.0.1\dbhome_1"
    
22. SETX "TNS_ADMIN" "%ORACLE_HOME%\NETWORK\ADMIN"
    
23. SETX "Path" "%ORACLE_HOME%\bin"
    
24. SETX "VBOX_MSI_INSTALL_PATH" "D:\Program Files\Oracle\VirtualBox"
    
25. 
    
26. 
    
27. 
    
28. alter session set nls_language='SIMPLIFIED CHINESE';
    
29. alter system set nls_language='AMERICAN' scope=spfile;
    
30. 
    
31. 
    
32. 
    
33. 
    
34. ------------------------------------ sqlnet.ora----------------------------------------------
    
35. ---------- windows
    
36. SQLNET.AUTHENTICATION_SERVICES= (NTS)
    
37. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
    
38. 
    
39. ---------- linux
    
40. SQLNET.AUTHENTICATION_SERVICES= (ALL)
    
41. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
    
42. 
    
43. 
    
44. 
    
45. --------------------------------------------------------------------- oracle
    
46. # .bash_profile
    
47. 
    
48. # Get the aliases and functions
    
49. if [ -f ~/.bashrc ]; then
    
50.     . ~/.bashrc
    
51. fi
    
52. 
    
53. # User specific environment and startup programs
    
54. 
    
55. export PATH=$PATH:/sbin/:$HOME/bin
    
56. 
    
57.   
    
58. # for oracle user
    
59. 
    
60. unset USERNAME
    
61. 
    
62. export GLOBAL_DB_UNIQUE_NAME=orclasm
    
63. export ORACLE_HOSTNAME=192.168.128.134
    
64. export ORACLE_UNQNAME=orclasm
    
65. 
    
66. export EDITOR=vi
    
67. export ORACLE_SID=orclasm
    
68. export ORACLE_BASE=/u01/app/oracle
    
69. export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
    
70. export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
    
71. export ORACLE_ALERT=$ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace
    
72. export PATH=$ORACLE_HOME/bin:$PATH
    
73. export TNS_ADMIN=$ORACLE_HOME/network/admin
    
74. export ORACLE_PATH=.:$ORACLE_BASE/dba_scripts/sql:$ORACLE_HOME/rdbms/admin
    
75. umask 022
    
76. 
    
77. #export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" 　　　SELECT userenv('LANGUAGE') db_NLS_LANG FROM DUAL;
    
78. export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
    
79. export SQLPATH=$ORACLE_HOME/sqlplus/admin
    
80. export NLS_DATE_FORMAT='YYYY-MM-DD HH24:mi:ss';
    
81. 
    
82. alias sqlplus='rlwrap sqlplus'
    
83. alias rman='rlwrap rman'
    
84. alias asmcmd='rlwrap asmcmd'
    
85. alias alert_log='tail -200f $ORACLE_ALERT/alert_$ORACLE_SID.log'
    
86. alias alert_xml='tail -200f $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/alert/log.xml'
    
87. alias alert_listener='tail -200f $ORACLE_BASE/diag/tnslsnr/rhel6/listener/trace/listener.log'
    
88. 
    
89. 
    
90.  
    
91. 
    
92. 
    
93. 
    
94. stty erase ^h
    
95. ORACLE_HOME=D:\Program files\app\oracle\product\11.2.0.1\dbhome_1
    
96. PATH=%ORACLE_HOME%\bin
    
97. TNS_ADMIN=%ORACLE_HOME%\NETWORK\ADMIN
    
98. ##NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
    
99. NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
    
100. #ORACLE_SCRIPT=%ORACLE_HOME%\RDBMS\ADMIN
     
101. SQLPATH=.;%ORACLE_BASE%\dba_scripts\sql;%ORACLE_HOME%\rdbms\admin
     
102. 
     
103. 
     
104. NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16CGB231280"
     
105. NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
     
106. NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
     
107. NLS_LANG=AMERICAN_AMERICA.UTF8
     
108. NLS_LANG=AMERICAN_AMERICA.AL32UTF8
     
109. NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
     
110. NLS_LANG=AMERICAN_CHINA.ZHS16GBK
     
111. 
     
112. 
     
113. NLS_DATE_FORMAT='YYYY-MM-DD HH24:mi:ss'
     
114. 
     
115. 
     
116. 
     
117. 
     
118. --------------------------------------------------------------------- grid
     
119. 
     
120. # .bash_profile
     
121. 
     
122. # Get the aliases and functions
     
123. if [ -f ~/.bashrc ]; then
     
124.         . ~/.bashrc
     
125. fi
     
126. 
     
127. # User specific environment and startup programs
     
128. 
     
129. export PATH=$PATH:$HOME/bin
     
130. 
     
131. 
     
132. # for grid user
     
133. export ORACLE_SID=+ASM
     
134. export ORACLE_BASE=/u01/app/grid
     
135. export ORACLE_HOME=/u01/app/grid/11.2.0
     
136. export LD_LIBRARY_PATH=$ORACLE_HOME/lib
     
137. export PATH=$ORACLE_HOME/bin:$PATH
     
138. umask 022
     
139. 
     
140. 
     
141. alias sqlplus='rlwrap sqlplus'
     
142. alias asmcmd='rlwrap asmcmd'
     
143. alias alert_log='tail -200f $ORACLE_BASE/diag/asm/+asm/$ORACLE_SID/trace/alert_$ORACLE_SID.log'
     
144. alias crsd_log='tail -200f $ORACLE_HOME/log/$HOSTNAME/crsd/crsd.log'
     
145. 
     
146. 
     
147. 
     
148. 在linux和unix上有时不知道该使用LD_LIBRARY_PATH还是LIBPATH，经过搜索和实际使用，实际的情况如下
     
149. 
     
150. OS Environment Variable                Name
     
151. Linux                        LD_LIBRARY_PATH
     
152. Solaris 32-bit ruby                LD_LIBRARY_PATH_32 or LD_LIBRARY_PATH
     
153. Solaris 64-bit ruby                LD_LIBRARY_PATH_64 or LD_LIBRARY_PATH
     
154. HP-UX PA-RISC 32-bit ruby            SHLIB_PATH
     
155. HP-UX PA-RISC 64-bit ruby            LD_LIBRARY_PATH
     
156. HP-UX IA64                    LD_LIBRARY_PATH
     
157. Mac OS X                    DYLD_LIBRARY_PATH
     
158. AIX                        LIBPATH
     
159. 
     
160. 
     
161. 
     
162. -----------------------------------------------------------------------------------------------
     
163. ------------------------------------listener.ora--------------------------------------------
     
164. --动态监听： alter system set LOCAL_LISTENER='(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.157)(PORT = 1521))';
     
165. -----------------------------------------------------------------------------------------------
     
166. # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
     
167. # Generated by Oracle configuration tools.
     
168. 
     
169. LISTENER =
     
170.   (DESCRIPTION_LIST =
     
171.     (DESCRIPTION =
     
172.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.129)(PORT = 1521))
     
173.     )
     
174.   )
     
175. SID_LIST_LISTENER =
     
176.   (SID_LIST =
     
177.    (SID_DESC =
     
178.       (SID_NAME = PLSExtProc)
     
179.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
     
180.       (PROGRAM = extproc)
     
181.     )
     
182.    (SID_DESC =
     
183.      (GLOBAL_DBNAME = orcl.lhr.com)
     
184.      (SID_NAME = orcl)
     
185.      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
     
186.    )
     
187.    (SID_DESC =
     
188.      (GLOBAL_DBNAME = rman.lhr.com)
     
189.      (SID_NAME = rman)
     
190.      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
     
191.    )
     
192.   )
     
193. 
     
194. LSNR2 =
     
195.   (DESCRIPTION_LIST =
     
196.     (DESCRIPTION =
     
197.       (ADDRESS_LIST =
     
198.         (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.129)(PORT = 1526))
     
199.       )
     
200.     )
     
201.   )
     
202. SID_LIST_LSNR2 =
     
203.   (SID_LIST =
     
204.     (SID_DESC =
     
205.       (SID_NAME = PLSExtProc)
     
206.       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
     
207.       (PROGRAM = extproc)
     
208.     )
     
209.   )
     
210. 
     
211. ADR_BASE_LISTENER = /u01/app/oracle
     
212. 
     
213. 
     
214. ------------windows 下
     
215. SID_LIST_LISTENER =
     
216.   (SID_LIST =
     
217.     (SID_DESC =
     
218.       (SID_NAME = CLRExtProc)
     
219.       (ORACLE_HOME = D:\app\oracle\product\11.2.0.1)
     
220.       (PROGRAM = extproc)
     
221.       (ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle\product\11.2.0.1\bin\oraclr11.dll")
     
222.     )
     
223.     (SID_DESC =
     
224.      (GLOBAL_DBNAME = orcl.lhr.com)
     
225.      (SID_NAME = orcl)
     
226.      (ORACLE_HOME = D:\app\oracle\product\11.2.0.1)
     
227.    )
     
228.   )
     
229. 
     
230. 
     
231. -----------------------/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
     
232. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
     
233. # Generated by Oracle configuration tools.
     
234. 
     
235. orcl =
     
236.   (DESCRIPTION =
     
237.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.133)(PORT = 1521))
     
238.     (CONNECT_DATA =
     
239.       (SERVER = DEDICATED)
     
240.       (SERVICE_NAME = orcl.lhr.com)
     
241.     )
     
242.   )
     
243. 
     
244. #### 动态监听非默认端口
     
245. LSNR_ORCL =
     
246.   (DESCRIPTION =
     
247.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.129)(PORT = 1526))
     
248.     (CONNECT_DATA =
     
249.       (SERVICE_NAME = orcl)
     
250.     )
     
251.   )
     
252. 
     
253. 
     
254. -------------------------------------------------------------------- rac
     
255. --- TAF BASIC方式
     
256. racdb_vip =
     
257.   (DESCRIPTION =
     
258.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521))
     
259.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.131)(PORT = 1521))
     
260.     (LOAD_BALANCE = on)
     
261.     (CONNECT_DATA =
     
262.       (SERVER = DEDICATED)
     
263.       (SERVICE_NAME = jmrac)
     
264.       (FAILOVER_MODE =
     
265.          (TYPE = SELECT)
     
266.          (METHOD = BASIC)
     
267.          (RETRIES = 180)
     
268.          (DELAY = 5)
     
269.       )
     
270.     )
     
271.   )
     
272. 
     
273. --- TAF preconnect方式
     
274. racdb_vip1 =
     
275.   (DESCRIPTION =
     
276.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.131)(PORT = 1521))
     
277.     (CONNECT_DATA =
     
278.       (SERVER = DEDICATED)
     
279.       (SERVICE_NAME = jmrac)
     
280.       (FAILOVER_MODE =
     
281.          (TYPE = SELECT)
     
282.          (METHOD = BASIC)
     
283.          (BACKUP = preconnect)
     
284.       )
     
285.     )
     
286.   )
     
287. 
     
288. racdb_vip2 =
     
289.   (DESCRIPTION =
     
290.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.132)(PORT = 1521))
     
291.     (CONNECT_DATA =
     
292.       (SERVER = DEDICATED)
     
293.       (SERVICE_NAME = jmrac)
     
294.       (FAILOVER_MODE =
     
295.          (TYPE = SELECT)
     
296.          (METHOD = BASIC)
     
297.          (BACKUP = preconnect)
     
298.       )
     
299.     )
     
300.   )