刚装的数据库,sqlplus可以登录,服务器已经启动,本机tnsping命令出错,大神们帮我看看吧,鼓捣了三天了没明白,本人刚入手鸟
lsnrctl监听己启动lsnrctl status信息
====================
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-MAR-2012 05:23:52Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-MAR-2012 04:13:59
Uptime 0 days 1 hr. 9 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/app/diag/tnslsnr/zjj-radhat6/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
----------------------------------------------------------tnsping ORCL错误信息:
====================================
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 04-MAR-2012 05:24:54Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:
/home/oracle/app/product/11.1.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = zjj-redhat6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12545: Connect failed because target host or object does not exist---------------------------------------------------------tnsnames.ora文件内容ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zjj-redhat6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
LISTENER_ORCL = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
lsnrctl监听己启动lsnrctl status信息
====================
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-MAR-2012 05:23:52Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-MAR-2012 04:13:59
Uptime 0 days 1 hr. 9 min. 52 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/app/diag/tnslsnr/zjj-radhat6/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
----------------------------------------------------------tnsping ORCL错误信息:
====================================
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 04-MAR-2012 05:24:54Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:
/home/oracle/app/product/11.1.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = zjj-redhat6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12545: Connect failed because target host or object does not exist---------------------------------------------------------tnsnames.ora文件内容ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zjj-redhat6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
LISTENER_ORCL = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
解决方案 »
- 存储过程纠错 急
- MATERIALIZED VIEW ENABLE QUERY REWRITE的问题,困扰了N天了
- Oracle如何得出表中某行的数据创建时间和更新时间
- oracle 里取别名是不是 as 呀,我用了as后假如不对别名group by 就好的,否则就报 那个别名无效 为啥呀
- 写一个函数,应该很简单,呵呵,进来看看
- 请问修改IP地址后Oracle9i就不能用了,为什么?
- 数据库链接(oracle9i或者8i链接oracle7.3)
- 关于大数据量数据迁移的困惑
- 只有一个dbf文件,如何恢复数据库,请大虾帮忙!!!!
- 求大神,dblink问题
- oracle导出问题
- 请教有关oracle移植后,varchar2(4000)字段出现过长的问题
HOST = 192.168.80.3ping主机什么的都正常
[oracle@zjj-radhat6 桌面]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 4 07:37:48 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.Total System Global Area 845348864 bytes
Fixed Size 1339796 bytes
Variable Size 583011948 bytes
Database Buffers 255852544 bytes
Redo Buffers 5144576 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@zjj-radhat6 桌面]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-MAR-2012 07:39:33Copyright (c) 1991, 2009, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@zjj-radhat6 桌面]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-MAR-2012 07:39:42Copyright (c) 1991, 2009, Oracle. All rights reserved.Starting /home/oracle/app/product/11.1.0/db_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /home/oracle/app/diag/tnslsnr/zjj-radhat6/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-MAR-2012 07:39:44
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/app/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /home/oracle/app/diag/tnslsnr/zjj-radhat6/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@zjj-radhat6 桌面]$ tnsping ORCLTNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 04-MAR-2012 07:39:54Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:
/home/oracle/app/product/11.1.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12541: TNS:no listener
[oracle@zjj-radhat6 桌面]$
建议用IP地址,在服务器主机上先配置好,然后copy, listner.ora和tns.ora到各个客户端的相应目录下。