Home » RDBMS Server » Networking and Gateways » Database link
Database link [message #66475] Sat, 29 June 2002 04:11 Go to next message
bharath
Messages: 30
Registered: November 2000
Member
hai,
I am having Oracle8i on HpUX and another on WindowsNT.
I want to create a database link from HpUX server
to WindowsNT server.
i dont know how to configure SQL*NET. I hava client Oracle8i in my PC I want to configure in such a way that i can connect to any database from my client machine. and how can i configure HpUX server for a database link to NT server.
Please help me
thanks in advance
bharath
Re: Database link [message #66476 is a reply to message #66475] Sun, 30 June 2002 12:07 Go to previous message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
HAI,

IT'S EASY.OPEN THE TNSNAMES.ORA FILE WHICH IS IN THE ORACLE_PATHNETWORKADMIN DIRECTORY.OPEN IN THE NOTEPAD.CREATE ONE ENTRY FOR YOUR TWO DATABASES.

TEST1.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YOUR ORACLE hostname)(PORT = 1521))
)
(CONNECT_DATA =
(ORACLE_SID=YOUR DATABASE SID)
)
)

IN THE ABOVE ENTRY,GIVE YOUR ORACLE SERVER NAME OR IP ADDRESS AND ORACLE DATABASE SID.

THEN YOU CAN CONNECT WITH THE TWO SERVERS FROM YOUR LOCAL MACHINE.

IF YOU WANT TO CONNECT THE HP WITH NT DATABASE,THEN YOU SHOULD GO FOR THE DATABASE .
DO AS FOLLOWS

BEFORE CREATING THE DATABASE LINK,WE HAVE TO DO SOME CONFIGURATION.
i am giving one example for you.
for example take the first database
(
sid=orcl
database name=oracle
db_domain=uk.com
host string=ss1
)

first edit the parameter file for the following

db_domain=uk.com

then start the database

In the svrmgr30.exe or sqldba execute this command

alter database rename global_name orcl.uk.com;

(name should be sid.db_domain)
then you execute this command

select * from global_name;

then you got the global database name for that
database like

orcl.uk.com

then go to the second database

(sid=tan
databasename=tani
db_domain=usa.com
host string=ss2
)

edit the parameter file for that database
db_domain=usa.com

start the database

execute this command in the svrmgr30 or sqldba

alter database rename global_name tan.usa.com;

(if in this server also the sid is orcl
don't worry.but only thing is
you should have different
db_domain parameter in each database)

execute this query

select * from global_name;

tan.usa.com

go to the first database

then create the database link by following

(execute this command in the first database)

create database link tan.usa.com
conect to system identified by manager
using 'ss2';

note :

the database link name should be the global database
name for the another database

if you have any problem ,please mail to me

K.SREENIVASAN
Previous Topic: View Creation
Next Topic: Curious pb with Net8
Goto Forum:
  


Current Time: Thu Mar 28 11:00:00 CDT 2024