OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » db link

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db link [message #57782]

Mon, 07 July 2003 18:58

sidd
Messages: 130
Registered: May 2003

Senior Member

In USING CLAUSE OF CREATE DATABASE LIKE COMMAND, i used sid name and it dint work, but when i used host string name, it worked. why it dint work with sid name? can any one explain this.

Report message to a moderator

Re: db link [message #57783 is a reply to message #57782]

Mon, 07 July 2003 19:50

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

hoststring should be used.
becuase , dblinks works on sqlnet

Report message to a moderator

Re: db link [message #57784 is a reply to message #57783]

Mon, 07 July 2003 20:13

sidd
Messages: 130
Registered: May 2003

Senior Member

but what is the diff between host string and sid name and service name

Report message to a moderator

Re: db link [message #57793 is a reply to message #57784]

Tue, 08 July 2003 05:59

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

ORACLE_SID is sid on which the oracle database is created.
from 8i SERVICE_NAME should be equal to ORACLE_SID in tnsnames.ora
the TNS entry you create (it may be anything)
is called connectstring or hostring. It identified the host, port , sid to connect to.

Report message to a moderator

Re: db link [message #57794 is a reply to message #57784]

Tue, 08 July 2003 06:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please have a look here
http://www.orafaq.net/msgboard/sqlnet/messages/2439.htm

Report message to a moderator

Previous Topic:	I/O contention
Next Topic:	12560 tns protocol adapter error/db creation/urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 10:40:05 CST 2025