| connecting to remote database server through sqlplus [message #386567] |
Mon, 16 February 2009 02:44  |
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
|
Junior Member |
|
|
Hi
Im trying to connect remote oracle database server from my local pc. I execute
C:\>sqlplus desa/desa@192.168.0.21/dhklive
from my pc.But i got following error
ORA-12541: TNS:no listener
Could you please tell me how can i overcome this.
My local machine is running on oracle10g & windowsXP
and remote machine is running on oracle7.3.1 & AIX
Thanks in advance
Suman
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: connecting to remote database server through sqlplus [message #386639 is a reply to message #386567] |
Mon, 16 February 2009 05:55  |
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Mr. Sumon,
To connect to your remote database you need to edit the tnsnames.ora file to define an SID named desa for example. Then connect by using:
username/password@desa
Add the following listing in your tnsnames.ora file:
DESA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.21)(PORT = 1521))
)
(CONNECT_DATA =
(SID = yourdatabase_name)
)
)
tnsnames.ora file is located in:
D:\OracleHome\....\network\admin\
or
D:\OracleHome\....\net80\admin\
folder.
You should use Developer-2000(2.2) or Deveoper-6i to connect to your current remote database version.
Mohd. Golam Hossain
Uttara, Dhaka, Bangladesh.
01715332257
[Updated on: Mon, 16 February 2009 06:00] Report message to a moderator |
|
|
|
|
|
| Re: connecting to remote database server through sqlplus [message #386650 is a reply to message #386643] |
Mon, 16 February 2009 07:05 |
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Dear Michel,
Yes, he should upgrade his both backend and frontend to current versions. However, somedays I had to use Oracle 7+ with Developer 2000 (version 2.2). There should not be question for misleading anybody, because it is an effort to help someone with possible solutions, it is a suggestion to try with various versions if he has not any other means to upgrade his database.
Another thing I understand that Developer 2000 (2.2) is not compatible with Windows-XP. Hence, my suggestion for using Developer 2000 was also a wrong one. Sorry for the inconvenience.
But, if there is no other way, one can try with multiple versions untill he succeeds.
Best Regards-
Mohd. Golam Hossain
[Updated on: Mon, 16 February 2009 07:10] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
