You need to configure your TNSNames in your 9i Box.
Luis
-Original Message-
Sent: Monday, September 08, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L
Dear List,
I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on
oracle 9.0.1(two separate box) I have
Hello Jared
What is the oerr utility?
I just finished searching my disk for *oerr* and no exe or com file found.
Oracle 9.2.0.4 on windows.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 5:54 PM
Yechil,came across the info' below in metalink.
---
there is nothing equivalent to 'oerr' available on Windows NT.
The oerr utility used on Unix to get Cause/Action lines, is a shell script which
Yechiel,
oerr isn't installed on Windows machines - only on UNIX installs.. oerr is
basically a shell script that reads the oraus.msg file under a UNIX install
(and some others too I think). Windows has a binary file under
%ORACLE_HOME%\RDBMS\mesg\oraus.msb, which if you open it has the
I have written in the past a small C program which does the same as oerr only faster,
especially for 'high' error numbers (using binary searches on the files); it is
written for Unix but can easily be adapted to Windows - for those who don't have perl
installed ...
Hamid,
Did you create the database link from the 9i database to the 8i
database?
One database does not know about the other database links.
Ron
[EMAIL PROTECTED] 09/08/03 05:39PM
Dear List,
I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one
on
oracle 9.0.1(two separate box)
The error message should be a definite clue.
If you're not familiar with the 'oerr' utility, now is
the time to try it out.
On either of your servers, type this command from the
system command prompt: oerr ora 12154
The info provided there should make it clear that
some modification are
Title: RE: database link tuning
Trying to bring over 60 rows with database link and write to table using CTAS. It is taking forever - going through Oracle - going through another Oracle that is hooked up with a gateway to Informix - yuck!!
The waits are:
Event Waits Waits/sec % total Wait
Title: RE: database link tuning
BTW,
Was doing join of views pointing to tables through 2 database links and gateway. Just wondering - faster to move the tables then perform join locally esp. if I can do CTAS each time - h.
-Original Message-
From: Stankus, Paula G
Sent
Paula
I was hoping someone with more specific experience in this area. Here is
a quote from Oracle Performance Tuning 101:
Be particularly when joining a local table to a remote table.
My vote if you only have 60 rows would be to populate a local table with
those rows before running
Yes, be particularly careful when accessing tables across database links.
The threshold for when a FTS is more efficient than an index access changes.
Also, i found out this week, that if you use in-line views in your query,
Oracle can send the whole in-line view across the database link!. In the
]
cc:
Subject:RE: database link tuning
Trying to bring over 60 rows with database link and write to table using
CTAS. It is taking forever - going through Oracle - going through another
Oracle that is hooked up with a gateway to Informix - yuck!!
The waits are:
Event Waits
I did some similar experimenting. I was doing a join of two
local tables, and then pushing the result set out a database
link to a remote table. Took for-flipping-ever. Then I
did a local join to a temporary table, and pushed from there.
Ran less than a minute for the same result.
The moral is
Title: Message
Hi, all!
Thanks for your help and suggestions. Here is
some feedback on what I have found on the performance problem
of the querying data between two databases
using DB links.
To John Kanagaraj: filter by
ROWNUM does not make any difference I have absolutely the same
m: Michael Rosenblum
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 06, 2002 12:03
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Database link performance
Hi, all!
Thanks for your help and suggestions. Here is
some feedback on what I have found on the performance
, June 06,
2002 1:07 PMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: Database link performance
Mike,
you created the view on the db_B machine and called it from db_A,
right?
"To Tom
Mercadante: creating of a view, that does filtering, did not help. Absol
ORACLE-LSubject: RE:
Database link performance
Tom,
I
tried both ways:
-
creating the view on db_B and query it from db_A
-
creating view of db_A using link to db_B
No
difference.
Michael Rosenblum,
Dulcian Inc.
-Original Message-From
Title: Message
Use a 10046 level-8 trace, and the
resulting trace file will show what is significantly impacting your time. I
would expect its either the time tallied to SQL*Net message from dblink
or a difference in execution plans.
Cary Millsap
Hotsos Enterprises, Ltd.
[EMAIL
Title: Message
Level
8? I was using level 10 for all events.
-Original Message-From: Cary Millsap
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 04, 2002 1:33
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Database link performance
Use a 10046 level-8
trace
Title: Message
Michael,
Queries across database link's are notoriusly
slow. I've just been thru this and came to the conclusion that you should
create views on the source database (in your case db_B) to limit the records to
be queried via the db link.
I'm
not absolutely sure, but in my
Michael,
Did you try this with the DRIVING_SITE hint? (May not help, but worth
trying). My understanding is that where a STOPKEY such as rownum is
involved, the table (or the result of the query) would be brought across the
dblink into the local TEMP tablespace and the STOPKEY applied lare on.
Hi,
Select * From Dba_DB_LINKS should give you the links.
Drop [Public] Database Link linkName Should Drop the Link.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
Live to learn...
The developer updated me with the following information regarding this
problem:
'If I edit the inline view and removed the decode from the outer query, the
query works'
This update leads me to believe that this might be some kind of bug or
altered feature in 9.0.1 instead of some stupid
db_domain in init.ora is commented out in both cases. I also set it
to:
db_domain =
but it didn't make any difference.
Setting GLOBAL_NAMES to false helped but someone mentioned
that it is not a good practice. Can anybody explain little bit why?
Thanks
Witold
On 10 Dec 2001 at 21:50,
Hi Witold,
if you use oracle replication you're limited to use global_name=true
I don't know any other restrictions.
Regards,
Ed
db_domain in init.ora is commented out in both cases. I also set it
to:
db_domain =
but it didn't make any difference.
Setting GLOBAL_NAMES to false
Witold,
Please check sqlnet.ora, try to comment out NAMES.DEFAULT_DOMAIN entry.
Also, you can comment out glocal_dbname= in listener.ora file to see
what happens.
for example;
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
# (GLOBAL_DBNAME= x.world)
(ORACLE_HOME=
Check for DB_DOMAIN.. in
INIT.ORA
else
Set GLOBAL_NAMES to FALSE
ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
HTH
Make a FREE long distance call from
your PC!http://www.eboom.com/free/
- Original Message -
From:
Witold Iwaniec
To: Multiple
Title: RE: Database link in the same DB
Infact Oracle doesn't stop me from creating db link on my own schema! I see no use of this.
rgds
amar
-Original Message-
From: Amar Kumar Padhi
Sent: Monday, October 29, 2001 8:46 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Database link
Title: RE: Database link in the same DB
Why on earth would you want to do that?? I mean I'm bored and all but it hasn't occurred to me to do this!
Lisa Koivu
Oracle Database Monkey and Certified Couch Potato.
Fairfield Resorts, Inc.
954-935-4117
-Original Message-
From: Aldi
I was able to do this on HPUX, Oracle 7.3.4 by creting a tnsnames.ora
entry like the one below:
SID_LOOP = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1601)
(HOST=127.0.0.1))(CONNECT_DATA=(SID=SID)))
and using it for 'USING' clause of the dblink. the IP address 127.0.0.1
is our
See my reply. It does help with testing certain processes in our
development environment.
--Scott
Koivu, Lisa wrote:
Why on earth would you want to do that?? I mean I'm bored and all but
it hasn't occurred to me to do this!
Lisa Koivu
Oracle Database Monkey and Certified Couch
This is what I eventually did and this fixed my database link problem.
I could have done it like another list member suggested to use the whole
edi.belkin.com in the database link name, but then I would have had to remember to do
this for any future database links, so the one time alter of the
Try updating directly to the global_name table:
update global_name
set global_name='MY_DB_NAME';
commit;
Mario Alberto Ramos
[EMAIL PROTECTED] 24/09/01 13:55
Can you be more specific? I am curious also. When I create a link to a database on
'xxx' it comes out 'xxx.cj.com' which is correct
The extension on a database link is always the domain of the database it is
created in.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 21, 2001 6:16 PM
I try to create a database link named Custom, it ends up as:
Ok, this is 8.1.6 no patches applied on solaris.
Global Names = false
No db_domain name set
Altered the global names in the database and get test.us.oracle.com still and still
get us.oracle.com extenstion of the link.
Where else do I look or do? This will be a private database link.
Thanks
To: Multiple recipients of list ORACLE-L
Subject: RE: database link questions
Ok, this is 8.1.6 no patches applied on solaris.
Global Names = false
No db_domain name set
Altered the global names in the database and get
test.us.oracle.com still and still
get us.oracle.com extenstion
Can you be more specific? I am curious also. When
I create a link to a database on 'xxx' it comes out 'xxx.cj.com' which is
correct but I began looking around and I don't see how it is working. In
our initxxx.ora file we have 'db_domain = WORLD'. In the sqlnet.ora file
we have
Try this:
alter database rename global_name to test;
-Original Message-
Sent: Monday, September 24, 2001 2:24 PM
To: Multiple recipients of list ORACLE-L
Ok, this is 8.1.6 no patches applied on solaris.
Global Names = false
No db_domain name set
Altered the global names in the
What is the domain of the database in which you are creating the link?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 2:55 PM
Can you be more specific? I am curious also. When I create a link to a
database on
Been there, done that, still get test.us.oracle.com.
Thanks for a constructive answer.
Kathy
-Original Message-
Sent: Monday, September 24, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
Try this:
alter database rename global_name to test;
-Original Message-
Sent:
SQL select name, value from v$parameter where name like '%domain%';
NAME
As I stated, the initxxx.ora contains 'db_domain =
WORLD'. In fact, all our databases init.ora files contain the same
'db_domain = WORLD' and yet all links and global names come out with 'cj.com' on
8 different physical boxes. Is there someplace else you are asking
about? I don't know where
I think you are required to have a domain for each link. The domain is
determined at database creation time. The way to check it is:
select * from global_name;
If you want to change it simply use this:
alter database rename global_name to test.mydomain;
Now, if you want to change the name
If you specify the domain name when you create the link it will use that.
Otherwise it just picks what your domain is if you have global names
set to false. I always create mine with the .world extension. Why? Why
not?
I only deal internally so its no big deal. However, if I forget to
put
44 matches
Mail list logo
