zergduan 发表于 2015-5-21 11:45
你listener.ora 和 sqlnet.ora的内容发上来看看
listener.ora内容,没有使用sqlnet.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 8.8.8.8)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ndb)
(ORACLE_HOME = /DATA/app/oracle/product/11.2.0.3)
(SID_NAME = ndb)
)
)
#DIAG_ADR_ENABLED_=on
gateway =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=8.8.8.8)(PORT=1531))
)
SID_LIST_gateway=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc)
(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)
(PROGRAM=dg4odbc)
)
(SID_DESC=
(SID_NAME=ads)
(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)
(PROGRAM=dg4odbc)
)
(SID_DESC=
(SID_NAME=ads_sys)
(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)
(PROGRAM=dg4odbc)
)
(SID_DESC=
(SID_NAME=statistics1)
(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)
(PROGRAM=dg4odbc)
)
(SID_DESC=
(SID_NAME=statistics2)
(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)
(PROGRAM=dg4odbc)
)
(SID_DESC=
(SID_NAME=vrs)
(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)
(PROGRAM=dg4odbc)
)
(SID_DESC =
(SID_NAME = mvrs)
(ORACLE_HOME = /DATA/app/oracle/product/11.2.0.3)
(PROGRAM = dg4odbc)
)
(SID_DESC =
(SID_NAME = mvrs2)
(ORACLE_HOME = /DATA/app/oracle/product/11.2.0.3)
(PROGRAM = dg4odbc)
)
(SID_DESC =
(SID_NAME = adstest)
(ORACLE_HOME = /DATA/app/oracle/product/11.2.0.3)
(PROGRAM = dg4odbc)
)
(SID_DESC =
(GLOBAL_DBNAME = ndb)
(ORACLE_HOME = /DATA/app/oracle/product/11.2.0.3)
(SID_NAME = ndb)
)
(SID_DESC=
(SID_NAME=dealer)
(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)
(PROGRAM=dg4odbc)
)
(SID_DESC =
(SID_NAME = grape)
(ORACLE_HOME = /DATA/app/oracle/product/11.2.0.3)
(PROGRAM = dg4odbc)
)
(SID_DESC =
(SID_NAME = hui_agency)
(ORACLE_HOME = /DATA/app/oracle/product/11.2.0.3)
(PROGRAM = dg4odbc)
)
)
ndb=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))))
SID_LIST_ndb=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=ndb)(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)(SID_NAME=ndb)))
SUBSCRIBE_FOR_NODE_DOWN_EVENT_ndb=off
ADMIN_RESTRICTIONS_ndb=ON
INBOUND_CONNECT_TIMEOUT_ndb=120
ndb=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))))
SID_LIST_ndb=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=ndb)(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)(SID_NAME=ndb)))
SUBSCRIBE_FOR_NODE_DOWN_EVENT_ndb=off
ADMIN_RESTRICTIONS_ndb=ON
INBOUND_CONNECT_TIMEOUT_ndb=120
ndb=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))))
SID_LIST_ndb=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=ndb)(ORACLE_HOME=/DATA/app/oracle/product/11.2.0.3)(SID_NAME=ndb)))
SUBSCRIBE_FOR_NODE_DOWN_EVENT_ndb=off
ADMIN_RESTRICTIONS_ndb=ON
INBOUND_CONNECT_TIMEOUT_ndb=120
(END)