SQL> select instance_name from v$instance;INSTANCE_NAME
--------------------------------
PMORCL2Cause: An attempt was made to create a database link with the same name as the current database. Action: This database link needs a trailing qualifier to make the name unique. These qualifiers are operating system-specific. See your operating system-specific Oracle documentation for more information about creating database links. 先确定你的实例名。看看还抱什么错。
--------------------------------
PMORCL2Cause: An attempt was made to create a database link with the same name as the current database. Action: This database link needs a trailing qualifier to make the name unique. These qualifiers are operating system-specific. See your operating system-specific Oracle documentation for more information about creating database links. 先确定你的实例名。看看还抱什么错。
create database link ora8@ora8
using 'ora8ss';
可以建立链接,可是在SCHEMA MANAGER中测试有如下提示:
the database link is not active
还有别的什么原因呢?
2。global_name=falst并且别名再对方服务器的tnsname。ora有配?
2.配置tns.ora文件