i was trying to use the host command to run the commands from linux. however, it doesnt work.
PROCEDURE compile_procedure IS
c_success boolean;
c_bare_filename varchar2(50);
command_string varchar2(1000) ;
BEGIN
c_bare_filename := substr(:B_DEV.B_DEV_ITEM_FILENAME,instr(:B_DEV.B_DEV_ITEM_FILENAME,'',-1)+1);
[code]....
My database as well as application on linux. I want to execute this command on linux. I need equivalent code.
host('cmd /c E:data empITC1'.bat');
code of ITC1.bat is
echo off
sqlldr userid=user_name/pass@database control=E:data empITC1.ctl log=E:data emplogITC1.log
echo ........
control file as well as bat file exist in respective folders.
I am using the HOST command within Oracle Forms 10g on Windows server to copy a pdf file from the application server to a network folder on another Windows server.
The command works fine if I logon to Windows app server and type it. But it doesn't work when it is launched within Oracle forms using HOST. The command looks as follow
net use \\FileServer\e-file /user:usergroup\username password & copy D:\RepTmp\myReport.pdf \\FileServer\e-file\test\myReport.pdf
Oracle forms doesn't give any error message at all but the pdf file never gets there. Even when I map the network folder as "R:" drive on the Windows app server, a simple copy command like this does not work with HOST:
copy D:\RepTmp\myReport.pdf r:\test\myReport.pdf
Oracle Forms server is running as "SYSTEM" on the Windows server. If HOST won't work, is there any other way to copy the file other than using fpt?
I am facing one problem we used to copy any document and for open any document in WINDOWS
Host('CMD /C COPY '||'"'||:Old_Doc||'"'||' X:�3�3'||:New_Doc);
Client_Host('Cmd /C Start '||'X:�3�3'||:New_Doc);
But these commands not running in Linux.
I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow keys on my keyboard. This is quite easy when I am using a shell, but here with this Oracle command line interface it is not working at all. Here is the example as what actually is happening whe I press the up or down arrow keys.
SQL> drop table mailorders;
Table dropped.
SQL> ^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A
Am using Oracle 10g on redhat linux machine.
My Agent Connection to Instance is down . I am trying to start it up using EM when i enter my user name and password on host credentials connection fails (am using a suer that installed my oracle software).
How to get a RAC running in an EC2 environment?
It isn't possible to use one EC2 machine for each RAC node because EC2 can't handle the virtual IPs, but I had thought that I could use one EC2 machine to host several Linux VMs using Virtual Box (the same way that I use Virtual Box on a Windows host). But I can't get Virtual Box working on EC2. The only relevant advice I can find on this is comments to the effect that running any virtualization product with a Xen machine as host is not a good idea.
I do realize that this isn't a 100% Oracle question, but if set up a RAC on an Amazon Cloud machine,
my host os is win 7 ,,,,i install vm ware and install linux on vmware...now i want to ping linux from win 7...how i can do it... firwall is disable.
[root@lnxdb ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
#
Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth0
BOOTPROTO=none
HWADDR=00:0C:29:22:FC:FF
[code]...
i want to ping the guest os linux install on vmware to os win7 host ...how?
We are using host_command to run a batch file from database.
begin
host_command('start /min E:Deepakipacklatmailmailbatch.bat') ;
end;
The batch file contains
C:WINDOWSsystem32lat.exe -install x.com y@x.com
blat C:lat.log -to z@m.com -subject 'test' -attach "file" -body 'test' -u y@x.com -pw *****
we are sending mails using blat.exe.
The procedure is working and the mail is reaching destination.But the database is hanging.
let me know what is the reason behind hanging.
I've got a problem when I use the HOST procedure to work with DOS Prompt. When I access the DOS Prompt via Oracle Forms HOST Procedure, the name of files and folders got limited by 8 chars plus extension. Lets suppose I want to copy a file and the file name is my_image.jpg. What I have to do is:
HOST('copy MY_IMA~1 C:TEMPIMAGE01');
I guess it sucks cause the function GET_FILE_NAME give me the filename as my_image.jpg. Do I have to convert the filename every time?
I have configues Webutil in Application Server and i am using Client_host to open imageviewer .. but when running the form it gives me error "Orace. Forms.webuti.host bean not found Webuti_host.execute will not work" i have done the following configuration for webutil
File frmwebutil.jar
From folder: webutil_106webutil_106java To: $ORACLE_HOME/forms/java
File: jacob.jar
From folder: jacob_18 To: $ORACLE_HOME/forms/java
File: d2kwut60.dll, JNIsharedstubs.dll
From folder: webutil_106webutil_106webutil To: $ORACLE_HOME/forms/webutil
File: jacob.dll
From folder: jacob_18 To: $ORACLE_HOME/forms/webutil
[code]....
Configuring Database:
1. Connect as Scott or your User
2. Run the script $ORACLE_HOME/forms/create_webutil_db.sql using SQLPLUS or any tool.
Setting up Form Builder:
1. Open Form builder Connect with SCOTT and in PL/SQL libraries open Webutil.pll file
2. File > Save as and Rename the file to different name e.g WebUtil_lib
(Trust me it works to avoid Webutil not found error)
3. Compile the new PLL file and generate it
4. Attached the new named Webutil_lib.pll to your form with Remove Path option YES.
5. Open WebUtil.olb file Object group in builder and copy or subclass it into your form.
6. Now compile your form and run it.
I am new to linux OS i don't know how to install forms in linux.
the step step process of installation of forms 10g in linux OS.
We have a product in Oracle forms 10g running in Windows XP OS, we want to migrate this into Linux OS.
View 4 Replies View RelatedI am running forms 6i in Linux Mint environment. I used Go_Item('emp_cod') after commit on save button.
Code is as under:
IF NVL(:BAL_QTY,0) > 0 THEN
GO_ITEM('EMP_COD');
ELSE
GO_ITEM('OP_ID');
END IF;
Control moves in relevant item but there is no cursor indication and no data can be entered in this field. When I press TAB or ENTER key the code written on Key-Next-Item executes properly. It means that control moves to that item but nothing could be written in this. This form is working properly in Windows environment.
I bought Selftestsoftware for 1z0-147 for 9i and 10g. Selftestsoftware is endorsed by Oracle, should be high quality. But its below sample question and answer seem to be wrong, or I could not understand it properly. It says "Network traffic is not decreased by bundling commands. Executing procedures and functions stored in an Oracle Developer application will process each PL/SQL statement and pass each SQL statement across the network to the database to be processed, dramatically increasing network roundtrips."
But PLSQL online reference manual says "However, with PL/SQL, an entire block of statements (bundling commands?) can be sent to Oracle at one time."
Selftestsoftware says pass each sql statement, but PLSQL online manual says send an entire block of statements like below diagram. Now which one is right, or I misunderstood something?
(I cant post the diagram from PLSQL online manual because of my quota)
Procedures and functions can be created and stored in the database or in an Oracle Developer application. How is performance improved when storing procedures and functions in the database?
Network roundtrips are reduced.The object code is created during execution.Network traffic is decreased by bundling commands.The source code is stored externally, and the object code is stored internally.
Explanation:Network roundtrips are reduced when storing procedures and functions in the database. The source and object code of database stored procedures and functions are stored like other objects, in physical files assigned to the appropriate tablespace. When executed from a client application, they require only one call. Because the object code is stored on the database side, there is no need to send it across the network.The object code is not created during execution. The object code is created when creating the procedure or function and is stored in the database.Network traffic is not decreased by bundling commands. Executing procedures and functions stored in an Oracle Developer application will process each PL/SQL statement and pass each SQL statement across the network to the database to be processed, dramatically increasing network roundtrips.The source code is not stored externally. The source code and object code are stored in the database.
Can we perform DDL & DML Commands on dual table????
If yes then how??
I have configured and tested the webutil in Windows Operating System and worked perfect, Now i am trying to deploy customized form to EBS R12 that using webutil, and after making same configuration which has done before, i got compilation error.
Form is very simple(Just button with following pl/sql code)
show_webutil_information (TRUE);
Erro is: "FRM-40039: Cannot attach library WEBUTIL while opening form XXR12_DEMO.fmb"
webutil configuration steps on R12 or the error solution,
Is there a difference between the first set of commands and the second? Typically, I just use the first set?
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
DELETE NOPROMPT OBSOLETE;
and
CROSSCHECK ARCHIVELOG ALL completed before 'sysdate -30';
DELETE NOPROMPT OBSOLETE;
Before I am going to implement data guard in my company i am experimenting it in a test server. I want to know the difference between these 2 commands mentioned below which i found from various websites.
[ START REDO APPLY ]
SQL> alter database recover managed standby database disconnect;
[ START REDO APPLY USING REAL-TIME APPLY ]
SQL> alter database recover managed standby database using current logfile disconnect;
Which of the two commands should i use in my production database.
We are planning to migrate the forms application from windows to linux.
View 1 Replies View RelatedI'm trying to migrate our forms application from a Linux platform to Windows 7. We have a common pll which is attached to all forms and unfortunately relies heavily on globals.
Attempting to run the application with the standard library attached to the login form has the effect that the globals are lost between the login form and subsequent forms. If I incorporate the library code directly into the login form, it functions correctly. If I use the debugger to track where the clearing occurs, it functions correctly.
Migration of oracle forms 10g 32 bit windows platform to 11g 64bit Linux platform . I have about 500 fmb on my 10g environment which are currently working fine but when i go to compile it on 11g an error file is generated. All my path is set in proper manner .
I have a object library which has multiple tabs and every tab has its own object. While compiling, the forms are not inheriting the object values only few values from the object are considered.
what could be the reason that following 2 (RMAN) commands return different results?
RMAN> list archivelog all completed before 'sysdate-2';
RMAN> list archivelog until time 'SYSDATE-2';
In SQL plus
<SQL>
i need to repeat last six or seven commands instead of typeing
is there any command to using arrow keys o backward and forward last typing comamnds
i know / to execute last command
how to do that in SQL plus.
I am trying to trouleshoot an issue with Oracle and want to see what commands are being sent by by process. By reading the documentation it appears there is client logging to do this but I can not get it to work. I added the following commands to my SQLNET.ORA file but no log file is created:
tnsping.trace_directory = C:appproduct11.2.0client_4
etwork race
tnsping.trace_level = admin
trace_level_client = user
trace_directory_client = C:log
log_directory_client = C:log
trace_unique_client = on
trace_timestamp_client = on
Ths TNSPING works just fine it logs the information I expect. The client logging, however, never creates a file .
we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?
View 3 Replies View RelatedI have a PLSQL script.
sqlplus
$DB_ACCT << EOSQL
set heading off
set termout off
set pagesize 0
[code]....
My output in FILE.txt looks like this
SQL>
SQL> Select col_with_a||col_with_b||col_with_c from
2 alphabet_table;
abc
[code]....
I tried several options by putting set echo off, etc.What do I include in the sql script to get the output as :
abc
abc
abc
without the SQL prompt and the statement, and the spool off command?
which commands only we can use in database mount mode?
View 7 Replies View RelatedI would like to use Dbms_Schedule to call SqlPlus script in Linux .
BEGIN
sys.Dbms_Scheduler.Create_Job (
job_name => 'TEST_SQL_JOB',
[Code]....
This is giving me the error: ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory
BUT when I issue the command: /usr/local/bin/sqlplus -s s/ibs @/usr2/dms/run/lkp_sql_test.sql
it works fine.
I'm trying to apply a patch using opatch but I'm getting this error:
"OPatch was not able to find OUI jars to load them runtime. Please provide valid oui location using 'oui_loc' option. OPatch failed with error code 255".
Oracle is 11.2.0.3 x64 on Windows Server 2008R2 x64. The PATH variable have
%ORACLE_HOME%OPatch, %ORACLE_HOME%OPatchjlib, %ORACLE_HOME%in in it.
The only OPatch command that is working and not throwing the error is the "opatch version" command.
OPatch Version: 11.2.0.3.5 OPatch succeeded.
No luck on finding issue resolution or documentation on MOS. I cannot find any documentation about the "oui_loc" option.