Ora-04052 Error Occurred When Looking Up Remote Object
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
ora-04052 error occurred when looking up remote object materialized view ORA-04052: error occurred when looking up remote objectHow To Resolve Ora-04052
tips Oracle Error Tips by Stephanie F. The Oracle docs note this on the ORA-04052 error: ORA-04052 error occurred ora-04052 ora-00604 ora-02019 when looking up remote object Cause: An error has occurred when trying to look up a remote object. Action: Fix the error. Make sure the remote database system has run KGLR.SQL to create
Ora-04052 Ora-00604 Ora-12154
necessary views used for querying/looking up objects stored in the database. During compilation, a forum poster at Oracle FAQ's continues to receive ORA-04052 in a link connection Oracle to Sybase: I am running the SQL and it works fine over a dblink while I put the same query inside a cursor and am creating a procedure there is an error that gets generated during compilation. The link connects a Oracle ora 04052 error occurred when looking up remote object dblink system to a Sybase system. The replier informed the Oracle user that the problem may be that: Oracle cannot see the remote object. Try to enable ODBC tracing on the gateway machine to see what is happening here. Given this advice, the original issue concerning ORA-04052 is resolved, yet with a slightly different problem: The error for some reason was eliminated when the owner was removed from the table name reference. I am not sure why it requires the owner information when the SQL is run but when I put it into the procedure it does not recognize it. In both cases I am connected to using the same db link and as the same user. This only required a simple alteration to the SQL as the discrepancy in this case needed: In your registry enter string LOCAL and in value enter the SID. you don't have to write the owner name after it. �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
Kglr.sql Script
Discuss the workings and policies of this site About Us Learn more
Ora 06544 Pl Sql Internal Error Arguments 55916
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack ora-02020 Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, http://www.dba-oracle.com/t_ora_04052_error_occured_when_looking_up_remote_object.htm helping each other. Join 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 http://stackoverflow.com/questions/27440602/ora-04052-error-occurred-when-looking-up-remote-object-owner-function-namedb-l 11g system. The link works 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 metali
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 http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/ora04052-error-occurred-when-looking-up-remote-object-calling-procedure-using-database-link-4239962 < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis https://www.experts-exchange.com/questions/21926182/PL-SQL-ORA-04052-error-occurred-when-looking-up-remote-object.html Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT Topics Oracle error occurred 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 error occurred when 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) ( created a non fixed user database link as NEWTAJ2 pointing to WFLO database) but I am getting below error execute wflo_mgr.xx@newtaj2; BEGIN wflo_mgr.xx@newtaj2; END; * ERROR at line 1: ORA-04052: error occurred when looking up remote object WFLO_MGR.XX@NEWTAJ2 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 NEWTAJ2 awaiting you
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > PL/SQL: ORA-04052: error occurred when looking up remote object Want to Advertise Here? Solved PL/SQL: ORA-04052: error occurred when looking up remote object Posted on 2006-07-20 Oracle Database 1 Verified Solution 6 Comments 8,787 Views Last Modified: 2011-08-18 Hi, This is my procedure CREATE OR REPLACE PROCEDURE sp_SyncStart AS BEGIN INSERT INTO care_admin.coventry_adPerSyncLog SELECT * FROM yyuniv.adPerSyncLog@UNIVERSE; DELETE FROM yyuniv.adPerSyncLog@UNIVERSE; END; / but I get lovely errors PL/SQL: ORA-04052: error occurred when looking up remote object YYUNIV.ADPERSYNCLOG@UNIVERSE ORA-00604: error occurred at recursive SQL level 1 ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed ORA-02063: preceding 2 lines from UNIVERSE I tried running the insert statement directly via SQL Plus and it worked correctly. Not sure why it works interactively but not contained in a procedure. Any ideas anyone? Thanks in advance for you help. Cheers, Chris 0 Question by:twisted_kiwi Facebook Twitter LinkedIn Google LVL 14 Best Solution bysathyagiri Also make sure the grants on the remote table are explicitly assigned to the user. Go to Solution 6 Comments Message Author Comment by:twisted_kiwi2006-07-20 I have now found out about the catrpc.sql script (formally KGLR.SQL) and have run that on the remote universe database but I still get the same error. 0 LVL 14 Overall: Level 14 Oracle Database 14 Message Expert Comment by:sathyagiri2006-07-20 Check the NLS_LANG on both your databases. Also what's the version of your remote db a