connect to Remote Data base [message #354823] |
Tue, 21 October 2008 07:45 |
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 #355219 is a reply to message #354936] |
Thu, 23 October 2008 03:13 |
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 #355246 is a reply to message #355231] |
Thu, 23 October 2008 04:02 |
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 #355256 is a reply to message #355254] |
Thu, 23 October 2008 05:20 |
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 |
|
Michel Cadot
Messages: 68704 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 |
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 #355424 is a reply to message #355278] |
Fri, 24 October 2008 00:50 |
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.
|
|
|
|