I am working on web services. im getting soap response and i need it to be, created as xls file.i have used DBMS_XSLPROCESSOR.CLOB2FILE it throws error while opening in excel. Is there any other way.
View 5 RepliesHow do i get a response from a soap webservice and insert it into a DB
View 0 Replies View RelatedHow can i set db home name at the time of installation of oracle 11.2.O.3 .
View 3 Replies View RelatedWe are going to upgrade our Oracle client on our clients to 11.2.0.3. But I can not record a resopnsfile with setup.exe. Have Oracle removed this feature?
Here's a dump from setup.exe
There is no possibility to run setup.exe witch -record -destinationfile option:
Preparing to launch Oracle Universal Installer from C:UsersTestAppDataLocal
TempOraInstall2013-01-14_02-12-48PM. Please wait ... Usage:
setup [-options] [(<CommandLineVariable=Value>)*]
Where options include:
-clusterware oracle.crs,<crs version>
Version of Cluster ready services installed.
-crsLocation <Path>
Used only for cluster installs, specifies the path to the crs home locat ion. Specifying this overrides CRS information obtained from central inventory.
-invPtrLoc <full path of oraInst.loc>
Unix only. To point to a different inventory location. The orainst.loc f
ile contains:
inventory_loc=<location of central inventory>
inst_group=<>
-jreLoc <location>
Path where Java Runtime Environment is installed. OUI cannot be run with out it.
-logLevel <level>
To filter log messages that have a lesser priority level than <level>. V alid options are: severe, warning, info, config, fine, finer, finest, basic, gen eral, detailed, trace. The use of basic, general, detailed, trace is deprecated.
-paramFile <location of file>
Specify location of oraparam.ini file to be used by OUI.
-responseFile <Path>
Specifies the response file and path to use.
-attachHome
For attaching homes to the OUI inventory.
-cfs
Indicates that the Oracle home specified is on cluster file system (shared). This is mandatory when '-local' is specified so that Oracle Universal Installer can register the home appropriately into the inventory.
[code]....
Session/Installer variables are specified using:
[session:]varName=value
Ex 1: session:ORACLE_HOME_NAME="OraHome"
Ex 2: ORACLE_HOME_NAME="OraHome"
The lookup order is session:varName then just varName. The session prefix is
used to avoid ambiguity.
Component variables are specified using:
[compInternalName:[Version:]]varName
Ex 1: oracle.comp1:1.0.1:varName="VarValue"
Ex 2: oracle.comp1:varName="VarValue"
The lookup order is compInternalName:Version:varName, then compInternalName:
varName, then just varName.
I am trying to call a Web service using the SOAP API and I get the following error.
ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side
ORA-06512: at "SYS.XMLTYPE", line 48
ORA-06512: at "MyConnection.SOAP_API", line 121
ORA-06512: at "MyConnection.MyFunction", line 28
31020. 00000 - "The operation is not allowed, Reason: %s"
*Cause: The operation attempted is not allowed
*Action: See reason and change to a valid operation.
However we do have another procedure that is able to make an HTTP call successfully within the same domain. Hence the ACLs that are required are for making an HTTP call are in place. Is there any other security setting to be tweaked to make the to enable me to make a Webservice call using the SOAP package?
get me an example where i create a XML file from a xsd file?
View 1 Replies View RelatedWe are using oracle 10.2.0.3.0 version on HP-UX B.11.23 U ia64.
We are facing a lot of delay in TNS ping reply. It is taking 8000+ msec.
$ tnsping XXXXXX 20
TNS Ping Utility for HPUX: Version 10.2.0.3.0 - Production on 27-FEB-2013 12:37:15
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
$ORACLE_HOME/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx)(PORT = 1531))) (CONNECT_DATA = (SERVICE_NAME = xxxxxxx)))
OK (1250 msec)
OK (1150 msec)
OK (860 msec)
OK (860 msec)
OK (790 msec)
OK (810 msec)
OK (790 msec)
OK (570 msec)
OK (650 msec)
OK (630 msec)
OK (790 msec)
OK (1240 msec)
OK (1090 msec)
OK (1030 msec)
OK (870 msec)
OK (690 msec)
OK (740 msec)
OK (650 msec)
OK (490 msec)
OK (560 msec)
$
I'm trying to install 2 nodes oracle RAC 11gR2 on SLES11. I configured DNS for public,virtual, private and scan IPs. when I check with nslookup, everything seems ok. but when I run runcluvfy.sh, it says that:
" PRVF-5636 : The DNS response time for an unreachable node exceeded 15000 ms on following nodes: rac1,rac2"
How can I decrease the response time?
I need to extract tag values from REST web service response.
Webservice response
Quote:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <LicenseDetailsRes xmlns="com:*******services:LicenseDetailsRes">
<ResponseCode>LD001 - SUCCESS</ResponseCode>
<OrderNumber>51663852</OrderNumber>
<LineNumber>8</LineNumber>
<quantity>0</quantity>
</LicenseDetailsRes>
I am storing above response in a table column 'output_xm' of xmltype datatype.
My requirement is to extract 'ResponseCode' & 'quantity' values from above response. For which I am using below query but it's not working.
SELECT x.order_number
,x.line_number
,x.tnc_pid
,EXTRACT (VALUE (d), 'LicenseDetailsRes/ResponseCode/text()').getstringval () status
,EXTRACT (VALUE (d), 'LicenseDetailsRes/quantity/text()').getstringval () pak_quantity
FROM xxcfi.xxcfi_vt_tnc_pak_details x
,TABLE (XMLSEQUENCE (EXTRACT (x.output_xml, '/LicenseDetailsRes'))) d
WHERE x.order_number = 50403901
AND x.line_number = 2
AND x.tnc_pid = 'R-LMS-4.0-100-K9';
customer have a monitoring system that execute a script to check response time db (9i database).
The script do the following steps:
- Date
- select count(*) from all_tables
- select count(*) from v$lock
- Date
And then calculate the gap from end and start date, this is the response time.So, response time change from db to db depending on number of tables.
Is there any different method or different object to use?
I am working on 10.2.0.4 oracle version database of my production,
when executed a simple drop command , the total time it took is 26 secs. on Avg. the table is holding only 20 records. this is happening for the last few weeks , prior to that it took less than 0 secs.
05:22:58 SQL> drop table C$_100GL_INTERFACE ;
Table dropped.
Elapsed: 00:00:26.67
but on successive executions the elapsed time falls to 10-15secs.
And on the same test env, we are achieving the expected results less than 0 secs.
My SQL Response Time is more ttan 100% and keeps on increasing. How can I fix this? The Application users are complaining that the system is very slow.
View 2 Replies View RelatedHow do you Display Response time in HTML? I want to run a PHP script that displays the oracle response time in an HTML table.
View 1 Replies View RelatedI need to create a DB on a pc with 4GB (RAM). I can use the assistant but where I need to set correctly a value related to the memory? Is it necessary to set values for best performances in response time?
View 2 Replies View RelatedI have a lot of problems in parsing SOAP web service response of Jasper The major problem is that the report document in the response appears at the end of the response. It appears even after the closing tag of the soap response. The images in the response are returned in binary form.
Because the response is partially binary and partially characters so I am not able to parse it correctly. If i make a web service call using APEX webservice references and then put the response in a collection then I get an error. I guess APEX collections are not able to handle this response. I say this because If I call the webservice using UTL_HTTP, then I get the response.
parsed a Jasper SOAP web service response which has a report in it.I have gone through h[URL]..but I am not using it.My question is focused on parsing the response and not on finding other ways of getting it
I need to write a script which will do tnsping to all the 6000 oracle databases my client have and I need to record the response of it for each database. What will be the best option to use with tnsping? SID of these databases or net_service_name?
View 5 Replies View RelatedAs per project requirement, we need to create tab seeprated file for a table. This table contain around 1000000 records.I have written below sql
set pagesize 10000
set feedback OFF
set serveroutput on
set heading OFF
spool D:OfficeworkDatabase_maintainceMATRIX.txt
[code]...
This query is taking more than 6 hours.if there any other way how can we create tab separated file. Or we can export the entire table in tab separated file format.
I have connected to the database and am logged in with SQLPLus and have the SQL prompt.
I need to run a query and would like to create a file 'x.sql' and type the query into that file, save it then run it.
What should be our approach when we see the disk response time is bad for a particular tablespace in database.I heard a good disk response time should be on an average 10ms.
View 2 Replies View RelatedWhat are all the necessary steps in running a Windows OS .bat when a metric threshold has been tripped? Currently have a fully qualified path (C:scriptsRunthis.bat) entered in the Response Action column but no action is taken when threshold is reached.
View 5 Replies View RelatedI have two questions:
1. Our business users had a requirement to approve or reject the Workflow Notification Emails form their Email account on MS Outlook Express. When they perform action from MS Outlook Express it sends email to wfmailer but no action perform in application. The notification inbox in application shows this notification as OPEN notification and the requested function also shows 'Waiting for Approval'.
2. I need to hide Request Information button/link from the email notification send through Workflow mailer to user. There are three actions button available in email notification Approve, Reject and Request Information. I need to have only two button Approve and Reject. How to hide Request Information button.
i get while getting a report in ASP..
Error like this
Error Code 1460: Timeout
Background: The gateway could not receive a timely response from the website you are trying to access, a DNS server, or another gateway server. This might indicate that the network is congested or that the website is experiencing technical difficulties.
I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint and it worked when executed from
sql*plus or pl/sql developer.
It returns results in 3 seconds or even less. However, when i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins!
i need to consume web services within my apex Apps, i tried sample app from here: URL....it worked, but response time is about 15 seconds, then i tried another with Google Geocode APIURL.... and again time is 15-16 seconds. It's normal response time from Apex Web Services or is there something to do.
View 0 Replies View RelatedBy mistakenly Oradata file has been deleted and there is I have not any backup when we Startup the database then we get an Error as
ORA-00205: error in identifying control file, check alert log for more info
Now I want to create controlfile as
Microsoft Windows [Version 6.1.7600]
Copyright © 2009 Microsoft Corporation. All rights reserved.
C:\Users\SARASWATIMAA>SQLPLUS
SQL*Plus: Release 10.2.0.1.0 - Production on Sun Apr 8 23:15:09 2012
Copyright © 1982, 2005, Oracle. All rights reserved.
Enter user-name: SYS AS SYSDBA
Enter password:
[code]...
where is My Mistake in Creating Cotrolfile..I want to know that in which condition we use "SET" or "REUSE" in Create Controlfile.
I'm having some trouble dealing with the PL/SQL coding. At the moment, I have a file (set of data) that is read using java. An array is created (line by line) and is passed into a temp. table, which is then called by the plsql (call PKG_xxx.PRC_xxx...) script/command for processing. Is there any way I could directly get the file loaded into plsql (into a temp. table maybe?)
The data are just numbers and letters. I already got the PL/SQL part to select the set I want for different cases. All I need is to get the file (directly or indirectly) for the procedure without going through java.
I want to create a excel report by joining 2 tables.
Is there any stabdard package which i can use for creating this report.
I want to use UTL_FILE package to create OS file. How to resolve this error. Oracle11g under XP.
SQL> create directory my_dir as 'c: emp';
Directory created.
1 create or replace procedure test_1(md in varchar2)
2 is
3 file utl_file.file_type;
4 begin
5 file := utl_file.fopen(md,'abc.log','w');
6 utl_file.put_line(file,'EMPLOYE REPORT');
7 utl_file.fclose(file);
8* end;
SQL> /
Procedure created.
SQL> execute test_1('MY_DIR');
BEGIN test_1('MY_DIR'); END;
RROR at line 1:
RA-06510: PL/SQL: unhandled user-defined exception
RA-06512: at "SYS.UTL_FILE", line 98
RA-06512: at "SYS.UTL_FILE", line 157
RA-06512: at "SCOTT.TEST_1", line 5
RA-06512: at line 1
I wish to run a SQL query and measure elapsed time, then compare the values to other Oracle DBs from other companies. That will give me a feeling if our DB performs well.For example in UNIX world, you can create a random 4GB file to measure throughput I/O and compare the values (for example 4MB/sec).
What's the simplest way to compare DB response time from forum members to our own DB? I don't need 100% accurate numbers.
problem with oracle 10 g . i started service through server i got some error
ora-09925 unable to create audit trail file.
3 files are missing in admin folder these are three files adump, dpdump, pfile was missing i have not taken any backup also.
in admin file also the database folder name was missing.