1. How to find IP address of Oracle server from oracle client?
2. How to find the Server model & no of CPUs of that server from oracle client?
3. Is it possible to find the total storage capacity of that server from oracle client?
Printable View
1. How to find IP address of Oracle server from oracle client?
2. How to find the Server model & no of CPUs of that server from oracle client?
3. Is it possible to find the total storage capacity of that server from oracle client?
uhhh don't you think it would be much easier to gain that information by logging onto the Oracle server directly?
But anyway.
1. tnsping
2. can't do
3. can't do
2 and 3 you cant, 1 you can get the hostname
By being in server,which command do i've to
use to know answer for the 2nd question?
you cant find that out from the database (cpu_count might give you a good guess on the number of CPU's though)
"server" is a universal term! There is no single command for all servers !! Please understand how to ask questions!!!