sj_at_china.pages.com.cn writes:
>
>
>
> I am now trying to set up such a database exchange .
>
> the following is the condition I am under :
>
> 1. my oracle listen to 202.96.98.24
> 2. the other oracle server is listen to 134.138.8.28
>
> I have set up my Sun to be a part of 134.138.8.* (35) and config
> tnsnames.ora to set up a new entry to access the other database .
>
> now , I can access the other database by using sqlplus like this:
>
> sqlplus developer/developer_at_connect ( connect is a service name in
> tnsnames.ora )
>
> I think this means I can access the database at the other department.
>
> so , I create a database link as following:
>
> SQL>create database link db_link
> 2 connect to developer identified by developer
> 3 using 'connect.world';
>
> Database link created .
>
> SQL> commit;
>
>
> Commit complete
>
> SQL> select * from test_at_db_link
>
> select * from test_at_db_link
> *
> ERROR at line 1:
> ORA-12666: Message 12666 not found; product=RDBMS; facility=ORA
>
> SQL>
>
> I can not find the error no in my messages book .
I don't know what version of Oracle that you are running, but this looks like
a known bug. Contact your local Oracle support office. They should have a fix
for it.
--
Rick
Rick Wessman
Distributed Data Security
Oracle Corporation
rwessman_at_us.oracle.com
Received on Thu May 28 1998 - 07:01:51 CDT
