Home » SQL & PL/SQL » Client Tools » connecting to remote database server through sqlplus
connecting to remote database server through sqlplus [message #386567] Mon, 16 February 2009 02:44 Go to next message
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 #386571 is a reply to message #386567] Mon, 16 February 2009 02:53 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
1) The correct syntax would be

sqlplus user/pass@tnsname


2) But you can't connect to a 7.3.1 Database with a 10g client anyway.
Re: connecting to remote database server through sqlplus [message #386578 is a reply to message #386567] Mon, 16 February 2009 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
My local machine is running on oracle10g & windowsXP
and remote machine is running on oracle7.3.1 & AIX

You can't connect a version 7 database with a 10g client.

Regards
Michel
Re: connecting to remote database server through sqlplus [message #386583 is a reply to message #386567] Mon, 16 February 2009 03:22 Go to previous messageGo to next message
sumanbangladesh
Messages: 17
Registered: April 2008
Location: Bangladesh
Junior Member

if my local machine has no oracle then how can i connect to remote oracle server(oracle7.3.1)


thanks
suman
Re: connecting to remote database server through sqlplus [message #386586 is a reply to message #386583] Mon, 16 February 2009 03:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: connecting to remote database server through sqlplus [message #386587 is a reply to message #386583] Mon, 16 February 2009 03:29 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


If it's NOT available then install client;

Babu
Re: connecting to remote database server through sqlplus [message #386588 is a reply to message #386587] Mon, 16 February 2009 03:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
instant client does not exist in version 7 and version 10 instant client cannot connect to database version 7.

Regards
Michel
Re: connecting to remote database server through sqlplus [message #386639 is a reply to message #386567] Mon, 16 February 2009 05:55 Go to previous messageGo to next message
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 #386643 is a reply to message #386639] Mon, 16 February 2009 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@m_golam_hossain,

What don't you understand in:
Quote:
you can't connect to a 7.3.1 Database with a 10g client anyway.


This has been said and repeated all along the topic, don't mislead OP once more.

Quote:
You should use Developer-2000(2.2) or Deveoper-6i to connect to your current remote database version.

Don't you have other products to buy? Maybe he could buy Sybase or DB2 and connect through heterogeneous services?

Regards
Michel
Re: connecting to remote database server through sqlplus [message #386650 is a reply to message #386643] Mon, 16 February 2009 07:05 Go to previous message
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

Previous Topic: Cannot login as sysdba using isqlplus
Next Topic: Cannot save the data of the columns with CLOB datatype
Goto Forum:
  


Current Time: Sat Dec 10 20:41:45 CST 2016

Total time taken to generate the page: 0.12308 seconds