linux 配置tnsnames.ora,tnsnames.ora配置注意事项

tnsnames.ora配置注意事项

tnsnames.ora语法信息，一般会在sample目录下是有

= [ (DESCRIPTION_LIST = # Optional depending on whether u have

# one or more descriptions

# If there is just one description, unnecessary ]

(DESCRIPTION=

[ (SDU=2048) ] # Optional, defaults to 2048

# Can take values between 512 and 32K

[ (ADDRESS_LIST= # Optional depending on whether u have

# one or more addresses

# If there is just one address, unnecessary ]

(ADDRESS=

[ (COMMUNITY=) ]

(PROTOCOL=tcp)

(HOST=)

(PORT=)

)

[ (ADDRESS=

(PROTOCOL=ipc)

(KEY=)

)

]

[ (ADDRESS=

[ (COMMUNITY=) ]

(PROTOCOL=decnet)

(NODE=)

(OBJECT=)

)

]

… # More addresses

[ ) ] # Optional depending on whether ADDRESS_LIST is used or not

[ (CONNECT_DATA=

(SID=)

[ (GLOBAL_NAME=) ]

)

]

[ (SOURCE_ROUTE=yes) ]

)

(DESCRIPTION=

[ (SDU=2048) ] # Optional, defaults to 2048

# Can take values between 512 and 32K

[ (ADDRESS_LIST= ] # Optional depending on whether u have more

# than one address or not

# If there is just one address, unnecessary

(ADDRESS

[ (COMMUNITY=) ]

(PROTOCOL=tcp)

(HOST=)

(PORT=)

)

[ (ADDRESS=

(PROTOCOL=ipc)

(KEY=)

)

]

… # More addresses

[ ) ] # Optional depending on whether ADDRESS_LIST

# is being used

[ (CONNECT_DATA=

(SID=)

[ (GLOBAL_NAME=) ]

)

]

[ (SOURCE_ROUTE=yes) ]

)

[ (CONNECT_DATA=

(SID=)

[ (GLOBAL_NAME=) ]

)

]

… # More descriptions

[ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not

–tnsnames.ora文件配过程中要注意换行后需要空格或者tab键空格

–一般配置service_name

–括号缩进方式，都需要注意

[oracle@trsenomr admin]$ vi tnsnames.ora

test1=

(DESCRIPTION=

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

(CONNECT_DATA=

(sid=trsenxi)

(instance_name=trdseni)

(SERVICE_NAME=tsrseni)))

–tnsping验证address的信息，不会验证connect_data信息正确与否

[oracle@trsenomr admin]$ tnsping test1

TNS Ping Utility for Linux: Version 11.2.0.3.0 – Production on 06-JUL-2015 08:17:03

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.110)(PORT=1521)) (CONNECT_DATA= (sid=trsenxi) (instance_name=trdseni) (SERVICE_NAME=tsrseni)))

OK (10 msec)

–监听没有启动且tnsnames.ora里的address地址正确时报TNS-12541: TNS:no listener

[oracle@trsenomr admin]$ tnsping test1

TNS Ping Utility for Linux: Version 11.2.0.3.0 – Production on 06-JUL-2015 08:18:27

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.110)(PORT=1521)) (CONNECT_DATA= (sid=trsenxi) (instance_name=trdseni) (SERVICE_NAME=tsrseni)))

TNS-12541: TNS:no listener

TNS-12543: TNS:destination host unreachable–host配置错误

TNS-12541: TNS:no listener–port或者port且host都配置错误或者listner没有启动

–一般情况connect_data配置问题，发生在connect时报错如下

[oracle@trsenomr admin]$ sqlplus system/oracle@test1

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 6 08:27:40 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect

descriptor