- 论坛徽章:
- 0
|
我的listner是静态注册的,能成功启动:
[oracle@localhost admin]$ lsnrctl status LSN2
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-AUG-2014 14:07:28
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.5)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LSN2
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 23-AUG-2014 13:43:01
Uptime 0 days 0 hr. 24 min. 27 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/localhost/lsn2/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.5)(PORT=1522)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
但是我在windows下面sqlplus,
sqllus sys/password @orcl2 as sysdba
报错:ORA-12560 TNS adapter error
如果我先在虚拟机中把数据库起来,然后等动态注册成功后,可以远程登录,但是不起数据库,用静态注册就是远程不进去。
下面贴出我windows 客户端的tnsnames.ora:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
ORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
不知道为什么不能通过静态注册远程连接?? 请教高手
|
|