OraFAQ Forum: Forms » Can i link two database in same machine

Home » Developer & Programmer » Forms » Can i link two database in same machine (10gr2 and express edition )

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

Can i link two database in same machine [message #410379]

Fri, 26 June 2009 12:46

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

hi all gurus

My Question is this I have a two database in same machine one is oracle database 10gR2 and other is express edition can i make link between two database if yes i have created link like that

CREATE DATABASE LINK XE
CONNECT TO hr IDENTIFIED BY hr
USING 'XE';

SQL>LINKED CREATED

But when i am testing link between two database like

sql>select 'x' from dual@xe;

its giving me error

TNS Listner

When I am going to start listner Manually like

LSNRCTL>START --->

Its giving me error failed to start

if some one have solution regarding this pls solve this problem

thanks
baba

[EDITED by LF: removed superfluous empty lines]

[Updated on: Fri, 26 June 2009 15:52] by Moderator

Report message to a moderator

Re: Can i link two database in same machine [message #410400 is a reply to message #410379]

Fri, 26 June 2009 15:51

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

Senior Member
Account Moderator

Quote:

its giving me error

TNS Listner

There's no such error. At least, I've never seen it. How much would it cost if you posted complete SQL*Plus session so that we could see what has happened?

Report message to a moderator

Re: Can i link two database in same machine [message #410704 is a reply to message #410379]

Mon, 29 June 2009 19:31

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you defined a 'tns_admin' environment variable?

David

Report message to a moderator

Re: Can i link two database in same machine [message #411572 is a reply to message #410704]

Sun, 05 July 2009 09:00

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

yes mr Djmartin I have already defined tns_admin in registry with full path like c:\oracle\product\10.2.0\db_1\network\admin

let me tell both database are working 100% fine and i have also two form builders in same machine one is form6i and other form 10g these are also working fine my problem is link two databases
in same machine one is express 2nd databse 10g

looking forward for answer

thanks

Report message to a moderator

Re: Can i link two database in same machine [message #411577 is a reply to message #411572]

Sun, 05 July 2009 09:20

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

Senior Member
Account Moderator

So, what error did you get? Pasting SQL*Plus session would help better than your "TNS Listner" description (which is useless).

Anyway: having TNS_ADMIN set is half a job; another half means that this TNSNAMES.ORA file should contain aliases to both databases (10gR2 and XE).

Report message to a moderator

Re: Can i link two database in same machine [message #411687 is a reply to message #411577]

Mon, 06 July 2009 05:56

ora_baby
Messages: 89
Registered: May 2008

Member

try

CREATE public DATABASE LINK XE
CONNECT TO hr IDENTIFIED BY hr
USING 'XE';

[Updated on: Mon, 06 July 2009 05:56]

Report message to a moderator

Re: Can i link two database in same machine [message #414059 is a reply to message #411687]

Mon, 20 July 2009 04:07

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

hi ora_baby

sorry due to illness i could not reply anyways
i tried also in this but not succeeded

and for mt little foot pls can u explin briefly reagarding alias in both tnsnames.ora

thanks

Report message to a moderator

Re: Can i link two database in same machine [message #414068 is a reply to message #414059]

Mon, 20 July 2009 04:50

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

Senior Member
Account Moderator

Check this thread.

Report message to a moderator

Re: Can i link two database in same machine [message #414362 is a reply to message #414068]

Tue, 21 July 2009 14:29

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

thanks all i have done it thnaks again

pls tell me little thing same procedure would be apply for two different server and database kindly clear this confusion

thanks

baba

Report message to a moderator