Home » RDBMS Server » Server Administration » Communicaton between oracle7 and oracle 9!?
Communicaton between oracle7 and oracle 9!? [message #232444] Fri, 20 April 2007 09:51 Go to next message
chugunitz
Messages: 4
Registered: April 2007
Location: Kursk
Junior Member
Hi, dear all!

I'm new in this forum and new in ORACLE.

I try to establish connection between oracle server 9 and oracle 7.
At first I see a mistake "format code appear twice".
I seen in this forum mistake like this, and make, as described, value NLS_DATE_FORMAT.

But, after this, in try to connect with SQL + enterprise,
become to appear this error:

Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

I run the script, on oracle server9, but this mistake appear again and again!

On the oracle7 the table exist too, and have no rows.

Can someone help me to solve this problem?

Great thanks to all!
Re: Communicaton between oracle7 and oracle 9!? [message #232467 is a reply to message #232444] Fri, 20 April 2007 11:32 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I'm not wrong, Oracle 7 and Oracle 9 can not communicate directly. You'll need to have an Oracle 8 instance in between - create database links

Ora 7 <-DB link-> Ora 8 <-DB link-> Ora 9.

[Updated on: Fri, 20 April 2007 11:33]

Report message to a moderator

Re: Communicaton between oracle7 and oracle 9!? [message #232741 is a reply to message #232467] Mon, 23 April 2007 02:48 Go to previous message
chugunitz
Messages: 4
Registered: April 2007
Location: Kursk
Junior Member
Thank you. I'l try
Previous Topic: Truncate slow
Next Topic: Contingency plan template
Goto Forum:
  


Current Time: Mon Dec 02 11:31:09 CST 2024