OraFAQ Forum: Networking and Gateways » Not able to connect to 8i database from 10g Client

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Not able to connect to 8i database from 10g Client [message #335217]

Mon, 21 July 2008 08:50

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

So what is the output if you run

select 1 from dual@yourdblink;

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above

Report message to a moderator

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

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.

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow the Posting Guidelines as stated in URL above

Report message to a moderator

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

Littlefoot
Messages: 21807
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

Report message to a moderator

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

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?

Report message to a moderator