Todays sailing on Oracale 10g tnsping fails
Written on 12:13 AM by David S Anand
Orcale database is not connecting remotely
[root@David] tnsping **.**.**.**
fails to connect
in the server
[root@dbserver] tnsping localhost
tnsping: command not found
scenario
While pinging the server it is reachable but the oracle database fails to connect as well as localhost
[root@dbserver] tnsping localhost
tnsping: command not found
Checked in firewall the port is open ..icmp is active
ANSWER
Oracle database was down that is the reason server is reachable but fails to connect the database
steps to start oracle database
1. su - oracle
2. lsnrctl start
3. dbstart
[root@dbserver] tnsping localhost
TNS Ping Utility for Linux: Version 10.2.0.2.0 - Production on 28-JUL-2008 12:26:13
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
/home/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=localhost.xxx.com))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
OK (0 msec)
"Story teller"
Posted in
oracle database unable to connect,
tnsping fails
