搭建DG的时候,遇到了下面的问题:
[oracle@oradevdb1 admin]$ tnsping oratest1
TNS Ping Utility for Linux: Version 10.2.0.4.0 - Production on 17-JUN-2015 11:10:11
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/10g/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oratest1.800best.com)(PORT = 1522)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oratest1)))
TNS-12541: TNS:no listener
找了很久原来是tnsnames.ora 文中中端口指定错误(写成了2522)
[oracle@oradevdb1 admin]$ more tnsnames.ora
oratest2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradevdb1.800best.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oratest2)
)
)
oratest1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratest1.800best.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oratest1)
)
)