Mobile Server :: Oracle Lite - Can Be Used To Create Offline Windows (net) Applications?

Jul 31, 2012

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

View 6 Replies


ADVERTISEMENT

Mobile Server :: Connecting To Oracle Database Mobile Manager Workspace Using The Browser

Jul 3, 2013

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

View 6 Replies View Related

Mobile Server :: Deploy Existing Apps Design For Win Mob 6 On Windows 8 Phone

Mar 9, 2013

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 Replies View Related

Mobile Server :: How To Write Client Mobile Application - Read Publication Or Sqlite Table

Aug 16, 2012

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

View 0 Replies View Related

How To Create Central Inventory For Oracle 11g Running On Windows Server

Dec 26, 2012

--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.

We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.

View 3 Replies View Related

Mobile Server :: IOS Oracle BI App?

May 16, 2013

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 Related

Connect To Oracle From Another Server That Does Not Have Any Oracle Applications On It

Mar 7, 2007

I am trying to connect to Oracle from another server that does not have any Oracle applications on it.

I tried Perl, PHP, Java but each require parts of Oracle installed.

View 2 Replies View Related

Mobile Server :: Way To Use Client Dispositive In Oracle Paquet DBMS_OBFUSCATION_TOOLKIT?

Feb 2, 2013

This is a any possible way to use the client dispositive, in the Oracle paquet DBMS_OBFUSCATION_TOOLKIT?

View 4 Replies View Related

Server Administration :: How Partition Can Be Brought Offline

Jan 4, 2012

I have a partitioned table - 128 partitions.

If I am not using data of many partitions in any way, will it affect my performance if I am firing select query that uses other/active partitions data.

How can I check when that partitioned was last accessed, also can I brought those inactive partitions offlie? If we can, what will be the advantages or disadvantages of that?

View 23 Replies View Related

Server Administration :: Taking Partitions Offline In Tables

Feb 4, 2012

In an attempt to take older data off line and allow database refreshes to be faster, tablespaces associated with partitioned table data for a given time period was taken off line, leaving only tablespaces that relate to the current time period online. In effect, tablespaces related to 2010 and earlier were taken offline from a table.

1. Without giving a filter on the partition key (the business date) to scan for data greater than the dates in the off lined tablespace partition, we get a ORA-376/ORA-1110 error (data file cannot be read at this time).

2. Materialized views using fast refresh or refresh on commit, will also not work because of the partitions being off line.

Queries directly querying the tables are manageable from an application point of view.But the materialized views failing to aggregate is a bigger problem.

how we can manage this situation? I know that I can move the partitions to a different table in a tablespace to be taken off line. But if possible, we wanted to solve this without doing a move partition.

View 2 Replies View Related

Server Administration :: How To Offline Datafile In No Archive Mode

Oct 31, 2011

I want to drop a datafile in my test db which is in no archive mode,at first, i want to offline the datafile,but it failed,is there any way to do it?

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3237
[code].......

View 8 Replies View Related

Unable To Create Database (Oracle 12c R1 12.1.0.1.0 / Windows 2012 )

Aug 30, 2013

I have been trying out the new 12c on Windows 2012 Essentials with the same type of errors.  The OraDim step fails and cannot create the services.  It fails a bit differently if I choose "Create New Windows User", choose a "Use Existing Windows User", or choose the Windows Built-in user. 

View 3 Replies View Related

Server Administration :: Taking Tablespace Offline / Cannot Read Or Write

Nov 24, 2012

I have created an user named "Raja" with a default tablespace as "Raja_TBS" along with a datafile "rajadata.dbf". I have taken the tablespace offline

SQL> alter tablespace raja_tbs offline;

Tablespace Altered. when I take a tablespace offline, which means I cannot read or write and the tablespace is currently unavailable for users. I am still able to create a table on the "Raja_TBS" while it is offline.

View 39 Replies View Related

Server Administration :: Alter Database Datafile File_id Offline?

Dec 29, 2011

when i make a datafile offline,can i add the following option: normal or immediate?

such as like here:

SQL> ALTER DATABASE DATAFILE 5 OFFLINE NORMAL;
OR
SQL> ALTER DATABASE DATAFILE 5 ONLINE IMMEDIATE;

when i try a test ,it occurs an error:ORA-00933.

View 4 Replies View Related

Application Express :: Oracle Document For Apex Applications Backups?

Sep 26, 2012

Is there any official document from Oracle which tells us how to export apex applications from command line instead of using the GUI from within apex ?

When I googled I saw some links from apex users who had written as how to export using ApexExport utilities, but since we are in windows environment, we are having hard time getting the class_path,java_home...etc setup properly. I guess its not just me most of them would have encountered it.

But I am looking for an official document from Oracle ? ( exporting Apex applications from command line in Windows Environment ).

View 4 Replies View Related

Server Administration :: Undo Tablespace 100 Percent Full With Offline Extended?

Jul 26, 2010

i'm facing a problem while i'm inserting millions of record from table to table that undo tablespace reach 100% full and execution aborted. , how can free the undo tablespace ??? many of extendes are offline. will it flush automatically ??? or what i should do

View 4 Replies View Related

How To Move Offline Table Partition In Oracle 11gR2

Sep 17, 2012

OS=Windows 2003
DB = 11gR2

We got a request to take offline for few unused partitions and move it to a another drive (lease used).Please set the following partitions offline in PreProd:

MONTH_20110901
MONTH_20111001
MONTH_20111101
MONTH_20111201
MONTH_20120101
MONTH_20120201

Please move the offline partitions to the E disk.How can we do this ?

View 9 Replies View Related

Real Application Clusters :: Oracle 11GR2 - Test All Applications On Dev Environment

Jun 13, 2012

I've just patched a development oracle environment (RAC 11GR2) with temporary patch 8730312. I would like to do same thing on Production RAC. Is it necessary to test all applications on dev environment with this kind of patch before deploy it on Production ?

View 2 Replies View Related

Forms :: Oracle On Mobile?

Dec 30, 2010

I want to learn that how i can connect oracle with mobile . how I can make a applicant in mobile and connect with computer.

View 5 Replies View Related

Does Oracle Has Any Solutions For Mobile Platform

Apr 12, 2013

Does Oracle has any solutions for mobile platform ? something to build the application on smartphone...

View 2 Replies View Related

Forms :: How To Send Sms To Mobile Device Using Oracle 6i

Oct 19, 2013

I want to send sms to the mobile using Oracle form 6i.

View 8 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

RAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File

Jan 17, 2012

working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.

View 6 Replies View Related

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

Apr 19, 2011

I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.

View 3 Replies View Related

How To Create Ocr Disk Or Voting Disk On Windows Server 2008

Feb 17, 2011

I have 2 servers both having windows server 2008 64 bit as operating system installed on both I need to install oracle clusterware 11g r1 on both servers with clustering on external storage. I have configured the network(private,public and virtual) for both servers and have started the installation.

In the installation of oracle I add both servers but then I reach to a point where they ask me for voting disk or ocr disk in the cluster configuration storage but no disk is present how can i create ocr disk or voting disk on windows server 2008? And the external storage should I buy a special type of storage that supports clustering to continue my work?

View 2 Replies View Related

Windows :: ORACLE 11g R1 Or R2 For Server 2008 R2

Jan 7, 2011

Oracle 11g R1 or R2 is availble for Windows Server and If YES then any link for the same.

View 2 Replies View Related

Server Administration :: Oracle XE On Windows XP

Apr 26, 2012

I have oracle XE installed on my machine and it was working absolutely fine for the last year or so. Today there was an trojan intrusion which caused some issues with my windows xp OS like hiding some files, desktop etc. After everything was cleaned up and things back to normal. I am having issues with XE.

1. I can start and stop XE with out any issues
2. When I use the run sql command line, I can connect using - connect sys/sys as sydba.
3. I can also run a query to see all the users and see the HR user also.

However,
1. When I connect to my hr user using connect hr/password@xe, it just hangs
2. I tried the- go to Oracle XE admin page but it just hangs for a long time and returns page cannot be found.
3. I can tnsping the xe instance.

Is a fresh install the only option? or is there any way to correct this using the sys/sys user?

View 9 Replies View Related

Oracle 10g RAC On Windows 2008 Enterprise Server

Oct 7, 2010

I'm installing Oracle 10g (10.2.0.4) RAC on Windows enterprise Server. Am able to install cluster ware (10.2.0.4). While installing ASM (10.2.0.3)/ DB its going to restart both the servers automatically. Is there any problem with this Versions (OS and Oracle) combination. Is it compatible or Not?

View 4 Replies View Related







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