写个bash测试tnsping(加到crontab中),但是在脚本里执行的结果和在shell里执行的结果完全不一样 scripts #!/bin/bash oracle_home='/home/oracle' oracle_base_home='/opt/oracle/product/10.2.0/db_1/bin' my_date=`date +%Y-%m-%d_%H:%M:%S` echo $my_date >> $oracle_home/tnspingtest.txt $oracle_base_home/tnsping 172.17.1.8 >> $oracle_home/tnspingtest.txt $oracle_base_home/tnsping 172.17.1.15 >> $oracle_home/tns...
数据库服务器是192.168.1.104,SID:or9i 我在另外一台linux(redhat 9.0) 装了个客户端,n 安装完成后发现这个问题,弄不懂,问问大家. [root@HOME root]# tnsping or9i104 TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 04-APR-2004 15:23:34 ...
我现在碰到一个问题: 在oracle用户下,用 tnsping oadb 可以解析成功; 但在oa用户下,用 tnsping oadb 却提示“TNS-03505: Failed to resolve name” 哪位高手指点一下小弟,不胜感激啊!
想做两个机器的同步热备份,设定好了tnsnames.ora以后,试验一下能不能连通,就出现这个错误了。 我的服务器是 solaris9,试验了两台都这样,可在我的linux的服务器上就正常。 请问这个错误是不是和安装的数据库有关系? 还有tnsnames.ora这个文件的位置是不是只能是 ORACLE_HOME/network/admin/tnsnames.ora ,能够自己指定吗? 我该怎么解决才好,谢谢。
使用下面程序测试网络: while true do ping 133.96.72.171 -n 1 tnsping bims sleep 2 done 发现tnsping bims时断时续,但ping一直是通的! ----133.96.72.171 PING Statistics---- 1 packets transmitted, 1 packets received, 0% packet loss round-trip (ms) min/avg/max = 29/29/29 TNS Ping Utility for HPUX: Version 9.2.0.7.0 - Production on 12-DEC-2006 14:00:21 Copyright 1997 Oracle Corporation. All righ...
怎么解决?谢谢? listener.ora: # LISTENER.ORA Network Configuration File: /oracle/oracle/product/9.2.0/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gds1)(PORT = 1521)) ...
SQL> conn sys/manager@officedb as sysdba ERROR: ORA-03113: end-of-file on communication channel SQL> !lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production on 28-AUG-2006 13:44:52 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s7a)(PORT=1521))) STATUS of the LISTENER --------------------...
tnsping是可以的,但是sqlplus 不可以,到底为什么? $ sqlplus system/system@eric9i SQL*Plus: Release 9.2.0.6.0 - Production on Tue Aug 1 14:40:13 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor Enter user-name: 具体的操作过程如下: ============== root@e420 # ...