-
(Oracle 9i, Solaris)
When I run: CREATE PUBLIC DATABASE LINK "testdb" using 'testdb';
And then run select * from dba_db_links
OWNER Link_name
PUBLIC TESTDB.COM
Why does it put the .com on the end??
GLOBAL_NAMES=FALSE
DB_DOMAIN=WORLD
The link works!
I had to put TESTDB.COM in my server TNS!
What else could cause this?
Don't blame me, I'm from Red Sox Nation.
-
Could you post your sqlnet.ora file?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
I don't have a
/oracle/product/9.0.1/network/admin/sqlnet.ora file
or a sqlnet.ora on my client.
I turned global_names = true and explicitely created the links with
CREATE PUBLIC DATABASE LINK "testdb.world" using 'testdb';
when I run select * from v$database@testdb.world and I get:
ORA-02085 database link TESTDB.COM connect to TESTDB.COM
-
Check your global name by running :
SELECT * FROM GLOBAL_NAME;
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
SQL> SELECT * FROM GLOBAL_NAME;
TESTDB.COM
SQL> alter database rename global_name to TESTDB.WORLD;
SQL> SELECT * FROM GLOBAL_NAME;
TESTDB.WORLD
The lesson here is that changing the supposedly DYNAMIC GLOBAL_NAME is bull. You must issue the "alter database" command.
Thanks people!
Don't blame me, I'm from Red Sox Nation.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|