Prev: Can RMAN backup to two different directories while using one channel?
Next: WORK WITH INTERNET ONLINE JOBS - EARN $19,000 MONTHLY
From: phil_herring on 14 Jul 2010 20:35
Do you have more than one Oracle home on the server?

By default, a DB link will use the TNS names file in the database
home. However, it's possible that when you run tnsping, you're using
another Oracle home with a different TNS names file.


-- Phil
From: Krzysztof Cierpisz on 15 Jul 2010 02:24
On 15 Jul., 02:35, "phil_herr...(a)yahoo.com.au"
<phil_herr...(a)yahoo.com.au> wrote:
> Do you have more than one Oracle home on the server?
>
> By default, a DB link will use the TNS names file in the database
> home. However, it's possible that when you run tnsping, you're using
> another Oracle home with a different TNS names file.
>
> -- Phil

definitely I have only one Oracle home.
there is only one tnsnames.ora file on my system.
it's fairly new entry into tnsnames.ora file, and as mentioned above
when I change tnsname entry from OXO into TEST both connections
(sqlplus and dblink) work fine.

thanks,
chris
From: Mark D Powell on 15 Jul 2010 09:14
On Jul 14, 2:21 pm, Mladen Gogala <n...(a)email.here.invalid> wrote:
> On Wed, 14 Jul 2010 05:57:02 -0700, Mark D Powell wrote:
> > One of the default rules for a database link is that the link name must
> > match the remote database name: what is the name of the remote database?
>
> That is true only in the situations when the global_names=true, which is
> a recommended setting, though not the default one.
>
> --http://mgogala.byethost5.com

As an interesting side fact, I remember the default being true so I
checked the manuals: Sure enough using 10.2 documentation it does
default to true but on 8.1.7 (which has 8.1.6 Reference) the default
was true. So I grabbed the 9.2 documentation and it was true there.

Krzysztof, what is the setting of global_names on the target
database? I believe this parameter controls incoming requests and not
outgoing link names.

HTH -- Mark D Powell --



From: Mladen Gogala on 15 Jul 2010 09:31
On Thu, 15 Jul 2010 06:14:51 -0700, Mark D Powell wrote:

> As an interesting side fact, I remember the default being true so I
> checked the manuals: Sure enough using 10.2 documentation it does
> default to true but on 8.1.7 (which has 8.1.6 Reference) the default was
> true. So I grabbed the 9.2 documentation and it was true there.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL> show parameter global_names

NAME TYPE VALUE
------------------------------------ -----------
------------------------------
global_names boolean FALSE


This is my very own DB on my home machine. I haven't changed the
parameter. The documentation may say whatever it wants, when I install
the database from scratch, the parameter is set to false.


--
http://mgogala.byethost5.com
From: Carlos on 15 Jul 2010 10:56
>
> Krzysztof, what is the setting of global_names on the target
> database?  I believe this parameter controls incoming requests and not
> outgoing link names.
>
> HTH -- Mark D Powell --

Let the Oracle speak:

"The name that you give to a link on the local database depends on
whether the remote database that you want to access enforces global
naming. If the remote database enforces global naming, then you must
use the remote database global database name as the name of the link.
"

That was my first question to OP.

Cheers.

Carlos.
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Can RMAN backup to two different directories while using one channel?
Next: WORK WITH INTERNET ONLINE JOBS - EARN $19,000 MONTHLY