Hi,
I'm doing some experiments on a dev. environment and trying to write an export script without hard-coding the password.
So I created a Secure External Password Store with a credential for the system user and a matching entry in the tnanames.ora file.
I'm able to connect to the database in sqlplus using the the credential I created meaning the the Secure External Password Store was set up correctly.
However, when I try to do an export using expdp with the tns entry of the credential I get the following error:
The command was:
expdp /@db_nop DIRECTORY=DB_DAILY_EXPORT_TEMP_DIR DUMPFILE=full_metadata_only_04_10_2011.dmp FULL=Y CONTENT=METADATA_ONLY
And the output was:
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-12578: TNS:wallet open failed
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5331
ORA-06512: at "SYS.DBMS_AQADM", line 289
ORA-06512: at "SYS.KUPC$QUE_INT", line 1514
ORA-12578: TNS:wallet open failed
What am I doing wrong?
Oracle 11.2.0.1 on Windows 2003 32 bit