ORA-24247: network access denied by access control list (ACL) Demantra

When attempting to execute a new
ORA-29273: HTTP request failed
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_HTTP”, line 1491
ORA-06512: at “DEMANTRA_INTG.AU_TRIGGERWORKFLOW”, line 17
ORA-06512: at “DEMANTRA_INTG.XXDM_UPDATE_CONTAINER_DATA”, line 228
ORA-06512: at “DEMANTRA_INTG.XXDM_BUILD_CONTAINER”, line 344
ORA-06512: at line 1
Starting Demantra: Hardware. LOG. JAVA Compatibility ACL / SYS_GRANTS. SYNC WKS. Setup MAIL (Doc ID 1372253.1)
Here is an example of Demantra installed directory where the sql files located:
C:\Program Files (x86)\Oracle Demantra 12.2.4.1\Demand Planner\Database Objects\Oracle Server\admin
SYS_GRANTS
SYS_GRANTS.SQL or ACL error

Have you met this error on db_exception_log? ~ This is how you can fix it!:

29273 : ORA-29273: HTTP request failed
ORA-06512: at “”SYS.UTL_HTTP””, line 1817

ORA-24247: network access denied by access control list (ACL)”

SYS_GRANTS.sql performs the following:
– Adds EXECUTE privileges to access DBMS_CRYPTO (UPGRADE_PASSWORDS): Provides the highest level of user password encryption.

– Adds EXECUTE privileges to access DBMS_LOCK: Provides as SLEEP operation for improved concurrency.

– Adds EXECUTE privileges to access V_$PARAMETER so that Oracle Demantra can better adapt to your database configuration.

– (10g only) Adds GRANT privileges to access the package UTL_HTTP, which enables Oracle Demantra to send notification messages to the application server and engine.

– (11g only) Adds an ACL to enable HTTP communications for Oracle Demantra to send notification messages to the application server and engine.

Find it in Demantra_Folder\Demand Planner\Database Objects\Oracle Server\admin
or directly in the root of the Demantra installation package.


Please also verify you have the correct data in

SQL> select * from sys_params where lower(pname) like ‘%url%’;

You need to run this script manually after installing or upgrading Demantra only if you did not specify a database user with full SYSDBA privileges when running the Installer.
1. !! Login AS sys, WITH sysdba privileges:
2. C:\> cd DEMANTRA_INSTALL_DIRECTORY
3. C:\DEMANTRA_INSTALL_DIRECTORY> sqlplus SYS@SERVER as sysdba@sys_grants.sql DM_SCHEMA_USER ACL_for_WebServerURL ACL_for_EngineServerURL
Example execution:
C:\DEMANTRA_INSTALL_DIRECTORY> sqlplus SYS@SERVER as sysdba@sys_grants.sql DM_SCHEMA_USER ‘/sys/acls/demantra.xml’ ‘ /sys/acls/demantra.xml’
OR by Default: if you are not sure, they will be created if they do not exist, or updated in /sys/acls/demantra.xml:
SQL> @sys_grants.sql DM_USER ACL_DEFAULT ACL_DEFAULT;
General Checks:
— select * from dba_network_acls;
— select * from dba_network_acl_privileges;
Check also in sys_params or Business Modeler
— AppServerURL and
— EngineServerURL
— select * from sys_params where lower(pname) like ‘%url%’;
Check:
— SQL> select * from DBA_tab_privs where grantee = ‘DEMANTRA’ ; — (dem schema)
Be sure from system user run if needed entry for APPS user against demantra.xml in dba_network_acl_privileges table: BEGIN DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE ( ‘/sys/acls/demantra.xml’, ‘APPS’,TRUE,’connect’); COMMIT; END;
—Also check entry for UTL_HTTP table for the query – select * from DBA_tab_privs where grantee = ‘DEMANTRA’ ;
Check
For failed login problem to Collaborator Workbench, check if sys_grants is needed to be applied again:
1. SQL> select distinct encryption_type from user_id; — This should return a single value like “SHA-1”
2. SQL> select encryption.get_highest_desc() from dual; — This should return the same value returned in step (1).
If the result of (1) is “SHA-1” but the return of (2) is something else, then you need to fix your sys_grants.

 

References:

Document: 454369.1 Roles and Privileges that are granted to the Demantra database during the install process
Document: 730883.1 Additional Database Privilege needed for Demantra Schema when Running on Oracle 11g Database
Document: 1064995.1 Additional Configurations needed when Running Demantra on Oracle 11g Databases
Oracle Demantra Installation Guide for Release 7.3 Document: 825082.1

Advertisements

2016-05 May Shinnyo Podcast – Practice –

2016-05 May Shinnyo Podcast – Practice – 2016-05 May Shinnyo Podcast – Practice What is a Practice? Why do we Practice (and not Preach?) The Story of Buddha and the 3 Monks Practice is Not Perfect Balance of Time – Working with Karma Subscribe to this Podcast (RSS) or iTunes or via Flipboard What is a practice? Pretty much anything you do. … Continue reading 2016-05 May Shinnyo Podcast – Practice → http://ow.ly/X67g500xssz

2016-05 May Shinnyo Podcast – Practice

2016-05 May Shinnyo Podcast – Practice

  • What is a Practice?
  • Why do we Practice (and not Preach?)
  • The Story of Buddha and the 3 Monks
  • Practice is Not Perfect
  • Balance of Time – Working with Karma

Subscribe to this Podcast (RSS) or iTunes or via Flipboard

theoryintopractice
Courtesy of creative-remembering-techniques.com

What is a practice? Pretty much anything you do.  What is not practice? Thinking without action, although philosophically-speaking, inaction is still action, as it results in an outcome whether intended or not.

Practice in this context, is not limited to something specific you’re trying to learn, Philosophically, we could say we’re learning throughout our lives, each and every day, so that’s how our “practice” extends throughout our days, indeed throughout our lives.

But isn’t it good enough to be really loud and speak your thoughts like a broadcast?

the-brixton-evangelist
Street evangelism 1950’s Brixton, UK

What happens when you hear such a person?  Is it a moment to stop, listen and contemplate carefully what they’re saying?  Or do you mentally try to block out the extreme noise, and make a mental note to avoid that place in the future.  After all, if it works for cheerleading, why wouldn’t it work for all communication?

51176-318x283-megaphone2
Cheerleading with megaphone

If you observe the difference in context, you can see or maybe hear, the difference between an audience that wants to hear you (and can’t because you’re very far away,) versus one who is trying to tune you out and being viewed as an irritant rather than a example.

Master Shinjo once related how different types of people react to guidance with a story about Shakyamuni Buddha and his disciple Ananda walking home one night. They came across three monks who had been drinking something that was forbidden for monks at the time. The first monk quickly hid on the side of the road behind the bushes hoping not to be discovered.  The second monk averted his gaze and walked quickly past the Tathagata hoping not to be noticed.  The third monk thought that the money he spent was his own and boldly walked calmly right in front of the Buddha without care.  Master Shinjo’s notes on this encounter mention that the first monk represents readily instructable people who are open to new ideas, the second person might need more specific examples and might question reasoning but are motivated by emotional care and compassion, and the third person might need actual correction and regulation in order to learn a new behavior.  Depending on the person, your words and actions might be absorbed readily like a thirsty sponge, or discarded as so much hearsay and opinion.  For those interested in delving further into this story, next month’s podcast will explore the realms of the three areas of Intrinsic, Compassionate and Strict styles of teaching (the 3-Wheel Turning Bodies of the Buddha, Kannon Bodhisattva and Mahavairochana Achala.)

About 2 years ago, I decided that collecting guitars was not the same as actually playing them and signed up for formal lessons.  A long time had passed since I last had something that needed periodic and continued effort to get past my own mental and physical blocks to mastery, and this instrument had become one of those – the kind of situation where you can play “Stairway to Heaven” until people don’t want to hear you any more, but you can’t pick up a random music score and play it because you’re not familiar with how it goes. It’s very similar to saying, “I’m a very religious person,” and everyone nods their heads and thinks, “yes, and one day we’ll see it by actual example.” In this way, you can be doing or saying something quite clear, honest and with great intent, but without reflection upon the outcome of such actions, there really isn’t any measure for improvement or failure.

Just as much as every day we are sedentary, we lose some 1% of our muscle mass per year after 50, the same goes with both our minds, and our efforts to practice. Like that slowly leaking balloon that looks really great floating around, but it’s ever so slowly losing its helium and eventually grounds itself as a deflated rubber raisin, when we don’t do something each day to offset our little sack of karma, it too gets slowly heavier and heavier through natural entropy. To keep our momentum going and that sack staying as light as it can be, it takes daily efforts, and renewed exertion to offset the gentle though persistent waves of sediment that slowly build up over time, and eventually can solidify into much harder to break stone.  This is an example of the same person transitioning between starting out like the first monk described above, and later developing into the third monk even without intent to do so.

/* That’s it for this session. Thank you for listening. For more information feel free to e-mail me at jlui at jlui dot net, or twitter @jhlui1 With Gassho, James*/