TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST=ora11g)(PORT = 1521))
(CONNECT_DATA =
(SEVER = SHARED)
(SERVICE_NAME = prod)
)
)
[oracle@ora11g admin]$ tnsping test
TNS Ping Utility for Linux: Version11.2.0.4.0 - Production on 04-NOV-2015 15:42:39
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST=ora11g)(PORT = 1521)) (CONNECT_DATA = (SEVER =SHARED) (SERVICE_NAME = prod)))
OK (10 msec)
测试：