Hi all,
I have some troubles and can't get rid of them, so if someone could help me...
Well, I'm using 10.2.0.5 and trying to make a streams replication between 2 databases (this is not the topic here).
I found my replication couldn't work because of the source database global_name: it has no domain name appended to it...
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
HARPTEST
SQL> show parameter db_domain;
NAME VALUE
-------------------------------- ------- ------------------------------
db_domain .WORLD
I don't know why, it's an old database and I can't change this.
So now, as you can expect, while trying to make a database link from my slave to this database, I encounter errors:
SQL> create database link harptest connect to streamsadmin identified by xxxxx using 'harptest';
SQL> select * from dba_db_links;
OWNER DB_LINK USERNAME HOST CREATED
------------ ------------------------ ------------ ------------ ------------
STREAMSADMIN HARPTEST.VOODOO STREAMSADMIN harptest 30/03/12
This is the normal behaviour, since I don't give db_name appended to my dblink, it appends the local domain. But then, with my parameter GLOBAL_NAMES set to TRUE, I run to an error:
SQL> select * from dual@harptest;
ERROR at line 1:
ORA-02085: database link HARPTEST.VOODOO connects to HARPTEST
Of course, I could set GLOBAL_NAMES to FALSE but it's not a solution since I'll get the same problem with my capture process.
I try to remove the db_name of my replica (setting it to a zero-length string), bounced the database, but the local db_domain is still appended in my db_link name. I also tried to rename the global_name of my replica (quite wildly with an "update global_name" or "props$"), but still the same.
Do you know how I could connect to a database with no domain name in its global_name?
Thanks for any help!