Forms :: Using Host Command To Run Commands From Linux?

Jul 6, 2010

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]....

View 4 Replies


ADVERTISEMENT

Forms :: Host Common On Linux

Oct 27, 2010

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.

View 9 Replies View Related

Forms Host Command Cannot Copy To Network Drive

Oct 3, 2013

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?

View 1 Replies View Related

Forms :: Copy And Open Command In Oracle 10g Linux (Minut / Ubuntu)?

Jun 23, 2010

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.

View 12 Replies View Related

SQL Plus Command Line - Arrow Keys Not Giving Previous Commands Back

Mar 28, 2007

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

View 2 Replies View Related

Enterprise Manager Host Credentials On Linux

May 10, 2011

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).

View 1 Replies View Related

RAC & Failsafe :: Using One EC2 Machine To Host Several Linux VMs Using Virtual Box

Dec 22, 2010

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,

View 1 Replies View Related

Server Administration :: Not Ping Linux Install On Vmware From Host Os Win 7?

Sep 12, 2012

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?

View -1 Replies View Related

SQL & PL/SQL :: Host Command - Sending Mails / Database Hanging

May 30, 2011

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.

View 19 Replies View Related

Forms :: Host Procedure On 6i?

Dec 28, 2009

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?

View 15 Replies View Related

Forms :: WebUtil Host Bean Not Found

Jul 22, 2010

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.

View 2 Replies View Related

Forms :: Installation In Linux OS?

Sep 29, 2010

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.

View 1 Replies View Related

Forms :: Windows To Linux Migration

Jan 19, 2010

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 Related

Forms :: Go_Item OS Linux Mint

May 18, 2010

I 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.

View 3 Replies View Related

SQL & PL/SQL :: Bundle Commands Sent At One Time?

Jun 8, 2010

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.

View 3 Replies View Related

PL/SQL :: DDL And DML Commands On Dual Table

Feb 8, 2013

Can we perform DDL & DML Commands on dual table????

If yes then how??

View 11 Replies View Related

Forms :: Configured Webutil For OAS On Oracle EBS R12 Linux 64?

May 1, 2010

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,

View 1 Replies View Related

Backup & Recovery :: Difference Between First Set Of Commands And The Second?

Dec 7, 2011

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;

View 2 Replies View Related

Data Guard - Difference Between 2 Commands?

Mar 6, 2012

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.

View 1 Replies View Related

Forms :: Migrating Oracle 10gr2 From Windows To Linux

Feb 10, 2010

We are planning to migrate the forms application from windows to linux.

View 1 Replies View Related

Forms :: Migrate Application From Linux Platform To Windows 7?

Oct 17, 2010

I'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.

View 2 Replies View Related

Forms :: Migration From Oracle 10g 32 Bit Windows To 11g Linux Platform

Oct 25, 2013

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.

View 5 Replies View Related

Backup & Recovery :: Difference Between 2 RMAN Commands

Nov 2, 2012

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';

View 1 Replies View Related

Client Tools :: Repeat Last Series Commands In SQL PLUS

Aug 8, 2007

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.

View 5 Replies View Related

Windows :: Client Logging - See What Commands Are Being Sent By Process?

Nov 4, 2011

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 .

View 2 Replies View Related

Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)

Sep 13, 2013

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 Related

Client Tools :: Spool Without SQL Statement And Commands In PLSQL?

Jan 3, 2011

I 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?

View 2 Replies View Related

Server Administration :: Which Commands Only Can Use In Database Mount Mode

May 3, 2011

which commands only we can use in database mount mode?

View 7 Replies View Related

PL/SQL :: Calling Dbms_Scheduler From Forms Trigger To Invoke SqlPlus Script In Linux

Mar 25, 2013

I 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.

View 4 Replies View Related

OPatch Commands Are Failing With Error Code 255 And Not Able To Find OUI Jars

Aug 21, 2013

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. 

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved