Home » Developer & Programmer » Forms » Can i link two database in same machine (10gr2 and express edition )
Can i link two database in same machine [message #410379] Fri, 26 June 2009 12:46 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?
Re: Can i link two database in same machine [message #410704 is a reply to message #410379] Mon, 29 June 2009 19:31 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you defined a 'tns_admin' environment variable?

David
Re: Can i link two database in same machine [message #411572 is a reply to message #410704] Sun, 05 July 2009 09:00 Go to previous messageGo to next message
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

Re: Can i link two database in same machine [message #411577 is a reply to message #411572] Sun, 05 July 2009 09:20 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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).
Re: Can i link two database in same machine [message #411687 is a reply to message #411577] Mon, 06 July 2009 05:56 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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




Re: Can i link two database in same machine [message #414068 is a reply to message #414059] Mon, 20 July 2009 04:50 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this thread.
Re: Can i link two database in same machine [message #414362 is a reply to message #414068] Tue, 21 July 2009 14:29 Go to previous messageGo to next message
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



Re: Can i link two database in same machine [message #414363 is a reply to message #414362] Tue, 21 July 2009 14:38 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It doesn't matter where these databases are - the only thing that matters is that they must be accessible via network.
Re: Can i link two database in same machine [message #414850 is a reply to message #414363] Thu, 23 July 2009 16:01 Go to previous message
owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT
Senior Member
Thanks Mr Little foot thanks a lot for helping me lot



baba
Previous Topic: How can we Check two text item string correct or not ?
Next Topic: Need to change the printer setting margin on paper size
Goto Forum:
  


Current Time: Thu Dec 08 16:19:07 CST 2016

Total time taken to generate the page: 0.24787 seconds