Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Pinging a Remote DataBase

 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Masters ,

The Remote DataBase sometimes gets down .

so i need to check from my machine

Please tell me what is the command , How can i ping the port and ip on which the DataBase has been installed???

Thanks in advance.
 
Balu Sadhasivam
Ranch Hand
Posts: 874
Android Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Ravi ,

For which database and which OS ? I would use DB client to check if server is running, say sqlplus (from Oracle).
 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would use DB client to check if server is running, say sqlplus (from Oracle)


I am also using Oracle as backend and SQLDeveloper as IDE , can you please tell me whats the command ?
 
Balu Sadhasivam
Ranch Hand
Posts: 874
Android Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

You should have your oracle client installed right (to connect to remote server) ? check it if its bundled with tools (sqlplus)
 
Balu Sadhasivam
Ranch Hand
Posts: 874
Android Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Ravi,

Also , you can ensure the ip and port of remote machine is acessible by simple telnet .
telnet ipmachine portno
 
Jan Cumps
Bartender
Posts: 2577
11
C++ Linux Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle's database listener ping utility is tnsping.
> tnsping <database>
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic