Thinking Out Loud

April 23, 2014

Missing Password for Database Link Bug

Filed under: 11g,oracle — mdinh @ 3:50 am

So there I was, working on another database duplication project, the requirement is to save the existing database links.

Sounds pretty easy, right?

SELECT OWNER, DB_LINK, DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER) as DDL FROM DBA_DB_LINKS;

Wrong and I know why I am getting bald. Pulling my hair out.

After searching for hours, I found DBMS_METADATA.GET_DDL database link password missing

Another 11.2.0.4 Bug.

I believe the bug was introduced when I modified user’s password as shown below since ¬†everything was working fine just hours ago.

alter user SCOTT identified by values 'S:EDCCC6A91707D978B7D49476BCA228BC7D702C135557F41154ACBF744645;F894844C34402B67';

Got desperate and restored the database which did not help.

Now what and how is one suppose to save database links info?

Find out more here

Advertisements

Create a free website or blog at WordPress.com.