Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-22992: cannot use LOB locators selected from remote tables

user500315Jan 29 2007 — edited Feb 8 2007
Hello pals, i'm trying to create a materialized view on a remote database, both on 10G R2.2, the table i'm trying to replicate has a BLOB column and i receive the error ORA-22992. The replication i need to do is in FAST mode, but i can't even query the table in the remote database: select * from table@dblink.
Can you help me please with this matter?

Comments

Levi Pereira
Answer
Hi,

My recommendation is to you use the AIX EtherChannel.
The EtherCannel of AIX is much more powerfull and stable compared with HAIP.

See how setup AIX EtherChannel on 10 Gigabit Ethernet interfaces
http://levipereira.wordpress.com/2011/01/26/setting-up-ibm-power-systems-10-gigabit-ethernet-ports-and-aix-6-1-etherchannel-for-oracle-rac-private-interconnectivity/

If you choose use HAIP I recommend you read this note, and find all notes about bugs of HAIP on AIX.

11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]

ASM Crashes as HAIP Does not Failover When Two or More Private Network Fails [ID 1323995.1]


About Multicasting read it:
Grid Infrastructure 11.2.0.2 Installation or Upgrade may fail due to Multicasting Requirement [ID 1212703.1]

Regards,
Levi Pereira
Marked as Answer by Steve_74 · Sep 27 2020
Steve_74
Thank you very much Levi.

Is HAIP the name given for Option 2. mentioned above ?
Levi Pereira
Hi,
Is HAIP the name given for Option 2. mentioned above ?
Yes.
HAIP = High Available IP Address used to Redundant Interconnect.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2007
Added on Jan 29 2007
#database-key-features, #replication
2 comments
82,728 views