problems copying data: database link error - ldap

[annette]

While trying to execute a script generated by the oracle change management tool (propagation) the following errors occured:

ORA-04052: error occurred when looking up remote object BB_DATAPROV_TEST.DPBB_BATCH_POSITION@PAT

ORA-00604: error occurred at recursive SQL level 1

ORA-28030: Server encountered problems accessing LDAP directory service

Failed to copy long data.

Any ideas?

Annette

 

[MikeJones]

I'm only guessing but does the object BB_DATAPROV_TEST.DPBB_BATCH_POSITION@PAT have a long or long raw column? I know Oracle is very picky about what operations it allows on these data types (i.e. a lot of Oracle functions like length can't be used on them)

 

[annette]

No, there's no long column in this table.

It's a table, I want to copy from one database to another, structure and data.
So datatypes are the same on both tables (source and destination).

 

[annette]

I tried the same with a very small table with only 2 comlumns. I get the same error message:

>CREATE TABLE "BB_DATAPROV_TEST"."DELMESOON"("A" VARCHAR2(30), "B" NUMBER) LOGGING
> Copying data using:
declare
cursor c1 IS
SELECT "A", "B" FROM "BB_DATAPROV_TEST"."DELMESOON"@"PAT" ;
BEGIN
FOR c1rec in c1 loop
INSERT INTO "BB_DATAPROV_TEST"."DELMESOON" ( "A", "B" ) VALUES (c1rec."A",c1rec."B"
END loop;
commit;
END;

ORA-04052: error occurred when looking up remote object BB_DATAPROV_TEST.DELMESOON@PAT
ORA-00604: error occurred at recursive SQL level 1
ORA-28030: Server encountered problems accessing LDAP directory service

ORA-04052: error occurred when looking up remote object BB_DATAPROV_TEST.DELMESOON@PAT
ORA-00604: error occurred at recursive SQL level 1
ORA-28030: Server encountered problems accessing LDAP directory service

Failed to copy long data.

Exit Value: 1
Script execution failed.

Regards
Annette

 

[MikeJones]

Hmmm, I've never worked with Oracle change management tool so I'm abit stumped, I take it the LDAP service is working through other routes?

Can you see the remote database through SQL Plus?

 

[annette]

No, when I'm trying
select * from bb_dataprov_test.delmesoon@pat;

from sqlplus I get the the same error:

ora 28030- error: server encountered problems accessing the ldap directory service.

 

[MikeJones]

Ah! do you know if you use an LDAP? and if so if it is set up correctly?

 

[Guest_imported]

Annette,
I am always do it this copy command
Before copy verify if you have enough free extents for this table
You have to recreate P/K, INDEXES after copy.
Try.
Ilya
**************************************************
set copycommit 1
set arraysize 1000
copy from id/PD<TNS_NAMES> -
to id/PD<TNS_NAMES> -
CREATE <TABLESPASE_NAME>.<TABLE_NAME> -
using -
select * from <TABLESPASE_NAME>.<TABLE_NAME>;
/
***********************************************8

 

[annette]

I resolved the problem:
It had nothing to do with ldap, but was the fault of a wrong database link, that means the wrong user settings in a database link.

But the error message was a bit misleading, so now I know a lot more about ldap... ;-)

 

[hari1]

Annette,
Can you please elaborate, how you solved the ORA-28030 problem ?

Thanks,
Hari