Topic: Oracle on Unix/Linux >> DB-link error between 9i(9.2.0.4) and 8 (8.0.5)
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: DB-link error between 9i(9.2.0.4) and 8 (8.0.5) |
| borg |
Posted: Dec 10, 2003 05:00:26 AM |
Total Post: 1
Joined: Dec, 2003
|
hi,
I'm encounter a DB-link error
I have 2 oracle DB in 2 machine
DB_AAA is oracle 8.0.5 machine-A
DB_BBB is oracle 9i (9.2.0.4) machine-B
in Machine-B, I can use DB link to machine-A's DB by using
sqlplus ID/PASSWD@DB_AAA
all function are working.
but..
if I connect to local DB first by
#sqlplus ID/PASSWD (now connect to DB_BBB, oracle 9.2.0.4)
in sqlplus:
SQL> select count(*) from schema.table@DB_AAA
COUNT(*)
----------
20601
it seems ok.
but if I use another command:
SQL> desc schema.table@DB_AAA
it will shows
"ORA-03113: end-of-file on communication channel"
anyone knows why??
is passible the DB-link between these 2 version has compatibility problem by using "desc" command ???
because I try this db-link on the the other DB(9i), it's ok
thanks. |
|
|
Kris |
| Posted: Dec 10, 2003 10:13:28 AM | |
|
Total Post: 30
Joined: Jan, 2003
|
It could be a problem with global name. Try to rename global names. You can take a look at metalink note: 1018063.102 for more details on it.
Kris
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|