Home » Server Options » Replication » db link server to client
db link server to client [message #75091] Fri, 03 August 2001 02:02 Go to next message
ktouk
Messages: 1
Registered: August 2001
Junior Member
Can i make db link from server to client (personal database) ?
Please tell me about method ?


----------------------------------------------------------------------
Re: db link server to client [message #75129 is a reply to message #75091] Sun, 23 December 2001 16:35 Go to previous message
Pham Huy Giang
Messages: 6
Registered: December 2001
Junior Member
If your systems is Personal database ( Client/Server only), you can connect them by using tools: Set Configuration Easy, and you read the guide in it , for example IP adress of client machine,...
and another way that you open file: TNSNAME.ora
in subdirectory Net80/Admin/, and you change the name of section:
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
You change the name : Beg-local by name you want.
For examine, you open SQL*PLUS of Server Machine, input account: scott/tiger ; and database name is the name you change. Your database will log on successfully.

Good Luck.
Pham Huy Giang

----------------------------------------------------------------------
Previous Topic: how to update data of two servers
Next Topic: db replication issue-help
Goto Forum:
  


Current Time: Thu Mar 28 17:32:22 CDT 2024