Is it possible to communicate with a serial device (via COM1) with oracle forms / webutil? I am able to communicate in java using RXTXcomm, but I am having problems making a bean that uses it (getting security errors and yes, I have signed the jars).
Basically, I have a scale hooked up to my COM1 port and want to be able to send commands (zero and tare) to it and read the weight from it through a form or java bean.
I want to connect a biometric device with my system, through serial port / parallel port. And want to permit only valid users to the system.
View 18 Replies View RelatedI am working on 10g. I have to capture and retrive thumb impression through biometric device on forms. And then store it in database.
Already working in VB . I have its jar files also.
I have one PDA device. I need to run a Oracle form developed in Oracle forms 6i on this PDA by connecting it to the Oracle 10G database running on Linux Server.
I need to know is there any Oracle client for windows 6.0 OS. if yes then how can i install it on PDA and access the Oracle database through forms.
I want to send sms to the mobile using Oracle form 6i.
View 8 Replies View Relatedi finished from design and programming the program how can Connect this program on more than one device
View 7 Replies View Relatedhow do you generate serial numbers? i have an invoice where i have to add items, so i want the numbering to start from 1 everytime i start a new form and increment by 1 as i i enter a new record. For this i have put my code in when-new-record-instance but problem is if i delete a record and enter a new one, the serial number starts from the nex number.
For ex. if i have 4 items with serial numbers 1, 2, 3, 4 and i delete the item at no. 3 and add a new item , the serial number comes as 5.
proper code to generate the serial numbers?
how I can send a message from Oracle Forms 10g to a Lantronix terminal server? It is a TCP/IP front end to a serial port controlling a warehouse carousel. We want to send a command string to a ip_address:port_number in raw mode. We have tested it using a telnet session. I develop in PL/SQL, just never used forms.
View 2 Replies View Relatedthrough oracle forms 10g how can i send a text message to a GSM mobile device...
View 2 Replies View Relatedi want to get serial numbers in oracle forms. i have one data block with 10 rows and a non database display item with corresponding length as that of the original data block .
when ever i am executing the form i want to see the serial number generated in the display item and when i inserted a new item or row it should show the corresponding rownum.
eg:
empno name serialno
5 tom 1
4 tinil 2
6 sofy 3
7 john 4
1 albert 5
2 michel 6
i want to get the above answer using forms.
I'm trying to read some data from external device via COMM Port.
Application is running n server and device is connected localy on my PC.
My device iz DPI605R for purpose of� pressure measuring.
I need Sequence generate in each row in tabular style form
Like
FA0015
FA0016
FA0017
(I dont want to use sequence because when i delete the row its conceder delete row in sequence )
I want to transfer data from Oracle form 9i to serial port.
Serial port is connected to electric board to show.
I have form with master detail relation ship (invoicing form) the detail block is tabular, displaying upto 7 records...
Now my clients wants to show the serial number along with each record while feeding the data (this includes when insert, editing, deleting / clearing records) he wants to see the serial number as in MS access / MS techniques.
I tried to use the system variable to use :system.cursor_record; but this dose not works.(in insert/edit/delete/clear record)
I have created simple data block by wizard and taken tabular layout 10 rows and 6 columns
i want to generate serial number on first column .....
what need to use..?
I have a sale invoice form with 3 data blocks.
Data block 1- master_blk : For date/customer of sale invoice
Data block 2- detail_blk1 (detail of the master block - For products and qty)
Data block 3- detail_blk2 (detail of DETAIL_BLK1 For entering serial numbers of products)
My requirement is that whatever quantity user enter in data block 2 against each product he must enter equal number of serial numbers of that product in data block 3.
For this I have created on item (cnt_iteml : to count product's serial numbers in block3 ) in data block 2, and on summary item (t_serial_no ) in block3.
Whenever user changes in quantity, cnt_iteml: item is populated with t_serial_no in block3 of that product by following trigger on quantity column.
POST-Change Trigger ( quantity column )
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
Following trigger is written on block level at data block-3 to populate cnt_iteml with t_serial_no.
PRE-RECORD
IF GET_BLOCK_PROPERTY('SERIAL_NUMBERS',STATUS) IN ('CHANGED') THEN
:stock_transactions.cnt_itl:=:serial_numbers.t_serial_no;
END IF;
Above triggers are fulfilling my requirement except following condition.
If user after entering serial numbers in block 3 and without saving goes back to block2 and try to navigate to another record he gets a message asking him to save changes by forms. At this time if user presses no then cnt_itl item is not been populated with t_serial_no item's value.
What I want in above condition is that if user was inserting new record cnt_it item should be populated with 0, so that he shouldn't be able to save this record. And If he was updating then cnt_itl item should be populated with actual no of records in database against that product.
The problem concerns distributed transactions.There are 2 databases that communicate with each other through a database link.We call Xa transactions from our weblogic application. Both databases work in a shared server mode.
Everything works until we run some performance tests on the evironment where the data volume is much bigger then the one on the other environments where the same tests succeeded. We're getting the following error: ORA-03113: end-of-file on communication channel
The error get registered in a local database alert.log when accessing data through the database link while there's no trace corresonding to this error as far as the second database is concerned. We're almost sure there's no network problem. The error occurs in only 1% of a total executions number. We also observe the inactive sessions number increasing on the remote database.
Both databases use ASMM by having set the SGA_TARGET and PGA_AGGREGATE_TARGET parameters and proper level of the STATISTICS_LEVEL parameter, so some hot elements like SORT type operations should execute fine.Any Oracle parameter should be tunned or we should take into consideration something else...
M getting ORA-03113 end-of-file on communication channel while calling my custom procedure. attaching code of procedure.
View 2 Replies View RelatedI have two machines with oracle 11g . Both having ODP 11.2 Beta. I've to communicate between these two machines using Oracle Advanced queuing. The message sent from one machine will reach the second machine only if the Firewall of both machine is OFF.But based on requirement, we cannot switch OFF firewall or add exceptions as ports or applications.
View 1 Replies View RelatedI am using a amazon EC2 machine i have oracle 11g on EC2 linux machine.when i m trying to startup the oracle it giving the error.
ORA-03113: end-of-file on communication channel
Process ID: 15294
Session ID: 125 Serial number: 5
i did google for this but it said to look in to alert.log which shows the error but i m not able to get the alert.log on ec2 linux machine.
One of the customer is using Oracle database Oracle database 9i and its listener is running on port 1521. When Oracle database client are connected to database , it is connecting on multiple ports ( like 1600 to 1690 ) . if it is possible to restrict Oracle database client connection to only one specified port or not .
View 17 Replies View RelatedMy Boss give me a mission:
How oracle send a s.m.s.(Short Message Service) to mobile device? Is there any examples or implement documents for reference?
Oracle 11g 11.2.0.2 Expression Edition
I made the number of processes to 1 by issuing the below command.
SQL> alter system set processes = 1;
SQL>shutdown immediateI am getting the below error when I issued startup command.
SQL> startup;
ORA-03113: end-of-file on communication channelalert log:
Fri Dec 28 14:09:24 2012
PMON started with pid=2, OS id=2984
Fri Dec 28 14:09:24 2012
PSP0 started with pid=3, OS id=5788
Fri Dec 28 14:09:25 2012
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for the next minute. Please look at trace files to see all the ORA-20 errors.
Process GEN0 submission failed with error = 20
USER (ospid: 4780): terminating the instance due to error 444
Fri Dec 28 14:09:25 2012
VKTM started with pid=4, OS id=1676 at elevated priority
Instance terminated by USER, pid = 4780How to startup my database again?
I have a SAN Storage device of 8TB size . I am new to rac setup ,i dont know how to configure the SAN device for RAC SETUP on ASM..how to configure the SAN device for RAC setup on ASM
How many disks we need to have? which and sholud be on ASM ? how to impliment raid10 for database file disk and raid5 for arhcive log files
I have following table.
CREATE TABLE ABC
(
DPT_NUM NUMBER,
LOT_NUM NUMBER,
ASSOCIATED_WITH_LOT NUMBER
);
SET DEFINE OFF;
Insert into ABC
[code]......
Now i run follwoing query and result is
select * from abc
DPT_NUMLOT_NUMASSOCIATED_WITH_LOT
1501
1502501
1509501
1511
1503
1516
1522
1565
1569565
2601
2602
2604602
2607
2508
I need following result
DPT_NUMLOT_NUMASSOCIATED_WITH_LOT Serial_Number
1501 1
1502501 2
1509501 2
1511 3
1503 4
1516 1
1522 2
1565 3
1569565 3
2601 1
2602 2
2604602 2
2607 3
2508 3
Note that serial number must reset after each 4 lot_num againt dpt_num. Not that where lot is associated in associated_with_lot there serial number must be same as serial number is for associated lot.
My archivelog database get error because my flash_recovery_area is full.
so I disable archivelog mode. When to restart database server I got this message:
ORA-03113: end-of-file on communication channel
processus ID : 27427
session id : 96, Numéro de série : 3
Do you think I can delete manually ( Os commande rm ) files in flash_recovery_area ?
How to restart database server
i use oracle11g. i got some error messages.
ora - 03113: end-of-file on communication channel
Process ID : 13782
Session ID: 87 Serial number : 5
I start sql*plus and start working. after 2-3 minutes i get error -
ORA-03113: end-of-file on communication channel.
I googled and found to see alert.log.(but i found no such file on my system) but in my system i found some info at C:\app
ishiproduct11.1.0db_1log
ishi-pcclientclsc42.txt
the content of the file is ;
********************************************
Oracle Database 11g CRS Release 11.1.0.6.0 - Production Copyright 1996, 2007 Oracle. All rights reserved.
2011-01-27 12:35:03.512: [ OCROSD][3332]utgdv:1:could not open registry key SOFTWAREOracleocr os error The system could not find the environment option that was entered.
2011-01-27 12:35:03.512: [ OCRRAW][3332]proprinit: Could not open raw device
2011-01-27 12:35:03.512: [ default][3332]a_init:7!: Backend init unsuccessful : [33]
2011-01-27 12:35:04.617: [ CSSCLNT][3332]clsssinit: error(32 PROC-32: Cluster Ready Services on the local node is not running Messaging error [9]) in OCR initialization
*************************************************
I am getting the same error evert time i login.Tried to stop/start oracle services but problem persists...
I have on PC running Windows Server 2003 named "Host A" and another Windows Server 2003 named "Host B".I made a Backup from Host A and want to restore this on Host B with following procedure.
Prepare & Backup:
SQLPLUS SYS AS SYSDBA
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
SQL>ALTER DATABASE OPEN;
SQL>ARCHIVE LOG LIST;
SQL>ALTER SYSTEM ARCHIVE LOG START;
SQL>QUIT
[code]...
But when i now try to access the Database Control i got following Error:„503 Service Unavailable: Servlet error an exception occurred the current application deployment descriptor do not allow for including it in this response" and the restored Datas are not included.
I wish to install 11g r1 RAC on my laptop having linux 4 as platform (on vmware) , for that i prepare 4 partition for that (on node1)
/dev/sdb1 - for ocr
/dev/sdb2 - for voting disk
/dev/sdb3 - for asmdisk group
/dev/sda5 - fro asmdisk group
by assuming external redundancy for ocr and voting disk i kept only one disk
and i configured following in /etc/sysconfig/rawdevices
/dev/raw/raw1 /dev/sdb1 -- ocr
/dev/raw/raw2 /dev/sdb2 -- voting disk
/dev/raw/raw3 /dev/sdb3 -- asmdisk group
/dev/raw/raw4 /dev/sdb5 -- asmdisk group
and my question is how node2 can understat these raw device as shared storage?