OraFAQ Forum: Networking and Gateways » DB Link Problem from 9i Database to 8i Database

Home » RDBMS Server » Networking and Gateways » DB Link Problem from 9i Database to 8i Database

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

DB Link Problem from 9i Database to 8i Database [message #203122]

Mon, 13 November 2006 23:40

DeepakT
Messages: 2
Registered: November 2006

Junior Member

Hi all,

Briefing the problem:

When I m going to connect database from 9i to 8i through DB link
I m getting an error like " The Database link is not active"

Please give me solution.

Thanks & Regards
DeepakT

Report message to a moderator

Re: DB Link Problem from 9i Database to 8i Database [message #203178 is a reply to message #203122]

Tue, 14 November 2006 03:35

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

Senior Member

Has it been created properly ?

Have you just tried

select 'x' from dual@dblinkname

Also can you select * from v$dblink ?

Report message to a moderator

Re: DB Link Problem from 9i Database to 8i Database [message #203378 is a reply to message #203178]

Tue, 14 November 2006 23:50

DeepakT
Messages: 2
Registered: November 2006

Junior Member

Hi,

I think, it's not created properly.

If I use "select * from v$dblink", it shows no result.

Report message to a moderator

Re: DB Link Problem from 9i Database to 8i Database [message #203391 is a reply to message #203378]

Wed, 15 November 2006 00:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

So how did you create a database link? Did you provide correct credentials (username, password and database alias (can be found in TNSNAMES.ORA))?

Report message to a moderator

Re: DB Link Problem from 9i Database to 8i Database [message #203441 is a reply to message #203391]

Wed, 15 November 2006 02:53

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

Senior Member

Show us the create statement for the databaselink and an "extraction" of your tnsnames.ora for that particular database you are trying to connect to.

Might be easier to help you then.

Report message to a moderator

Previous Topic:	ORA-12520 when performing simultaneous requests
Next Topic:	insufficient priveleges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 09:45:01 CST 2024