Sunday, May 9, 2010

oracle dblink howto connect between 2 hosts

1) setup a service using netmgr on machine where dblink will be created.
in the NET service name put in cert11
in the service name put cert11.xps8100***.org
there are other screens like "hostname" , "protocol".
you should be able to test connection right here in the last screen.


2) create public database link cert11 connect to user identified by password using 'cert11'


The dblink should work now.

No comments:

Post a Comment

Followers

About Me

Torrance, CA, United States