| Accessing Oracle DB on windows [message #125779] |
Wed, 29 June 2005 04:02  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Hi ,
I have a windows XP machine with Oracle 9i on it and a Red hat Linux(32 bit) machine with Oracle 9i on it also. Now i want to access the Oracle database of Linux machine on Windows XP machine. I know how to configure the service and listener. The listener is running on Linux machine and i tried to create a service on Windows XP machine but how to find the host name of Linux machine.
Is it possible to access an Oracle Database of Linux machine on Windows machine. please help me out.
|
|
|
|
| Re: Accessing Oracle DB on windows [message #125785 is a reply to message #125779] |
Wed, 29 June 2005 04:30  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
yes its possible.
U need to install Oracle client on Xp machine for this purpose.
Then configure the tnsnames.ora file on client adding in the SID details of server.
Check for the entries' correctness by using tnsping <service identifier>.
For configuring this u may use hostname/IP of linux machine.
Hostname of linux box can be determined by "hostname" command.
IP can be determioned by "ifconfig -a" command.
Regds
Girish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
