-
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
THANKS.
-
then your DBA sucks ass completely.
Windows: ipconfig
Unix: ifconfig
-
confused
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
-
Full path required
Originally Posted by davey23uk
Unix: ifconfig
Unprivileged users will need to enter the full path to ifconfig:
/usr/sbin/ifconfig or
/sbin/ifconfig.
-
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.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
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?
Jeff Hunter
-
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.
thomasp
-
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 !!!
-
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))
)
)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|