Я новичок в oracle dba, поэтому мне нужна помощь, которая могла бы прийти мне в голову. Я установил свою базу данных oracle 11gr2 на виртуальную машину с ОС OEL 5.7 и хочу подключить эту удаленную базу данных с toad32bit. Итак, я перешел по некоторым полезным ссылкам, загрузил и установил win32_11gR2_client на ОС Windows 7 64bit. Кроме того, изо всех сил стараюсь следовать инструкциям, мой клиент не может подключиться к моей удаленной базе данных оракула. На стороне клиента, работающем с cmd для tnsping sidname, всегда нет прослушивателя tns с ошибкой, как я упоминал выше
краткое описание МАШИНЫ LINUX:
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /u01/app/oracle
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.testdomain.com)
)
)
sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/app/oracle
прослушиватель состояния lsnrctl
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 03-FEB-2014 15:08:43
Uptime 0 days 1 hr. 32 min. 59 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/testhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testhost.testdomain.com)(PORT=1521)))
Services Summary...
Service "orcl.testdomain.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB.testdomain.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
прослушиватель службы lsnrctl
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl.testdomain.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orclXDB.testdomain.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: testhost.testdomain.com, pid: 5349>
(ADDRESS=(PROTOCOL=tcp)(HOST=testhost.testdomain.com)(PORT=13094))
The command completed successfully
WINDOWS 7 ОПИСАНИЕ КЛИЕНТА C: \ oracle \ product \ 11.2.0 \ client_1 \ network \ admin ENV TNS_ADMIN = C: \ oracle \ product \ 11.2.0 \ client_1 \ network \ admin
ПРИМЕЧАНИЕ. В СЛУЖБАХ WINDOWS НЕТ НИКАКИХ СВЯЗАННЫХ С ORACLE УСЛУГ (СРЕДСТВО НЕТ).
мой клиент tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = testhost.testdomain.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.testdomain.com)
)
)
C: \ Users \ farhan> tnsping orcl (и результат)
Used parameter files:
C:\oracle\product\11.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDTESS_LIST = (ADDRESS - (PROTOCOL = TCP (HOST =
testhost.testdomain.com)(PORT = 1521))) (CONNECT_DATA= (SERVER = DEDICATIED) (SERVICE_NAME
= orcl) (INSCTANCE_NAME = orcl) (GLOBAL_NAME = orcl.testdomain.com)(RDB_DATABSE = orcl)) (TYPE_OF_SERVICE = dedicaated))
TNS-12541 : TNS:no listener
cat / etc / hosts (результат)
# Do not remove the following line, or various programs
# that require network functionality will fail.
#127.0.0.1 testhost.testdomain.com testhost localhost.localdomain localhost
127.0.0.1 localhost.localdomain localhost
#10.10.1.114 testhost.testdomain.com testhost
192.168.0.103 testhost.testdomain.com testhost
::1 localhost6.localdomain6 localhost6
для дальнейших инструкций, которые я попросил опубликовать
# netstat -an | grep 1521 | grep tcp | grep LISTEN
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN
[root@testhost ~]# grep testhost /etc/hosts
#127.0.0.1 testhost.testdomain.com testhost localhost.localdomain localhost
#10.10.1.114 testhost.testdomain.com testhost
192.168.0.103 testhost.testdomain.com testhost
[root@testhost ~]# dig +short testhost.testdomain.com
174.137.125.92