OraFAQ Forum: Server Administration » Database Link Problem

Home » RDBMS Server » Server Administration » Database Link Problem

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

Database Link Problem [message #369502]

Tue, 10 October 2000 23:50

Dave
Messages: 92
Registered: August 1999

Member

I am now in ORACLE 8.1.6 on RedHat Linux 6.2, I created two links to another two remote database: one is ORACLE 7.2.3 on Unix and one is ORACLE 8.1.6 on Linux, I found the latter works and the former doesn't. My SQLNET's configuration is correct, I can connect to both from OS level using database description string.

But I got error as below when using database link within SQLPLUS:

ORA-12663: Services required by client not available on the server

Report message to a moderator

Re: Database Link Problem [message #369503 is a reply to message #369502]

Wed, 11 October 2000 02:16

Jordan Ostreff
Messages: 1
Registered: October 2000

Junior Member

Use SID= syntax for both connections, not service= syntax!

Report message to a moderator

Re: Database Link Problem [message #369504 is a reply to message #369503]

Wed, 11 October 2000 02:42

Dave
Messages: 92
Registered: August 1999

Member

Of course I know using service syntax with ver 8i and using SID syntax with non-8i version, if not, I cant access remotely from OS level.

Report message to a moderator

Re: Database Link Problem [message #369510 is a reply to message #369502]

Wed, 11 October 2000 10:33

Salman Khan
Messages: 51
Registered: September 2000

Member

Hi,

Before creating db_links you must check the whats the global_name of your oracle

select * from global_name;

and then create your db_link by using this.

Bye

Report message to a moderator

Re: Database Link Problem [message #369516 is a reply to message #369510]

Wed, 11 October 2000 21:08

Dave
Messages: 92
Registered: August 1999

Member

I know that for ages. In my case,GLOBAL_NAME in the init.ora is set false, so db link name is not necessarily same as the dabase name.

Report message to a moderator

Re: Database Link Problem [message #369517 is a reply to message #369510]

Wed, 11 October 2000 22:15

AL
Messages: 24
Registered: October 2000

Junior Member

With your kind of attitude, I think you should just buy a book and keep trying on you own instead of asking for help in this forum

Report message to a moderator

Re: Database Link Problem [message #369518 is a reply to message #369510]

Wed, 11 October 2000 22:43

Dave
Messages: 92
Registered: August 1999

Member

My question is for EXPERT, not for rookie like you.->al (cdcgk1.agt.ab.ca)

Report message to a moderator

You Little rookie (Dave) [message #369530 is a reply to message #369510]

Fri, 13 October 2000 10:10

Sunjay
Messages: 2
Registered: October 2000

Junior Member

Dave, Learn some manners, what do you think yourself?

I think you are a piece of S--T. (Fill in the blanks with "H" & "I".

Report message to a moderator

Sunjay, GET OUT, you are not welcome here, unworthy ROOKIE [message #369536 is a reply to message #369510]

Sat, 14 October 2000 01:35

Dave
Messages: 92
Registered: August 1999

Member

Sunjay, I honestly have a pity on you->
timid and mean ROOKIE---->you're nothing but (_|_)
curious about this? read below reversely:
elohssa

Report message to a moderator

Re: Sunjay, GET OUT, you are not welcome here, unworthy ROOKIE [message #369539 is a reply to message #369536]

Mon, 16 October 2000 11:17

Sunjay
Messages: 2
Registered: October 2000

Junior Member

Hey, who the hell are you to say get out from here.

This is not your property you ass_hole. And you hav'nt reply my e-mail at yet you gandoo.

Report message to a moderator

Previous Topic:	Re: WHERE IS THE CONTROLFILE'S TRACE SQL?
Next Topic:	Drop Column SET UNUSED Clause

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:57:51 CDT 2024