HOW to get IP number for ORacle database server

I am still new with Oracle database.I want to connect client PC to the Oracle database server and retrive the table from Oracle database server and see the table from my client PC using GIS software name ARCVIEW.Did you all familiar with gis software?I have two question.Hostname refer for what?hostname of my pc or hostname for oracle database server?Where i can get the IP name of database server?I want to help my DBA because he forgot the ip number of server. I hope some one can help me :confused:

THANKS.

then your DBA sucks ass completely.

Windows: ipconfig
Unix: ifconfig

not really sure how you can forget the ip address of the server, you could also try to look in a client TNS file it may have the ip in there

Also do ping machinename

I'm curious, What is the DBA's salary there? They ought to be proud to have such a bright DBA there.

An oracle database server doesn't have an IP number, an ethernet interface does. I have 4 ethernet interfaces in my machines, which one do you want?

You need to have oracle client installed along with the tnsnames.ora file on your pc. This file should contain an entry of the database you are trying to connect to.
To find the ip address of the server, just do the following on the command line:
c:\ping server_name

the hostname you're asking will be the server name which hosts the database that you are trying to connect to.

Dude, do u have tnsentry for the desired Database server. If so then do a tnsping .
It mighthave the ip address. If it has the host name then do a
ping it'll give u ip address.

BTW what the hell is you dumbass DBA doing

Contact your network or unix team to ask them. Another way he can look it up is by looking at the listener.ora file.

You folks need a real DBA !!!

Quote:

---

Originally Posted by dbachief

Another way he can look it up is by looking at the listener.ora file.

---

Possibly, but no guarantee there either. Are you saying that's a sure fire way, or another possible way?

Code:

---

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = ORCL)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

---

One possible solution.. Nothing can be sure fire in cases where a dba says he has forgotten the IP address :rolleyes:

Quote:

---

Originally Posted by davey23uk

Unix: ifconfig

---

Unprivileged users will need to enter the full path to ifconfig:

/usr/sbin/ifconfig or
/sbin/ifconfig.

use sys_context to find ip address.


try this query

select sys_context('USERENV','IP_ADDRESS') from dual;

Quote:

---

Originally Posted by baburaj

use sys_context to find ip address.


try this query

select sys_context('USERENV','IP_ADDRESS') from dual;

---

utter rubbish, dont post crap please