04052 Oracle Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the
Ora-04052 Error Occurred When Looking Up Remote Object Database Link
workings and policies of this site About Us Learn more about Stack how to resolve ora-04052 Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs ora-04052 error occurred when looking up remote object materialized view Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join
Ora-04052 Ora-00604 Ora-12154
them; it only takes a minute: Sign up ORA-04052: error occurred when looking up remote object OWNER.FUNCTION_NAME@DB_LINK Oracle 11g to 10g up vote 0 down vote favorite I'm running an oracle 11g database that needs to run queries on a remote Oracle 10g database. To do this I created a database link on my 11g system. The link works
Ora-04052 Ora-00604 Ora-02019
fine with ordinary SQL queries. E.g: SELECT * FROM table_name@db_link work fine. However, when I attempt to execute a procedure residing on the 10g system from the 11g, I get the following error: ORA-04052: error occurred when looking up remote object OWNER_NAME.FUNCTION_NAME@DB_LINK ORA-00604: error occurred at recursive SQL level 1 ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [55916] ORA-02063: preceding 2 lines from DB_LINK The procedure is executed by the use of synonyms, I'm using PL/SQL Developer. The 11g system is on Windows 7 while the 10g is on Solaris, if it's of any relevance. oracle11g oracle10g linked-server share|improve this question asked Dec 12 '14 at 9:33 Victor Lightyear Chulu II 313 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted You need to apply patchset 10.2.0.3 in the 10g database.Kindly refer this link for the similar issue Kindly download the patch set from metalink Patch 5337014 from metalink share|improve this answer answered Dec 16 '14 at 10:49 psaraj12
friend PL/SQL: ORA-04052: error occurred when looking up remote object [message #335220] Mon, 21 July 2008 08:56 ora-04052 ora-00604 ora-03106 ora-02063 atozvs Messages: 12Registered: May 2008 Location: Hyderabad Junior Member Hi, I
Ora 06544 Pl Sql Internal Error Arguments 55916
have a SP which was running successfully, but after some DB migration from 9i to ora-00604: error occurred at recursive sql level 3 10g byDB team i started to get the following error. PL/SQL: ORA-04052: error occurred when looking up remote object WGR_QRY.
Oracle İntroduction · Leave a comment Error:ORA-04052: error occurred when looking up remote object AZOCEAN.API_OCEAN@ABSORA-00604: error occurred at recursive SQL level https://anargodjaev.wordpress.com/2013/12/14/ora-04052-error-occurred-when-looking-up-remote-object-azocean-api_oceanabs-ora-28001-the-password-has-expired/ 1ORA-28001: the password has expired Solution: bash-3.2$ echo $ORACLE_SIDAZKKUATbash-3.2$ ps http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora04052-error-occurred-when-looking-up-remote-object-calling-procedure-using-database-link-4239962 -afe | grep ora_smon oracle 1605 1 0 Sep 27 ? 6:54 ora_smon_AZKKTST oracle 6752 1 0 Sep 27 ? 8:06 ora_smon_AZKKDEV oracle 20836 1 0 Dec 10 ? 1:04 ora_smon_AZKKUAT oracle 5139 1 0 Nov 22 ? 2:56 ora_smon_AZTEST oracle 8877 1 error occurred 0 Nov 02 ? 9:27 ora_smon_ABSTEST oracle 16373 20081 0 18:58:46 pts/7 0:00 grep ora_smonbash-3.2$ export ORACLE_SID=AZTESTbash-3.2$ echo $ORACLE_SIDAZTESTbash-3.2$ bash-3.2$ sqlplus /nolog SQL*Plus: Release 11.2.0.3.0 Production on Sat Dec 14 18:59:15 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. SQL> conn AZOCEANEnter password: ERROR:ORA-28001: the password has expired Changing password for AZOCEANNew password: ora-04052 error occurred Retype new password: Password changedConnected.SQL> Share post:Share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Google+ (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Tumblr (Opens in new window)Click to email (Opens in new window)Click to print (Opens in new window)Like this:Like Loading... Related Anar GodjaevBaku, Azerbaijan+994552509150 Leave a Reply Cancel reply Enter your comment here... Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account. (LogOut/Change) You are commenting using your Twitter account. (LogOut/Change) You are commenting using your Facebook account. (LogOut/Change) You are commenting using your Google+ account. (LogOut/Change) Cancel Connecting to %s Notify me of new comments via email. Notify me of new posts via email. ←
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Ramnath.Awate Dennis Stevenson Craig Borysowich Nikki Klein AbhaiTripathi bluesguyAZ59 iudithm knowscognosdoi Clinton Jones mircea_luca Iqbalyk COMPANIES VAI SendGrid Apperian Panaya Inc. View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database This group is where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Databases, including Oracle Grid. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. ORA-04052: error occurred when looking up remote object , calling procedure using database link syed ali asked Jun 8, 2011 | Replies (7) Dear Tony, Please Urgent I always follow your mails respond to users, now aim stuck on our one of my database. The Issue is, I have one database as (wflo) version:10.1.0.1 on Windows 32BIT had created one procedure under wflo_mgr schema ( wflo_mgr has granted full privilages) , Now I am calling this procedure from another database name as (NCCIDEV- Version 11.1. on Unix 32BIT) ( create