How can in increase the allocated space for a schema in Apex Admin section?
I know you can set this when creating a schema alongsite a workspace and looks like the only way to do it is via raising a service request for more space and loggin in as ADMIN and approving it (in increments of 500MB).
User clicks on link-column field in tablular form, Confirm box pops up with a confirmation message, with "OK" generates a request and should pass a value from the form into an item for further processing.
The URL in the column link as of now looks like that: javascript: apex.confirm("message goes here...", {request:"EQDONE", set:{"P2100_X": "#EQMID#"}});For some reason just nothing happens. When I omit the "javascript:", I get an unvalid-url error message. But if I change the procedure name, shoudln't I get some error message also?
I use the procedure gReport.navigate.paginate. If there is the possibility to set a value to REQUEST when calling this procedure?
View 7 Replies View RelatedWe are getting the following error when trying to access a RESTful web service coming from Apex workspace 4.2.1 and Apex listener 2.1:
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-29024: Certificate validation failure
In the Debug report, besides the above I also see:
error_backtrace: ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 543 ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 1164 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 396
We get that error whether we use https or http in the URI pointing to the web service. When I test the Web Service in Workspace RESTful service GUI, I get the data back. When I go build an application with a report calling the RESTful Web Service I get that error. Both the Application and the Workspace RESTful services are on the same Apex environment and even the same workspace.
What is odd is that I can actually put the URL of the web service into a browser and I get the data: (using the demo hr data in sample RESTful services.)IN browser-- [URL]
yields:
7839,KING,PRESIDENT,,1981-11-17T05:00:00Z,5000,,10 7698,BLAKE,MANAGER,7839,1981-05-01T04:00:00Z,2850,,30 7782,CLARK,MANAGER,7839,1981-06-09T04:00:00Z,2450,,10 7566,JONES,MANAGER,7839,1981-04-02T05:00:00Z,2975,,20 7788,SCOTT,ANALYST,7566,1982-12-09T05:00:00Z,3000,,20 7902,FORD,ANALYST,7566,1981-12-03T05:00:00Z,3000,,20 7369,SMITH,CLERK,7902,1980-12-17T05:00:00Z,800,,20 7499,ALLEN,SALESMAN,7698,1981-02-20T05:00:00Z,1600,300,30 7521,WARD,SALESMAN,7698,1981-02-22T05:00:00Z,1250,500,30 7654,MARTIN,SALESMAN,7698,1981-09-28T04:00:00Z,1250,1400,30 7844,TURNER,SALESMAN,7698,1981-09-08T04:00:00Z,1500,0,30 7876,ADAMS,CLERK,7788,1983-01-12T05:00:00Z,1100,,20 7900,JAMES,CLERK,7698,1981-12-03T05:00:00Z,950,,30 7934,MILLER,CLERK,7782,1982-01-23T05:00:00Z,1300,,10
what would be causing the Error above in our application?
In reviewing the above error, I think we are realizing that we have to have the Weblogic layer SSL cert (actually the CERT from our BigIP load balancer which also does our SSL termination) imported into the Oracle server wallet where Apex is installed. Am I correct?
How to increase ASM DATA free size? I tried deleting expired backups and old archive logs which are backed up more than one time. Still no success ..
View 1 Replies View RelatedI had created a Primary key and wanted to compress as per my senior instructions.Below are my results the size increased after compression.
select compression from dba_indexes where index_name = 'TEST_IDX';
Compression
----------
DISABLED
select sum(blocks) no_of_blocks, (sum(blocks)*8192)/(1024*1024)size_MB
[code]....
We ran a compression on the primary key index TEST_IDX
ALTER INDEX SCOTT.TEST_IDX REBUILD INITRANS 15 TABLESPACE DATA_01 COMPRESS;
ANALYZE INDEX SCOTT.TEST_IDX VALIDATE STRUCTURE;
Now when i ran the below select statement:
select compression from dba_indexes where index_name = 'TEST_IDX';
Compression
----------
ENABLED
select sum(blocks) no_of_blocks, (sum(blocks)*8192)/(1024*1024)size_MB
[code]....
As you can see after compression the blocks and size has been increased, but i ran for many tables and other indexes, we observed the blocks and size was reduced by 50-70%, i am not sure why this happened to the index compression.
1.2.0.2 on RHL.. 3 Log Groups with 1 member each. db_recovery_file_dest string /oracle/oraarch For the purpose of increasing log file size, if i use ALTER DATABASE ADD LOGFILE GROUP 1 SIZE 300M; but it creates Log Group with 2 member. one is at /oracle/oraarch location and other at /oracle/oradata (db_create_file_dest).
We are using ORACLE MANAGED FILE SYSEM . I want only 1 member at /oracle/oraarch (to keep the previous setting intact ...just increasing the size from 100 to 300M). If I manually give the path where to create the logfile member, I get this error:
ALTER DATABASE ADD LOGFILE GROUP 1 '/oracle/oraarch/DB/onlinelog/' SIZE 300M;
ALTER DATABASE ADD LOGFILE GROUP 1 '/oracle/oraarch/DB/onlinelog/' SIZE 300M
*
ERROR at line 1:
ORA-00301: error in adding log file '/oracle/oraarch/DB/onlinelog/' - file cannot be created
ORA-27038: created file already exists
Additional information: 1
I want to increase the size of the tablespace but when i login as sysdba or admin user i can just see the 21 tables in the dba_tablespaces or user_tablespaces. I want to see the tablespaces related to the application.
View 8 Replies View RelatedMy listener.trc file has grown to a size of 56G and is contineously growing with the following message:
9:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:669] naeshow: [05-DEC-2012 19:56:49:670] naeshow: [05-DEC-2012
[code]...
The size of redolog member is 12m . Can I increase the size of that member dynamically, without adding a new member to that group and dropping the old one.
View 8 Replies View RelatedWe have an application with many separate databases (one per customer). Given they share the same business requirements (service hours, change mgmt etc), we're interested in potentially consolidating the separate DBs (which are relatively small) into separate schemas within a fewer no of databases to reduce the overhead.
Our issue is that the application is hard-coded to use a specific administrator and application connection user name. Changing this is unfortunately not an option.
Given this limitation, is there any possibility to map a generic user into a customer-specific schema based on the database service that they connect to? Each customer connects to different database services but may use the same user name. We considered using private synonyms but this seems to acheive the opposite (i.e. many different users could connect and map to a single users schema). One thing to point out is that where there is a single user name, it is acceptable for a single password to be used across the different customer DBs as they will be a single admin/user.
Steps to Refresh test Oracle 9i schema from production schema on a Windows platform..
View 3 Replies View RelatedI am trying to figure out a way to call EDQ (enterprise Data Quality) web service from APEX ?
View 6 Replies View RelatedI want to upload file using restful service This is my code to send file to rest service
MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);
[code]...
But how can i retrive at server side in restful service using plsql?
How to integrate Google geocoding as RESTful service introduced by APEX 4.2? my supervisor wanted to use RESTful service for geocoding function. While I am using Google geocoding through simple HTTP request. I even do not know whether I am using SOAP or RESTful with PL/SQL utl_http.request.
View 0 Replies View Relatedi am using the Simple checkBox Plug-in from Plugins Repository. I am having the situation that i need to Display the Label of the checkbox in one line, after the check box symbol.
Up to now, i have managed to display the label, but it have leading space which i do not need and after the label, i am trying to put a Select List control, which i can't display just after it.Here is a picture of what i have achieved up to now: URL....
Here are my settings for the 1st item: URL....
Here are my settings for the 2nd item: URL....
The template for Page is: One Level Tabs - No Sidebar and the template of region is : Form Region / Above Content. The Regions are in Position: Page Template Body (3).I am using APEX 4.2.1.00.08 and Oracle EE Database 11.2.0.0.3 under Windows 7 64 bit Pro.
I have an application that uses theme 2. On one page I have several regions that display updateable items populated with SQL. One particular region shows a tabular report that contains a combination of updateable and non-updateable items. This region will show no more than 15 rows. In one case I know that 22 rows should show. The pagination links do nothing. That is, nothing happens when I click the NEXT link or select the next X of Y from a list. I saw a theme for an application can restrict page size.
View 6 Replies View Relatedhow to decrease the size for list manager
View 0 Replies View RelatedI am using apex 4.1. I have this interactive report and i would like to make the text inside the report bigger and bolder. I have seen different examples of using css but none have worked for me. If you have any other way to do this or can give me a detailed way of using css!
View 4 Replies View Relatedhow to change the font size for an item of type display only ?
View 4 Replies View RelatedI have an instruction like this in a pluggin: begin ...
htp.p('<font size="3" color="FireBrick">
Cannot find? Search on </font>' || '<
[URL]....
<font size="4" color="FireBrick"><b>Google</b></a>'); ...
end;
It displys the Google page in another window. How can size the wiindow? For example adding width=200, height=100 to the href tag doesn't work.... Do I need to use JavaSvript?If yes, any example?.
I had a situation last year where I could not login as myself or see any objects in my schema. Some code using APEX methods to create a new APEX user, and it finally worked.
The new user, ADMINUSERS suddenly had its password expire and I could not reset it, so I repeated last years’ effort but this time nothing worked.
Now I have a problem where I cannot even read a table if it is in another schema, even if I use the schema name as a qualifier. This happens even in SQL plus, except when I login as System I can read tables in other schemas if I prefix the table name with the schema and a dot. But this does not work with other users, even though I have granted the other users the role of dba.
I was just asked by one of the sysadmins what the typical size of an oracle database install plus service pack be?
View 1 Replies View RelatedI have created a workspace to use oracle apex, after a while I tried to run a script, the following message has been displayed to me, The script output reached the maximum workspace result size limit. Delete existing results or contact your administrator to increase the maximum workspace result size.
View 3 Replies View Relatedwe got more that 50 apex apps, Deploying it through apex console is becoming pain.we won't get sys or schema passwords. etc as databases are controlled by DBA's, We only get apex_public_user password, internal, workspace admin passwords.If there is any need of schema association for any applications/workspace, We login to internal workspace and map schema to workspace. I read couple of blogs which discussed about automating the deployments through sqlplusconnecting as sys or schema user, will not work for us. Want to know if there is anyway I can import deployments without logging into workspace. We already have workspaces and applications. The deployments will be for updating existing application or deploying new application in existing workspaces. Oracle Application Express 4.1.
View 1 Replies View RelatedI am using SSO login for Authorizations. Would like make use of SSO for creating authentication schema. My main requirement is to assign privilege based on users using SSO loging.
View 0 Replies View Related1 declare
2 cursor c1 is select * from emp where deptno=&no;
3 begin
4 for i in c1 loop
5 dbms_output.put_line(i.empno||' ' || i.sal);
[code]...
PL/SQL procedure successfully completed.
SQL> /
Enter value for no: 120
old 2: cursor c1 is select * from emp where deptno=&no;
new 2: cursor c1 is select * from emp where deptno=120;
PL/SQL procedure successfully completed.
Even though deptno 120 is not there in emp table, the exception is not raising?
Our product uses Oracle11gR1 and in new release we are going to use Oracle11gR2. For this we are performing following steps:
(1) Install Oracle11gR2 on a machine where our product (Oracle11gR1) is already installed.
(2)Upgrade Oracle11gR1 schema to Oracle11gR2.
(3)For using upgraded schema in our product installer we create clone of upgraded schema.
(4)For creating clone we are using Oracle11gR2 DBCA utility.
(5) Clone files are successfully created (DBC, CTL, DBF).
Now we performed same steps from another machine and DBF file size changed very much. On one machine it was 89 MB and on second machine it was 150 MB. There is no different in schema and both machines are Windows 7 machines.
Tor educe size of schema we tried different space reclamation commands but size is not changing.
I'm taking export dump using expdp of some schema's of total size is 300GB. This is the par file:
DIRECTORY=expdp
FILESIZE=32212254720
DUMPFILE=expdp_schema01.dmp,expdp_schema02.dmp,expdp_schema03.dmp,expdp_schema04.dmp,expdp_schema05.dmp,expdp_schema06.dmp,expdp_sche ma07.dmp,expdp_schema08.dmp,expdp_schema09.dmp,expdp_schema10.dmp,expdp_schema11.dmp,expdp_schema12.dmp,expdp_schema13.d
[code]....
here one biggest schema size is 250GB and the total size of all the schema's is 300GB. The file where am taking the dump has 350GB space but even then the expdp failed saying
ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes
why it failed and how to restart it and make sure it runs successfully without error.
how would we learn creating workspaces on the production server for application services:
* Folder structure
* How client workspaces are sharing other common folders, tomcat, java, software release etc
* Scripts tomcat and create54workspace
