| db link server to client [message #75091] |
Fri, 03 August 2001 02:02  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
