Whenever I deploy a PSU patch I receive the prompt below. I'm attempting to deploy PSU in an automated fashion. How do I suppress the prompt? "Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no):"
View 0 RepliesI have deployed Oracle Forms6i Application on Web. Just added SSL to the Application server and works fine within the network. If accessed from outside the network getting the from-92050 error message.
Failed to connect to the server: Server.9000
Now im working on Oracle Forms 10G, and i do some simple modifications to the formsweb.cfg for using java instead jinit, this its useful if you need to run the application on another navigator different than IE. The problem its that i have updated the version of JRE i was working with 6u24, and updated to 6u25 IE cant do nothing with this and i cant deploy my working forms now because IE try to install the "plugin" and it fail.
I actually have an application running and configured for running on "production environment" this application run only on Opera navigator using this JRE.
So, its possible to tell Oracle Forms 10G that it must to run all forms on Opera when i deploy it, or there is some configuration file for do that?
We are running forms 11g ( 11.1.1.3) in our production environment and we are having strange issue when we are deploying the new version of fmx on fusion middleware server ( Windows 2008). After copying/replacing the new fmx we are still running the OLDER version of form. It's happening randomly on different servers.
View 3 Replies View Relatedi developed my system at my laptop and it works well...i installed a windows server 2008 at another pc (as a server for testing)..and i run the application on the other pc (windows server 2008) and it works well...
my Qs. is:
how can i run the application in other pc from my laptop...i make a configre on the other pc (as server pc), and i run the oc4j on it, the link is:[URL]...
but nothing happend (Internet Explorer cannot display the webpage)...
This is a sample query with only 6 columns but my actual query has about 70 columns. Basically I need to be able to suppress those rows where numerical values are zeros across a row. But even if one column has a value greater than zero, I need that row. I am just trying to avoid creating a big WHERE clause with all fields in there.
with my_table as (
Select 'A' as org, 12 as val_1, 13 as val_2, 14 as val_3, 40 as val_4, 100 as val_5 from dual
union all
Select 'b' as org, 12 as val_1, 13 as val_2, 14 as val_3, 40 as val_4, 100 as val_5 from dual
union all
Select 'c' as org, 12 as val_1, 13 as val_2, 14 as val_3, 40 as val_4, 100 as val_5 from dual
[Code]....
I want to Suppress the Dummy columns from the UNION Clause of Query.
SELECT
'HEADER' AS record_type
,null C2
,null C3
,null C4
,null C5
FROM dual
UNION ALL
SELECT empid
[code]....
Now I need to remove the all the Dummy fields associated to "HEADER" and "TRAILER" records.
In Oracle report, there is no duplicate rows I am seeing in the report output screen but getting duplicate rows in output file generated.
View 8 Replies View RelatedI've created a change event dynamic action which fetches a description from the database for a user-entered code. When this is run in Firefox, a swirling loading image is displayed next to the description.However, the loading image causes anything displayed its right to be moved out and then back again when it disappears. On a form with lots of dynamic actions this can be quite disconcerting so I'd like to stop it.
Can a dynamic action's loading image be suppressed?
APEX inserts the following HTML alongside the input field:
<span class="apex-loading-indicator"></span>One option is to apply "display: none;" to the "apex-loading-indicator" class but this could affect other loading images that use the same class.
Note: This affects Firefox (18) but not IE9
I wiuld like to suppress oracle messages conditionally. I am running oracle view creation scripts from command line, After successful view creation, it is showing me "view created" message. To suppress this, I have created following
set serveroutput on format wrapped;
SET TERMOUT OFF
@@test1.sql
SET TERMOUT ON
[Code]....
but still it is giving me "PL/SQL procedure successfully created" message along with "'View test831 created successfully". I need to suppress "PL/SQL procedure successfully created".
Is it possible to hide/suppress an user defined alert message in Oracle Forms application?
View 1 Replies View RelatedWhat is the function to prompt a user for a value when running a script and where would it be used?
I was also wondering if it is possible to populate a list from a table that would be displayed in a drop down box for the user to choose from?
I have a procedure with signature as proc_temp(deptno in number, empdetails out sys_refcursor);
how can i call this procedure from sql prompt.
I decided to uninstall oracle 10g, and APEX 4.0.
I then reinstalled oracle 10g express and downloaded APEX 3.2..
However, wen its time to upgrade to APEX3.2 via the command prompt... the previous version of APEX 4.0 (11.1.0.6.0) is being read.
how to reset this to the original value 10.2.0.10 (10g express edition) ?
I have created a text prompt in layout editor by clicking a button 'TEXT'('A' symbol) from left hand side toolbar,text is created with name 'TEXT67' and graphics type 'TEXT'.
when i click that text(TEXT67),block showing <null>.
So i cant use the below code,bcoz no block for that text..
SET_ITEM_PROPERTY('<BLOCK_NAME>.<TEXT_NAME>',PROMPT_TEXT,' ');
then i tried below,i.e i skip block name i gave only text name..
SET_ITEM_PROPERTY('TEXT67',PROMPT_TEXT,' ');
not working...
how to run dos command from sql prompt.
i.e.
SQL>!DIR
Same can be done in unix using ! character.
SQL>!ls -lrt
i want a procedure or any other way to change the prompt of a form with another nameand get the name from a table in database that table contain the old name ,, and the new name
i want to use this procedure to facilitate different language user to change the prompt of all item to the user language i have done one but it's not as good as i want i need it to work with a big sys with a lot of items and change all it;s prompt
all i have to do is to fill the table with the words only
I am getting the below error while deploying a workflow in Control Center.
ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException:
The file /u01/app/oracle/product/11.2.0.2/dbhome_1/owb/bin/admin/rtrepos.properties cannot be accessed or has not been properly created on the server XXXXXX. If the file does not exist or if the database owner (normally user 'oracle') does not have the required file permissions or if the file has not been properly created then the file can be recreated by running the SQL*Plus script /u01/app/ oracle/ product/11.2.0.2/dbhome_1/owb/ rtp/sql/ reset_ repository. sql (in a RAC environment the file must be manually copied to each server which is used for OWB). Otherwise if using a 10.2 database instance, then please run the SQL*Plus script /u01/app/oracle/product/11.2.0.2/dbhome_1/owb/UnifiedRepos/reset_owbcc_home.sql.
I am writing a query where I'd like to pull one year's worth of data. Ideally I want to prompt for the END DATE and have the query go back in time one year from that date.
Here is what I've got after doing some research online... but It's not quite working for me.
select *
from mrtcustomer.profile
where reg_type = 'B'
and contact_type = 0
and active_ind = 'Y'
[code].....
Text field prompt displays ? while using bengali language but text field displays value in bengali language when retrieve data from database.
I am using oracle 11g database in windows platform and oracle 10g application server release 2 in linux(rhel 4) platform. For client machine I am using windows xp and jre version 6 update 14
To do this I add following line into user bash profile in application server:
export NLS_LANG=AMERICAN_AMERICA.UTF8
I also edit oracle_home/forms/java/oracle/forms/registry/Registry.dat file as below:
...
....
#default.fontMap.defaultFontname=Dialog
default.fontMap.defaultFontname=SolaimanLipi
I am trying to get the TNS_ADMIN value but I m an not getting Expected Results . My tnsNames.Ora are located at the following locations : -
1) C:oracleproduct10.2.0client_1NETWORKADMIN
2) C:oraclexeapporacleproduct11.2.0server
NetworkADMIN
As you can see from the belowcode, TNS_ADMIN is not displaying the correct location.
C:>set TNS_ADMIN=%ORACLE_HOME%
etworkadmin
C:>echo %TNS_ADMIN%
%ORACLE_HOME%
etworkadmin
C:>echo %ORACLE_SID%
%ORACLE_SID%
C:>
I am able to start SQLPLUS from Start | Program files | Oracle - OraHome92 | Application development |
Unfortunately, when trying to start it from the "command prompt" window with the following command SQLPLUS, it generates the infamous error message like
"... unknown etc... "
Any variables i need to change on my client machine ?
I'm trying to hide the password for the batch programs that connect to the DB Server
as Cadot pointed out in
[URL].........
Quote:
use secure external password store
with reference to
[URL].........
when I create wallet, the system does not prompt me for password
C:>mkstore -wrl "C:ora102NETWORKADMIN" -create
when creating login credentials, again the system never prompts me for password
C:>mkstore -wrl "C:ora102NETWORKADMIN" -createCredential db10g scott tiger
here's my sqlnet.ora configurations
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY =C:ora102NETWORKADMIN)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSESSL_VERSION = 0
here's my tnsname.ora settings
DB10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mike)
)
)
here's the outcome
C:Documents and SettingsAdministrator>sqlplus /@db10g
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Apr 13 22:53:06 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-12534: TNS:operation not supported
Enter user-name:
so I Google around for the solution to the ORA-12534 error, one of the site,
[URL].......
here's my lsnrctl services
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "MIKEXDB" has 1 instance(s).
Instance "mike", status READY, has 1 handler(s) for this service...
Handler(s):
[code].....
The command completed successfully
right now I think I will be a fool to think that the solution is to resolve the ERROR: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. so what is wrong with my setup, or is it some patch that I need to apply?
I want to delete a backupset and get the flowing prompt,i want to delete it directly and no prompt,how can i do?
Do you really want to delete the above objects (enter YES or NO)? YES
RMAN> delete backupset tag 'TAG20120306T211654';
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
111 101 1 1 UNAVAILABLE DISK /u01/app/oracle/duplicate/al_t777244616_s111_p1
Do you really want to delete the above objects (enter YES or NO)? YES deleted backup piece
backup piece handle=/u01/app/oracle/duplicate/al_t777244616_s111_p1 recid=111 stamp=777244617 Deleted 1 objects
I want to disconnect and connect sql prompt in loop using script file.But whenever I try to do this it is giving error,check the below code.I save below code into some file and call that file using @"filename.sql", it won't work.
Basically I want to run one procedure in loop, and in each loop counter I want to disconnect the session and connect again. Becaue CONN and DISC not working while calling through @"..."
DECLARE
BEGIN
FOR N IN 1..5 LOOP
DISC
CONN SCOTT/TIGER@TEST;
EXEC MY_PROC;
END LOOP;
END;
is it possible to call the .rtf report through command prompt (ms dos), narrate the procedure.
View 1 Replies View RelatedWe have siebel server on windows machine and db server on unix box. We have done some modification(added columns) in siebel tools level. Now we want to ddl synch through command line prompt. how ot do ddl sync?
View 4 Replies View Relatednow DB is hanging; i am not able to connect both SQL and RMAN prompt. Is it possibel to move some old archives using ASMCMD prompt to datafile mount point location? Once i got some free space, then i can try connect RMAN and fire my script manually to take the backup and delete the same. ....
ASMCMD [+QSTAGE_T1_BACKUP_01/QSTAGE/ARCHIVELOG] > ls -ltr
cdType Redund Striped Time Sys Name
Y 2011_07_15/
Y 2011_07_16/
Y 2011_07_17/
Y 2011_07_18/
Y 2011_07_19/
Y 2011_07_20/
i have free space at mount point : +QSTAGE_T1_DATA_01/QSTAGE/DATAFILE
i need to backup the archives first before deletion..as those are required for Streams.
backup script:
run {
backup archivelog all delete completed before 'sysdate-1';
}
note: i would like to remove the file which are older than one day
I have a requirement in which i have list pdf files(from thousands of pdf files) having particular string from a command prompt.I have tried find command but that has some limitation. its working upto 3 digit string only.how can i acheive this.remember i have to do this through command prompt only.
View 1 Replies View RelatedI need to accept value for some variables using substitution variable. I have a number of variables for which I need to take the value on run time. I need to prompt a parameter based on the value provided earlier.
For example;
There is prompt to enter country. If the user enters country as India it should prompt for the state else it should not prompt for state.
How can this be handled in SQL?