471,090 Members | 1,414 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

after set db_domain parameter,but can not resolve database link problem.

It was said the ORA-02085 error result from the mismatch of database
name and database link name ,and
setting glabal_names=false can resolve .
but I want to try the other solution,let global_names still be
true.and set db_domain pramater to fix it,my question is:
If my computer did not configure for domain,so there is no reall
domain name for it,can I fake one domain name to use as the db_domain
paramter?
And I did it,set db_domain to my.fake.com,use the following command:
create public database link test.my.fake.com connect to wqh
identified by wqh using 'test.my.fake.com'
and reset the oracle instance,
but the ORA-02085 error still ocurr.
and GLOBAL_DB_NAME in sys.props$ (select * from sys.props$ ) is
TEST.my.fake.com
but result of select * from global_name is test,
and global_name SHOULD be db_name+db_domain.

thank you in advance
Jul 19 '05 #1
0 5186

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Catherine Jones | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.