Application Express :: ORA-24247 / Network Access Denied By Access Control List
Apr 5, 2013
When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;
[code]...
View 4 Replies
ADVERTISEMENT
Dec 12, 2012
I am having oracle database version 11.2.0.3.0 standard edition, where one of my users requirement is that he wanted to send mails from oracle database but he is getting below error
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267
ORA-06512: at "SYS.UTL_SMTP", line 161
ORA-06512: at "SYS.UTL_SMTP", line 197
ORA-06512: at "HF_REPORTING.SEND_MAIL", line 12
ORA-06512: at line 18
is it possible to send mails from oracle database in STANDARD Edition?
View 1 Replies
View Related
Nov 15, 2011
While Running the proc,it's raising the below error.
Error report:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 246
ORA-06512: at "SYS.UTL_SMTP", line 115
ORA-06512: at "SYS.UTL_SMTP", line 138
ORA-06512: at "LISTER_SHIFT.SOLN_GENERIC_SENDMAIL", line 33
ORA-06512: at line 1
[code]....
View 12 Replies
View Related
Jul 2, 2013
why the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:
[URL]............
returns nothing for me!
View 1 Replies
View Related
Aug 8, 2012
I am trying to create access control list, but it gives me following error.
SQL> begin
2 dbms_network_acl_admin.create_acl (
3 acl => 'Test_utl_mail.xml',
4 description => 'Allow mail to be sent',
5 principal => 'TEST',
6 is_grant => TRUE,
7 privilege => 'connect'
8 );
9 end;
10 /
dbms_network_acl_admin.create_acl (
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'DBMS_NETWORK_ACL_ADMIN.CREATE_ACL' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
View 14 Replies
View Related
Mar 23, 2005
I got an error while trying to install Oracle 9i on a Win XP machine. So, I decided to wipe out Oracle completely and starting again. I deleted all the Oracle entries from the registry and then tried deleting the folder. But while doing that, I am getting the following error - "Cannot delete oci:Access denied"
The disk is neither write-protected nor is the oci.dll file in use.
View 18 Replies
View Related
May 4, 2013
I installed oracle 11g successfully in my windows7 operating system. After installation it is not allowing me to access C drive. And in the properties of the drive the memory of C drive is shown 0 bytes. And other applications installed in C drive are also not working. Even after uninstalling oracle 11g access to C drive is denied.
View 7 Replies
View Related
Feb 7, 2007
I'm using Oracle10.0 as database for my project and I have installed Toad as front end tool for the Oracle. Now I want to access the database in the network using the Toad.
My question is, is it compulsory that oracle should be installed in every system to access Toad or any thing can I change in the server system to access the database from other systems in the Network.
View 1 Replies
View Related
Jun 18, 2012
i've followed previous threads on this issue, but still cannot get my applet to run from apex. below is the source for my page:
<html>
<head>
<title> LAND MAP </title>
</head>
<body>
<APPLET
id="LandApplet2"
CODE="LandApplet2.class"
width="700" height="300">
[code]....
View 1 Replies
View Related
Feb 4, 2013
I installed Apex 4.2.1 and now m not able to start the page .
[URL] ...
or
[URL] ....
or
[URL] ....
and only see a blank page.
View 3 Replies
View Related
Jan 2, 2013
I am new to Oracle APEX, and have a few questions regarding the user information.
I've created a new workspace on my local APEX installation, created some users in the workspace, and divided them into roles as "Managers" and "Employees". I am the only Dev and Admin of the workspace, and the users (Managers and Employees) I have created are viewers.
I'd like to create database tables in the workspace where some field would refer to the user ID of the created user as a foreign key, and their role. Similarly, I'd like to create pages where a particular region is displayed only if the logged in user is a "Manager". How can I access the user data and the role data using SQL?
I see following tables in my workspace, so which table contains the user information:
APEX$_ACL
APEX$_WS_FILES
APEX$_WS_HISTORY
APEX$_WS_LINKS
APEX$_WS_NOTES
[Code]....
View 2 Replies
View Related
Dec 22, 2012
restrict access to page or component for particular user. when that user login , restricted page should not be visible to the user..
APEX Verison :4.2
View 1 Replies
View Related
Jan 23, 2013
I have installed APEX on my local machine, created a workspace, and added a few users with roles.
I am creating an application, similar to a Library app, where I have a table that stores Books information (BOOK_ID, BOOK_NAME, etc). I'd like to create another table BOOK_USER with two columns, BOOK_ID and USER_ID. BOOK_ID would refer to the BOOKS table, and I want USER_ID to refer to the table that stores user details of the workspace that I am using. The data entry would happen from a page that has two LOVs, one for book name (using BOOK_ID as the value) and another for user name (USER_ID, or whatever field APEX uses to store user's ID). Can I do that in APEX? I've found ways to access and authenticate a user for a page, but how to get data of all users in the workspace? In other words, how to get all usernames in a LOV?
View 5 Replies
View Related
Jun 20, 2012
I managed to upload images to a database server, resize them, copy to the application server and everything worked just fine - the Apex page successfully displayed images. Since last week, things have broken. This is how: there's a directory object which points to application server's directory:
SQL> select * from all_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------- ------------------------------ -----------------------------------
SYS SLIKE_4005_UPLOAD d:gisslike_4005_upload --> on a database server
SYS SLIKE_4005 \my-iasd$homegisslike_4005 --> on an application server
SQL>
I can use a directory located on a database server:
D:GISSlike_4005_upload>dir photo_resize.*
Volume in drive D is RAID
Volume Serial Number is 88F2-69D2
Directory of D:GISSlike_4005_upload
[code]....
How come it doesn't work? I was absent last week, database server was restarted for some reason (there were Windows' updates which required restarting). After that, all applications (lucky us, just two of them, but in multiple procedures/functions) return FALSE for UTL_FILE.FGETATTR.
We recreated directory objects, but that didn't work (UNC or not, no difference). I Googled quite a lot, read Metalink notes - nothing I did solved the problem.
what these OS updates were about; maybe they are not to be blamed at all. Both servers (database & application) run MS Windows Server 2003 Standard Edition Service Pack 2. In the meantime, a colleague developed a workaround (it uses UTL_HTTP) which works, but it is MUCH slower than the previous UTL_FILE.FGETATTR option.
Why don't we keep these images on the database server (instead of the application server)?I was told that Apache is incapable of accessing mapped network directories so we used what we could.
View 13 Replies
View Related
May 21, 2013
How can I access this "file:///C:/Users/RI/m_1.html" external file within the apex page?
I created a page and button for link but struggling for above.
View 5 Replies
View Related
Jan 12, 2013
how to integrate Application Express with Oracle EBS. Any companies that offer hosted EBS environment with APEX and allow developer-level access (ie database, application server, front-end responsibilities)?
View 1 Replies
View Related
Oct 11, 2012
I just installed Apex and want to create an application that accesses data in a non-Apex schema. However, when I create an application I can't see objects in other schemas. I tried specifying the schema and tablename (e.g. apps.gl_je_headers) but that didn't work. I can only see objects in the APEX schema. How do I reference other schemas when I create an application?
View 1 Replies
View Related
Apr 26, 2013
I have a number of pages containing charts and gantts. I want the user to be able to filter the data shown in these various charts. More than that, I want the user's filters to persist between pages. So, if they select "Key project = 'Y'" on the gantt page, the gantt will filter - and if they then navigate to a report (bar chart) page, that will also be filtered for Key projects only.
To make this happen, I plan to have an identical sidebar on all these pages. This will contain maybe 8 dropdowns and tickboxes allowing the user to create or remove these filters. Eventually some users might save preferences for certain choices within these dropdowns.
Since the sidebar will almost always be identical from page to page, the smartest approach would seem to be to create one sidebar (as html region) and access that sidebar from all pages rather than copying the code from page to page. Then I thought I'd create application-level items in order to create global variables for each of the dropdowns.
My question is: is this approach possible? And can I create a "global" region in Page 0 and then access it from other pages? (This is how I thought it would work but I have tried and can't see how to do it.)
View 7 Replies
View Related
Sep 20, 2013
I'm setting up APEX REST security by following the instructions from [URL]...Everything works great according to document.
I can acquire a token, then passing it in the header to get needed data from REST service. Consumer acquires an token by going on web browser to [URL]...
It will be redirected to[URL]... asking for username and password on browser. Once entering them correctly, it will be directed to Redirect URI defined in the OAuth2 client with the token in the URL.
My question is that is it possible to do token acquiring by coding (like in Salesforce) without going to web browser? We've tried doing that, it will stop due to redirect to sign-on.
View 3 Replies
View Related
Jul 20, 2012
I installed and configures APEX in standalone mode about 2 weeks ago and played with it for short time. Now after 2 weeks I came back to start where I left off but APex_admin page would not come up.
I did following tasks as were found on Installed Apex on Oracle 11g. But cannot access admin screen
SQL> SELECT STATUS FROM DBA_REGISTRY
2 WHERE COMP_ID = 'APEX';
STATUS
-----------
VALID
SQL> conn sys as sysdba
Enter password:
[code]...
warning me that XDB requires username password to be sent through insecure manner (Basic authetication without a secure connection
View 1 Replies
View Related
Apr 23, 2010
How can i see all of the objects that are included on the policy of fine grain access control method?
View 2 Replies
View Related
Nov 19, 2012
Apex 4.1.1
Oracle 11g
I have two applications both in the same workspace. I want to log into one of them, but then have a link to a page in the second application, without having to enter a login to the second application.
Trying to follow the following from a while back, but cannot make it work in apex 4.1.1. Is it possible to access two application with one login? Both application are using the same ldap authentication.
I have both applications using the same get cookie process on page 101
{
declare
v varchar2(255) := null;
c owa_cookie.cookie;
begin
c := owa_cookie.get('LOGIN_USERNAME_COOKIE');
:P101_USERNAME := c.vals(1);
exception when others then null;
end; }
The link I use to the second application is a javascript pop window for displaying the second application and call it with the java pop up url
{
javascript:popUp('f?p=366:1:&SESSION.:::::')
}
However, it still asks me for the login to the the second application. I found other conversations that said to fill in the cookie name in the Session Cookie Attributes in Security, Authentication of the second application and entered the cookie name LOGIN_USERNAME_COOKIE here. However I still get the second application login screen now with a bunch of numbers in the username field.
What am I missing to get this to work without having to login again for the second application?
View 2 Replies
View Related
Oct 5, 2013
Let's consider such table that all rows fit into single block:
SQL> create table test as select rownum id, '$'||rownum name from dual connect by level <= 530;
Table created.
SQL> create index i_test on test(id);
Index created.
SQL>
SQL> begin
[code].....
why does approach with full scan take longer even if table occupies only one data block? PS. 11gR2
View 8 Replies
View Related
Oct 25, 2010
I would like my application to have access to 2 different data sources [reached by two different database links]:
- DS_ONLINE that would be the main data source dedicated for an ONLINE access
- DS_OFFLINE, consisting of some materialized views which would refer to the objects of the DS_ONLINE data source, maintained in case of the DS_ONLINE's temporary inaccessibility A flag DS_ONLINE_ACCESS_FLAG indicating the DS_ONLINE's accessibility would be maintained.
I would like to make the choice of the current data source TRANSPARENT to my PL/SQL application [I wouldn't like the logic of determining the current data source to be embedded in my application code]. How can I do it?
I thought I could write the code as follows:
OPEN CURSOR c FOR
SELECT A, B, C FROM TABLE_SYNONYM;
Where the definition of the TABLE_SYNONYM would change in function of the DS_ONLINE_ACCESS_FLAG flag.
It could be done as DDL statement of "create or replace synonym ..." placed in a procedure dedicated to set the DS_ONLINE_ACCESS_FLAG flag...
...but I'm not sure if it is going to work and even so
View 2 Replies
View Related
Oct 9, 2012
I trying to deploy contract management in the weblogic server 12c . using the ear file in the following location
C:Program FilesOracleContractManagement_1earexpedition.ear
When i click on next I get the series of error. Really I don't understand this What are these errors,
Unable to access the selected application.
Exception in AppMerge flows' progression
Exception in AppMerge flows' progression
Unable to resolve deadlock in factory claims
Unable to resolve deadlock in factory claims
View 2 Replies
View Related
Dec 3, 2010
Our oracle database has been running great. This past wendesday the application was unable to access a specific table. Sutting down and restarting the database seemed to have fixed the issue. Last night the database has been working since that restart on wednesday morning. Suddenly stopped working. We stopped and restarted the database again this time getting ORA-00600 error as shown below. We are able to make a connection to the database and can even access the tables in question. The application is complaining about the connection to the database. I understand that ORA-00600 is an internal error what I need to know is what the internal error code 549 actually is. I have tried googling to no avail.
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Dec 3 09:47:20 2010
Copyright © 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
ORA-00600: internal error code, arguments: [549], [], [], [], [], [], [], []
ORA-03113: end-of-file on communication channel
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
C:\Documents and Settings\tieoduser>sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Dec 3 09:49:31 2010
Copyright © 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.
[code]....
View 2 Replies
View Related
Mar 23, 2013
i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies
View Related
Oct 2, 2012
I actually have tried to read the Customizing Templates chapter of the Users Guide. According to that guide, the following substitution strings are supported in the the Error Template Control section of page templates.
#MESSAGE# and #ADDITIONAL_INFO# - Places the error message.
#TECHNICAL_INFO# - Displays detailed internal error information which will just be visible for developers.
#BACK_LINK# - Displays a link back to the previous page.
#OK# and #RETURN_TO_APPLICATION# - Returns to translated text strings.
However, if I enter the follow code
<p> message: #MESSAGE# </p>
<p> additional info: #ADDITIONAL_INFO# </p>
<p> techie stuff: #TECHNICAL_INFO# </p>
<p> back link: #BACK_LINK# </p>
[code]........
return to application: Return to application.
It appears that only the first substitution string is doing anything. I'm especially interested in additional info and technical info. The back_link just looks like an html snippet, not sure why I would use a substitution string for this. I imagine the last two could facilitate site translation, but that doesn't work much if there is no machinery for translating error messages themselves.
View 5 Replies
View Related
Jul 17, 2012
I have a shuttle control (P8_SHUTTLE) that lists then names from scott.emp.
Now I want to create a dynamic action that fires when I click on one of the names on the left side of the shuttle control.
I want the dynamic action to recognize the name of the employee that was clicked, and then set the value of a text item (P8_LAST_VALUE) to that ename. (Eventually I want to display the department of that employee in the other text item).
Here are screen shots of my DA:
[URL].....
Currently, when I click an item in the shuttle control, the text item P8_LAST_VALUE remains blank.
View 2 Replies
View Related
Mar 4, 2013
say i got 10 select list each with value yes or no
I need to fire a dynamic action so i have a variable which will show the count of select list selected which has been selected as yes or no...
How can i accomplish this is apex 4.2 db 11g ?
View 2 Replies
View Related
