My dblink doesn´t work by sql plus client but by sql plus in server machine it works well.
What can be??? how can i solve this problem???.
the error message:
SQL> select global_name from firstname.lastname@example.org;
select global_name from email@example.com
ERRO na linha 1:
ORA-03113: fim de arquivo no canal de comunicação
03-19-2001, 12:03 PM
can u pls. furnish the following info.?
1. whether uer dblink name is the same as uer global database name?
2. that uer global database name is the same name as uer database appended with a .world?
3. also the error u have encountered suggests 'end-of-file' which could mean sql*net commn. failure, network failure or oracle internal failure, if u can furnish more information then definitely could help.
4. pls. do this
SQL> select owner,dblink_name from all_db_links where dblink_name = 'your dblink name'
SQL> select * from global.name;
SQL> select name from v$database;
i may not be correct on the view name, but u could find it out,
pls. do update me with the above info. shall help
03-19-2001, 06:55 PM
The global database name is sedan.world
The db link name is sedan.world
the db_name is sedan
the db_domain is WORLD
thanks for interesting Since now
03-20-2001, 03:50 AM
There should be a Tnsnames.ora file
on the server as well on the client.
It seems that only the Tnsnames.ora on the serverside
has the info for the database-link
03-20-2001, 06:30 AM
i am in complete agreement with ben, it appears that uer tnsnames.ora on the cleint machine is not configured for the target database, all the info. provided by u means that things are ok with the dblink(that was true anyhow or else uer dblink would not have worked from the server), just made myself clear on the issue
03-20-2001, 11:40 AM
i dont ´t really understand the why it isn´t work because the client is configured identical to the server..
detail: my initial domain was dspsrv004. and i changed is there any problem in do that???