Error Creating Pl Sql Object Write_line Procedure
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Business Process Management Suite All PlacesFusion MiddlewareSOA & Process ManagementBusiness Process Management Suite This discussion is archived 1 Reply Latest reply on Nov 28, 2011 7:09 PM by felipe ieder - oracle RCU : Error creating PL/SQL Object WRITE_LINE:PROCEDURE felipe ieder - oracle Nov 24, 2011 6:06 PM Hi experts, I'm trying to install from scratch BPM11.1.1.5 in Windows 7 - 64 using Oracle XE 10.2.0.1 I've managed to install the DB and set all recommended configuration according to the doc ( RCU_JDBC_TRIM_BLOCKS, # processes, shared_poolsize, "grant execute on sys.dbms_lock to system with grant option", restarting db and checking db parameters are OK, etc) When I run rcu utility (I am using "system" user for the wizard) I get the mentioned error while creating the SOA Infrastructure. I have the option to Ignore or Stop. If I ignore, right after I get another error DEBUG_PURGE:PROCEDURE, and they keep coming if I keep clicking Ignore button. I suspect for some reason it is not creating some objects in the DB. If I disregard all of them, the summary says that creation was successful - which I really doubt. Have any of you come across this error? I'm struggling with this one. Tried many things but nothing so far... Thanks in advance. Felipe I have the same question Show 0 Likes(0) 674Views Tags: none (add) bpm11gContent tagged with bpm11g, creationContent tagged with creation, errorC
Installation. So this post covers my issues with SOA. Prerequisite 1> Download Oracle Weblogic Server ( :) I already had it installed) 2> A database (I already have an Oracle XE database installed) XE database is not supported but then I am sure it will work for a development environment for testing purpose 3> RCU. All available for download from OTN (Oracle technology Network). The document is going to cover https://community.oracle.com/thread/2316359 several issues that I faced on the install. Starting with creating an RCU on oracle XE database. While Installing the RCU on Oracle XE Database. The first problem that I faced is creating a SYSDBA user I tried using SYS but it would just not connect. I know many of you folks out there are experienced DBA's and you http://applicationservers-expirements.blogspot.com/2013/07/my-tryst-with-soa.html might laugh out on my knowledge but then I am from the middle ware team. So, out of several things that I tried was using the apex GUI but could not get around it. So I was back to the usual SQL Plus using SQLJ. So now I have a user named user1 which is a SYSDBA. I though I could go ahead with it but turns out I was wrong. I got two of the below errors. ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: Error creating PL/SQL Object WRITE_LINE:PROCEDURE ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: Error creating PL/SQL Object DEBUG_PURGE:PROCEDURE This was resolved after assistance from the blogpost http://soafarm.wordpress.com/2011/12/08/error-creating-plsql-object-write_lineprocedure-rcu-ofm_rcu_win_11-1-1-5-0/ And the solution is to 1> grant execute on sys.dbms_lock to user1 with grant option 2> set the Environment variable RCU_JDBC_TRIM_BLOCKS to TRUE For Windows set it through a> right click on My Computer -> Properties -> Click On Advanced b> Click on Environment Variables towards the bottom c> Then in System Variables add in new There is an easier way of doing it. Inst
SOA_INFRA is down even after starting http://haridba7.blogspot.com/2012/12/ora-errors_21.html SOA managed server,In this case we need to be aware of the below error.This error can be resolved as given below.MDS-01370:MetadataStore configuration for metadata-store-usage "soa-infra-store" is invalidError Message:Caused By: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"MDS-01370: MetadataStore configuration for error creating metadata-store-usage "soa-infra-store" is invalid.ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errorsORA-06508: PL/SQL: could not find program unit being called: "DEV_MDS.MDS_INTERNAL_SHREDDED"ORA-06512: at line 1Resolution:Step 1: Uninstall the XE Database by launching Oracle XE graphical utilityStep 2:Install the XE DatabaseStep 3:Set the Oracle Environment error creating pl variables 'RCU_JDBC_TRIM_BLOCKS=TRUE'and Go to the repository creation utility Home(rcuHome) and BIN path and execute the rcu.bat batch fileC:\Users\RafiAlvi>setRCU_JDBC_TRIM_BLOCKS=TRUEC:\Users\RafiAlvi>cd D:\Rafi_docs\Oracle_SOA_INSTALL\ofm_rcu_win_11.1.1.4.0_disk1_1of1\rcuHome\BINC:\Users\RafiAlvi>D:D:\Rafi_docs\Oracle_SOA_INSTALL\ofm_rcu_win_11.1.1.4.0_disk1_1of1\rcuHome\BIN>rcu.batStep 4:Drop all the Schema owner and Tablespaces andthen run RCU again to Re-create the SOA Suite schemas and tablespaces.The list of Component,Schema Owner and Tablespaces are given below:Component Schema Owner TablespacesSOA Infrasture DEV_SOAINFRA DEV_SOAINFRABAM DEV_ORABAM DEV_ORABAMUserMessaging service DEV_ORASDPM DEV_IAS_ORASDPMStep 5:Find and compile the Invalid objects in the XE DatabaseSQL> COLUMN object_name FORMAT A30SQL> SELECT owner,object_type,object_name,statusFROM dba_objectsWHERE status = 'INVALID'ORDER BY owner, object_type, object_name;OWNER OBJECT_TYPE------------------------------ -------------------OBJECT_NAME STATUS------------------------------ -------DEV_ESS PACKAGE BODYESSPURGE INVALIDDEV_ESS PROCEDURECLOSE_FILE INVALIDDEV_ESS PROCEDUREDEBUG_PURGE INVALIDOWNER OBJECT_TYPE------------------------------ -------------------OBJECT_NAME STATUS------------------------------ -------DEV_ESS PROCEDURELOG_ERROR INVALIDDEV_ESS PROCEDURELOG_MESSAGE INVALIDDEV_ESS PROCEDUREWRITE_LINE INVALIDOWNER OBJECT_TYPE------------------------------ -------------------OBJECT_NAME STATUS------------------------------ -------DEV_SOAINFRA PROCEDUREPURGE_B2B_INSTANCES_DOWN INVALIDDEV_SOAINFRA PROCEDUREPURGE_RUNTIME_WITH_TIMEOUT INVALID8 rows selected.SQL> conn DEV_SOAINFRAEnter password: