Home » SQL & PL/SQL » Client Tools » connect to Remote Data base
connect to Remote Data base [message #354823] Tue, 21 October 2008 07:45 Go to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

hi all,

My oracle version is

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


I am trying to connect to remote oracle DB of version :7.3.4.5

getting the Error :

SQL> connect MCSUSER@MCSDB
Enter password: *******
ERROR:
ORA-03134: Connections to this server version are no longer supported.


In earlier version of Oracle it was a bug.

What should i do now ??..
Re: connect to Remote Data base [message #354831 is a reply to message #354823] Tue, 21 October 2008 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think the message is clear.
You can't connect to a Oracle 7 database with a 10g client (and vice versa).

Regards
Michel
Re: connect to Remote Data base [message #354909 is a reply to message #354831] Tue, 21 October 2008 23:29 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

Hi Michel,

while doing google i came to know the bug can be fixed by a patch. but i not getting more information about that.

Any link or help on this would be appreciated Smile
Re: connect to Remote Data base [message #354910 is a reply to message #354909] Tue, 21 October 2008 23:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT a bug this is feature.
There is no patch.

Regards
Michel
Re: connect to Remote Data base [message #354915 is a reply to message #354910] Tue, 21 October 2008 23:46 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

Below is the link where i got the info :

http://www.orafaq.com/forum/t/76875/0/
Re: connect to Remote Data base [message #354936 is a reply to message #354915] Wed, 22 October 2008 00:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The bug is related to 10.1 connecting to 8.1.7, no relation with your case.

Regards
Michel

[Updated on: Wed, 22 October 2008 00:36]

Report message to a moderator

Re: connect to Remote Data base [message #355219 is a reply to message #354936] Thu, 23 October 2008 03:13 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

Hi Michel,

My server info is

1. Database Vendor: Oracle
2. Database Version: 7.3.4.5

Now my question is

a) For connecting to this Remote server, is it necessary to install Oracle 7.3.4.5 in my local PC. ( i hope client tool is enough)

b) if point "a" is not required then by using which tool i can connect to this server.

c) i am using Toad Version 7.5.2.0 but still not able to connect to this server.

Pls let me know how i can proceed now ??..
Re: connect to Remote Data base [message #355231 is a reply to message #355219] Thu, 23 October 2008 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
a) What is your database version? 10g? So you must have a 9i or up client.

b) You could try with a jdbc thin client.

c) Those who live by the GUI, die by the GUI.

Regards
Michel
Re: connect to Remote Data base [message #355246 is a reply to message #355231] Thu, 23 October 2008 04:02 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member
Hi
Michel,

Thanks for the reply . I can't go for the java thin client as my application is in "Power builder" and i am not allowed to connect through it.

Can u tell me any other way or any other oracle tool by which i can test a connection to the oracle server of version 7.3
Re: connect to Remote Data base [message #355254 is a reply to message #355246] Thu, 23 October 2008 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your post are not consistent.
Is this the database or the client which is in version 7.

Regards
Michel
Re: connect to Remote Data base [message #355256 is a reply to message #355254] Thu, 23 October 2008 05:20 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

Hi michel

My local DB info :

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


server info :

1.	Database Vendor: Oracle 
2.	Database Version: 7.3.4.5


i hope u got it ..
Re: connect to Remote Data base [message #355257 is a reply to message #355256] Thu, 23 October 2008 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What does "server info" means? Where did you get this information? Is this your application server requirements?
Your first part means your database version is 10.2, what is "local db" for your application/architecture?

Regards
Michel

[Updated on: Thu, 23 October 2008 05:24]

Report message to a moderator

Re: connect to Remote Data base [message #355272 is a reply to message #355257] Thu, 23 October 2008 05:46 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

The details are as follwos.

Server side data base is of Oracle Version 7.3.4.5 and is given by "client" and it's already exists.

From my application (i.e Power Builder) i have to connect to the Server data base to fetch the data.

Ther is no local db for my application ( i have to connect to the remote server only)

For testing purpose we would like to connect from local oracle tool to the remote server.

My local data base is oracle 10g
Re: connect to Remote Data base [message #355278 is a reply to message #355272] Thu, 23 October 2008 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Ther is no local db

Quote:
My local data base is oracle 10g

I think you meant client version is 10g.
As I said, you must have a 9i or below client.

Regards
Michel
Re: connect to Remote Data base [message #355424 is a reply to message #355278] Fri, 24 October 2008 00:50 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

Hi michel,

Thnks for the reply.

Pls let me know how can i connect to Oracle Server of Version 7.3.4.5

a) i can't use JDBC since if i hav to use, the same has to be supported by server also. this is not allowed in our server.

b) local client 10g is not supporting to connect to lower version.
3) Toad of version 7.5 itself not supporting to connect to lower version.

I cant go for installation of Oracle 7.3 in my system now.

Pls let me know by using any GUI or any other way is it possible for me connect to Oracle 7.

If so which tool i hav to use and pls let me know the link also.

I tried all the ways i.e using JDBC thin client , Toad, Power Builder , no one is supporting the server version.
Re: connect to Remote Data base [message #355426 is a reply to message #355424] Fri, 24 October 2008 00:54 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Third time:
Quote:
You must have a 9i or below client.


Regards
Michel
Previous Topic: Connecting Mapics From Oracle
Next Topic: sqlplus copy command and temporary tables
Goto Forum:
  


Current Time: Fri Dec 09 23:07:55 CST 2016

Total time taken to generate the page: 0.11727 seconds