ORA-04052 Error - URGENT [message #621737] |
Sun, 17 August 2014 19:33 |
|
All,
I am facing an issue while executing the below command through an SQL,
EXECUTE IMMEDIATE 'BEGIN MV_REFRESH@EPT_CTA('''||'CGT_WLT_SALE'''||','||'''C'''||'); END;';
Below is the error thrown,
ORA-04052: error occurred when looking up remote object USR_PT_CH02.MV_REFRESH@EPT_CTA.WORLD
ORA-00604: error occurred at recursive SQL level 2
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from EPT_CTA
Please help me how to research and fix this issue ASAP.
|
|
|
Re: ORA-04052 Error - URGENT [message #621738 is a reply to message #621737] |
Sun, 17 August 2014 19:42 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>ORA-04052 Error - URGENT
why is it URGENT for us to solve this problem for you?
The standard advice when (ab)using EXECUTE IMMEDIATE is to compose the SQL statement in a single VARCHAR2 variable
Then print the variable before passing it to EXECUTE IMMEDIATE.
COPY the statement & PASTE into sqlplus to validate its correctness.
04052, 00000, "error occurred when looking up remote object %s%s%s%s%s"
// *Cause: An error occurred when trying to look up a remote object.
// *Action: Fix the error. Make sure the remote database system has run
// CATRPC.SQL to create necessary views used for querying or looking up
// objects stored in the database.
>ORA-01017: invalid username/password; logon denied
Believe this error!
[Updated on: Sun, 17 August 2014 19:43] Report message to a moderator
|
|
|
Re: ORA-04052 Error - URGENT [message #621739 is a reply to message #621738] |
Sun, 17 August 2014 19:56 |
|
BlackSwan,
Sorry for posting it as urgent. Yes, you're correct. Invalid username/password is the issue. I assume EPT_CTA is a database link and its password is incorrect. I have below questions,
1)How to confirm that EPT_CTA is an database link?
2)Where to locate correct/valid password for EPT_CTA? How to update the password, if required?
3)I did not issue the password in the EXECUTE IMMEDIATE statement, so where does it pull the password from?
Thanks.
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: ORA-04052 Error - URGENT [message #621750 is a reply to message #621749] |
Sun, 17 August 2014 20:46 |
|
Got the output from my Infra team for below query,
select owner, db_link from dba_db_links where db_link like 'EPT_CTA%';
OWNER DB_LINK
------------------------------
USR_OM_CH02 EPT_CTA.WORLD
|
|
|
Re: ORA-04052 Error - URGENT [message #621751 is a reply to message #621750] |
Sun, 17 August 2014 20:52 |
|
select * from dba_db_links where db_link like 'EPT_CTA%';
OWNER DB_LINK USERNAME HOST CREATED
------------------------------ ---------------------------
USR_OM_CH02 EPT_CTA.WORLD USR_PT_CH02 s221asd02 28-MAR-12
|
|
|
|
Re: ORA-04052 Error - URGENT [message #621753 is a reply to message #621752] |
Sun, 17 August 2014 21:41 |
|
EdStevens,
Unfortunately i don't have a DBA for me to assist. The person who executed the query is an application admin who has DBA rights.
If the password is stored in an un-documented table and encrypted, then no one would have updated it. Also i have the password located in user_db_links view, Is it the password that Oracle uses to connect?
|
|
|
Re: ORA-04052 Error - URGENT [message #621754 is a reply to message #621753] |
Sun, 17 August 2014 23:48 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Oracle_Walker wrote on Mon, 18 August 2014 08:11Also i have the password located in user_db_links view, Is it the password that Oracle uses to connect?
Per documentation USER_DB_LINKS,
Quote:
It also displays an additional column, PASSWORD, which is no longer used and for which nothing is returned. The PASSWORD column is maintained for backward compatibility only.
|
|
|
|
Re: ORA-04052 Error - URGENT [message #621797 is a reply to message #621753] |
Mon, 18 August 2014 08:00 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
Oracle_Walker wrote on Sun, 17 August 2014 21:41EdStevens,
Unfortunately i don't have a DBA for me to assist. The person who executed the query is an application admin who has DBA rights.
So who IS the DBA? Surely, if you have a database, someone is responsible for DBA tasks.
Quote:If the password is stored in an un-documented table and encrypted, then no one would have updated it.
Not correct. The actual password for the referenced account is stored in the database of that account, to be used when authenticating attempts to connect with that account. All that's needed is to go to that database with proper authority and issue 'ALTER USER SCOTT IDENTIFIED BY LION'. That does NOT update ANY information that ANY client has regarding what credentials said client is supposed to use when connecting as SCOTT.
Quote:Also i have the password located in user_db_links view, Is it the password that Oracle uses to connect?
If your version of Oracle shows anything other than nulls, then that is encryption of the password that the client database will use when it presents a connection request to the target of the db link. That is NOT guaranteed to be the CORRECT password. As I just said,
someone could change the actual password of the target user, and your link would never know.
|
|
|