It looks that windows mobile is gone and windows 8 is available.. Can a vb .net application developed to run on win mobile 6 with oracle lite be deployed on windows 8 phone.
View 3 Repliesi have developed one mobile application and i want upload to store as an app
View 2 Replies View RelatedI am exploring the options for file based databases for offline applications where there are no overheads of database installations. We have a system which has Oracle database with more than 500 tables. We need to write a lightweight application (offline) in .net which will run from USB drive and write data to USB drive only.
Existing system has a data layer which writes data to Oracle 10g Enterprise Edition database. The offline application will have more or less similar data entry forms and storage structure. In order to reuse data layer of existing system (stored procedures) can the Oracle Lite be used as a database which can run from USB drive?
I understand Oracle Lite has a suport for synchronization with the server (our main database in this case) by which data can be synchronized with minimum overheads. How the Oracle Lite is licenced if I have 300 odd users of this offline applications. I need to use only database part of Oracle Lite and not mobile server.
I would like to design a functional design document for existing package. Let me know is there any tool which will build the design document?
View 8 Replies View RelatedI Have installed the oracle database 11g, the oracle database mobile server and i use Glassfish as the application server. Everything is fine i have tested the mobile server configuration using Oracle mobile server workbench the mobile server runs but when i want to connect to the mobile manager workspace via the browser using
[URL].......
I have a server error HTTP 404- The requested resource () is not available .
Trying to learn about Oracle Database Mobile Server.Installed the server, installed the client on WIN 32, created a publication and successfully synchronized.Now need to write a client application for mobile users.
Qs 1) Can I write a simple JSP that reads a table from device SQLITE database?or, the JSP needs to read off a subscrption?If it needs a subscription as the source, then how do I mention it in the JSP?
2) example of such a Client program
How do I install the 10G listener on the application server (11i)
View 3 Replies View RelatedI still have a legacy apps built using Forms 6i and Reports 6i running against Oracle 10g database on a Windows XP client and Windows 2008 server.It seems working well on Windows 7 client (32-bit only), but I think that it needs to test this apps.
View 11 Replies View RelatedI'm trying to deploy the schema using DATAPUMP API. The user from which the schema get deployed has the direct privilege of CREATE USER (not through role). But got the insufficient privileges error.
Processing object type SCHEMA_EXPORT/USER
ORA-31685: Object type USER:"SCOTT1" failed due to insufficient privileges. Failing sql is:
CREATE USER "SCOTT1" IDENTIFIED BY VALUES '4EBB0DDE3C79FE47' DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP2" PROFILE "APP_PROFILE".
But the user get created successfully when run the CREATE statement manually.I have created the user manually and again run the deployment procedure. Got the below error for ROLE_GRANTS.
Processing object type SCHEMA_EXPORT/ROLE_GRANT
ORA-39083: Object type ROLE_GRANT failed to create with error:
ORA-01932: ADMIN option not granted for role 'EXP_FULL_DATABASE'
Failing sql is:
GRANT "EXP_FULL_DATABASE" TO "SCOTT1"
The user has EXP_FULL_DATABASE with ADMIN Option and IMP_FULL_DATABASE with ADMIN option direct privileges.which privileges the user needs to deploy the schema successfully?
I've been asked to build for the Oracle BI app offered free through Apple. I am currently using 11g XP and SQL Developer. What is the best middle wear to use, JDeveloper? Is there some other software I should use?
View 1 Replies View RelatedThis is a any possible way to use the client dispositive, in the Oracle paquet DBMS_OBFUSCATION_TOOLKIT?
View 4 Replies View RelatedI need to retrieve only one telephone number against the parent id. The preference is to get mobile if available if not home number else work phone. How can I achieve this
I have given the sql code and sample output below
select
pp.phone_id
,pp.parent_id
,pp.phone_type
,pp.phone_number
from per_phones pp
[code]....
Actual results should be
PHONE_ID PARENT_IDPHONE_TYPEPHONE_NUMBER
12960 2500H1 9385789
311108 146564M 04879652
how and where can i specify the phone number format
View 8 Replies View RelatedCan I run oracle forms on cell phone through internet using live IP?
View 2 Replies View Relatedplatform: linux64 + glassfish I run msync as a client on the same server, but on the mobile manager web page, only download sync publications history can be found. What shall I do to sync local Berkeley database content to oracle?Do I need to create upload sync publications? Do I need to use mobile server workbench to create new applications?
View 1 Replies View RelatedIn Apex 4.2 Jquery mobile list view how can you apply html format for the phone# field to make it dial with a touch. For example, I see how to do a list view of the 'DEMO_CUSTOMER' sample data, but I cannot figure out how to format the phone # fields so that they will dial on touch. I know the HTML tags to use and I know how to use it in a standard report, but I can't figure out list view.
View 3 Replies View RelatedI've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:
Checking Operating system version: must be 5.0,5.1,5.2 or 6.0
Actual 6.1
FAILED <<<<
Exiting Oracle Universal Installer
Press any key to Exit.
We plan to deploy oracle EBS R12. what are all the components needed to build this infrastructure. ex. Oracle 11g database, oracle 10g application server.
also which solution should be deployed to ensure the Enterprise single-Sign On (ESSO).
Ive a requirement which ive overlooked for a while now as below,
On my tabular form i have fields: Empid as Select List and when the value is picked from this Select List EmpID i want the associated/corresponding phone# displayed in its TEXT FIELD in that same row,
apex 4.1.1/Oracle 11gR2,
also i tried the below as a workaround but it doesnt fulfill my requirement, [URL]....
Oracle Database version: 11.2.0.2 / sparc / 64bit.
Os Version: Solaris 10 with update 6(or more).
Requirement:
OS backup (without Oracle binary/software and database) will be taken from existing server. The server will be "zoned"(container or may call virtual machine). The backup will be restored on the vm; all database related mount point will be there. Installation of same Oracle software and creation of test database.
Scenario:
Before starting oracle installation i am on an OS in which the oracle software was previously installed. But the software files/binaries are not present. I am just putting the software again through installation. Now all the prerequisites are met and oracle project/user/group is already there as os is backed up from previous working setup.
Question:
What should i take care for this installation?Is it will be a simple installation just running the runinstaller?
How I can maintain a replication scheme from a production database and a standby. I was watching the advanced replication methods of Oracle, but what I want is in the evening to run a process and modify the database incrementally and thus leave until the next night.
And the server I want to allocate to the standby database, also implements other processes, so my settings would be:
Production: Oracle Database 11g Linux 5.5
Standby: Windows 2003 Database 11g
Maybe that data is important, let me make clear that what I want is that the database is updated incrementally.
I want to install Oracle 10g R2 on Windows Server 2008.
View 22 Replies View RelatedI have developed a custom application in APEX. I wants to deploy and make it as a web application so that it can be access through url.
View 1 Replies View Related I have a big probleme with owb 11.2.
1. I have export MDL file from owb 10.2
2. I created owb repoisitory on server where I have installed my database 11gr2.
3. I have installed OWB 11gr2 on another machine.
4. Imported MDL file to new repository.
How I deploy to my new repository?
I'm am getting an error that says that a role doesn't exist when I can cleary see it in DBA_ROLES. I can successfully grant other roles in this session. I am using Oracle 11.1 on RAC.
GRANT "CONNECT" TO BAKERD
Error at line 1
ORA-01919: role 'CONNECT' does not exist
select * from dba_roles where role = 'CONNECT'
[code]....
howto to setup an oracle server and "import" my old databases just from the copied directory structure d:\oracle\product\... ("cold backup") to the new install.i was trying to setup an new server by shutting down the db and just copying back my data/control/log/*.ora files which doesnt seem to work.
i could see the old tables structures in the local sqlplus console, but the databases are not reachable over the net.
also the enterprise manager is not able to startup the dbs, it show just an running listener.
I am using a shell script to load unix content to a database.I have captured the unix data to a csv file and I am using a sql loader to inser that csv data to database. following is my ctl file contents.
[b]load data
infile data.csv
into table AVS_LOGS
fields terminated by ','
(
RUNDATETIME,
SERVER,
DIRECTORY,
FILENAME,
LASTUPDATETIMESTAMP
) [/b]
and I am using sql loader command in unix that is [b]sqlldr $CLOGIN control=control.ctl log=test.log[/b]
But this is working only if the table is empty.Now I am looking for something where I do not need to delete the data from table each time. it should update the table.
I am soon engaging in a project where we will deploy three triggers to each table in a customers live database. One each for Inserts,Updates and deletes.
These triggers write or update a row in a separate table on a different schema.
We have experienced locking issues on these tables previously with SQL Server. Are there settings we can look at to improve performance?
We have a table which is already partitioned by list and now we would like to add a subpartition.
Create table Item_mst
(
ccn varchar2(10),
Flag varchar2(1),
Item varchar2(10),
status varchar2(1)
)
[Code]..
Now I could like to alter the above table for adding a new subpartition on each partition on status.
ALTER TABLE Item_mst
MODIFY PARTITION Item_mst_Test
ADD SUBPARTITION Item_mst_Test_A VALUES ('A');
Above alter gives ORA-14253: table is not partitioned by composite range method.
However dropping and recreating the table with subpartitions is working fine.
But Dropping and recreating the table in production is very cumbersome as it has huge data and many indices.
i am installing oracle 11g rel2 ( o/s : hp ux 11.31 ). already we have 11g rel1 installed in the machine where oracle inventory location is /oracle/oraInventory where /oracle is ORACLE_BASE directory..
cd /oracle
ls -ltr
drwxrwxr-x 4 ora11gr1 dba 8192 Aug 30 00:19 oraInventory
now when i install oracle 11g rel2 on the same machine, it should use the existing oraInventory..but it is prompting us to enter the new location for oraInventory during installation....but as per the naming convention, we need to keep inventory directory under /oracle/oraInventory only..
when i select oraInventory location as /oracle/oraInventory from wizard, iam getting below error:
[INS-32055] The Central Inventory is located in the Oracle base.
[INS-32035] Unable to create a new central inventory at the specified location.
should i uninstall the exisitng oracle 11g rel1 and then should i install rel2 (i.e what iam trying to install now ) ?if so, after instlaling rel2, then should i install rel1 ?