Home » RDBMS Server » Networking and Gateways » Not able to connect to 8i database from 10g Client (Oracle 10g, Oracle 8i, Microsoft Windows 2003 Service Pack 1)
Not able to connect to 8i database from 10g Client [message #335217] Mon, 21 July 2008 08:50 Go to next message
immense4u
Messages: 5
Registered: July 2008
Junior Member
Hi,

I had two databases one is in Oracle 10g and other is Oracle 8i. Both the databases are developed for different application. Now I had a scenario to retrieve the some conditional (with specific condition) data from a particular table of Oracle 8i and insert into a table of Oracle 10g.


I had used database link earlier for this but at that point my databases are in oracle 9i and 8i. But it is not working in case of Oracle 10g, its showing error Database link is not active.

Re: Not able to connect to 8i database from 10g Client [message #335219 is a reply to message #335217] Mon, 21 July 2008 08:53 Go to previous messageGo to next message
BlackSwan
Messages: 22554
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above

Some specific versions of 8i will not talk to V10;
which is why Posting Guideline state to post Oracle version to 4 decimal places.

Beside V8 Oracle is/was not certified on Windows 2003.

[Updated on: Mon, 21 July 2008 08:54] by Moderator

Report message to a moderator

Re: Not able to connect to 8i database from 10g Client [message #335221 is a reply to message #335219] Mon, 21 July 2008 08:59 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

So what is the output if you run

select 1 from dual@yourdblink;

Re: Not able to connect to 8i database from 10g Client [message #335223 is a reply to message #335217] Mon, 21 July 2008 09:00 Go to previous messageGo to next message
SUBBARAO MANCHIKANTI
Messages: 8
Registered: December 2000
Junior Member
Hi,

You can export the table using query and import into Oracle 10g database.

Goos Luck,
Subbarao
Re: Not able to connect to 8i database from 10g Client [message #335230 is a reply to message #335217] Mon, 21 July 2008 09:11 Go to previous messageGo to next message
immense4u
Messages: 5
Registered: July 2008
Junior Member
Thanks for replying

When i try to run a query then it shows up the message database link is not active.
Re: Not able to connect to 8i database from 10g Client [message #335232 is a reply to message #335217] Mon, 21 July 2008 09:16 Go to previous messageGo to next message
BlackSwan
Messages: 22554
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above

Re: Not able to connect to 8i database from 10g Client [message #335235 is a reply to message #335217] Mon, 21 July 2008 09:28 Go to previous messageGo to next message
immense4u
Messages: 5
Registered: July 2008
Junior Member
As you had suggest me to export a table and import into 10g database. It have to completed manually. But i had to implement the automatic table updation after a particular time or user request.

Is anything automated or trigger etc. that will be implemented and my particular table will be updated.

Re: Not able to connect to 8i database from 10g Client [message #335236 is a reply to message #335217] Mon, 21 July 2008 09:29 Go to previous messageGo to next message
BlackSwan
Messages: 22554
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above

Re: Not able to connect to 8i database from 10g Client [message #335306 is a reply to message #335235] Mon, 21 July 2008 15:26 Go to previous messageGo to next message
Littlefoot
Messages: 19345
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
To cut a long story short: Oracle 8 can not be connected to Oracle 10 via a database link. You might need to install an "intermediate" Oracle 9 instance which will be used as a "gateway", such as
Oracle 8 <-DB link-> Oracle 9 <-DB link-> Oracle 10
Re: Not able to connect to 8i database from 10g Client [message #335516 is a reply to message #335217] Tue, 22 July 2008 07:08 Go to previous messageGo to next message
immense4u
Messages: 5
Registered: July 2008
Junior Member
Hi

I am using oracle 9i client and used the copy command to communicate the databases. If client had to use 8i (8.1.5.0.0) and Oracle 10g (10.1.0.2.0). Then he had to purchase 9i Client to make interface. It's not fair for the client.

Is anything else without any additional cost?
Re: Not able to connect to 8i database from 10g Client [message #335519 is a reply to message #335516] Tue, 22 July 2008 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is anything else without any additional cost?

Export/import as already been said.
Unload/load also works.

Regards
Michel
icon6.gif  Re: Not able to connect to 8i database from 10g Client [message #335528 is a reply to message #335519] Tue, 22 July 2008 08:08 Go to previous message
immense4u
Messages: 5
Registered: July 2008
Junior Member
Anyway thanks a lot for your valuable support and time.
Previous Topic: ORA-12541: TNS:no listener
Next Topic: Oracle 10g to LDAP connectivity problems
Goto Forum:
  


Current Time: Thu Jul 31 23:01:11 CDT 2014

Total time taken to generate the page: 0.12674 seconds