Mobile Server :: Way To Use Client Dispositive In Oracle Paquet DBMS_OBFUSCATION_TOOLKIT?
Feb 2, 2013This is a any possible way to use the client dispositive, in the Oracle paquet DBMS_OBFUSCATION_TOOLKIT?
View 4 Replies
ADVERTISEMENT
Mobile Server :: How To Write Client Mobile Application - Read Publication Or Sqlite Table
Aug 16, 2012Trying 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
Mobile Server :: Connecting To Oracle Database Mobile Manager Workspace Using The Browser
Jul 3, 2013I 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 .
Mobile Server :: IOS Oracle BI App?
May 16, 2013I'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 RelatedMobile Server :: Oracle Lite - Can Be Used To Create Offline Windows (net) Applications?
Jul 31, 2012I 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.
PL/SQL :: DBMS_OBFUSCATION_TOOLKIT Function Not Working In Al32utf8 Character Set?
Sep 3, 2012Earlie we used oracle 10g with WE8MSWIN1252 character set(single-byte character) that time the below PL/SQL block was running fine.That is we are passing 56 length character to SYS.DBMS_OBFUSCATION_TOOLKIT.DES3DECRYPT function .Now we migrated to 11g with al32utf8 charecter set.Now if we are using 56 length variables to pass the value then we are getting ORA-06502: PL/SQL: numeric or value error: character string buffer too small error.So i have changed the variable length to 86(Minimum 86 required)
But now i am getting different error
Error report:
ORA-28232: invalid input length for obfuscation toolkit
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 84
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 255
ORA-06512: at line 9
+28232. 0000 - "invalid input length for obfuscation toolkit"+
[code]....
Client Tools :: Can Use Oracle Client Version To Create A Database In That Server
Jan 13, 2011can we use oracle client version to create a database in that server.
View 3 Replies View RelatedClient Tools :: Oracle Client 32 Bit On Windows Server 2008 R2 64 Bit
Jul 20, 2012Can i install Oracle 10g Client 32 bit on our Windows Server 2008 R2 64 bit?
View 1 Replies View RelatedForms :: Oracle On Mobile?
Dec 30, 2010I 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 RelatedDoes Oracle Has Any Solutions For Mobile Platform
Apr 12, 2013Does Oracle has any solutions for mobile platform ? something to build the application on smartphone...
View 2 Replies View RelatedForms :: How To Send Sms To Mobile Device Using Oracle 6i
Oct 19, 2013I want to send sms to the mobile using Oracle form 6i.
View 8 Replies View RelatedMobile Server :: Deploy Existing Apps Design For Win Mob 6 On Windows 8 Phone
Mar 9, 2013It 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 RelatedServer Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client
Feb 13, 2013I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
Server Administration :: How To Connect Oracle Client To Remote Server DB
Jun 29, 2013I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.
On the server machine I configured oracle server in the following way:
Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:
Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521
All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.
With SQL Plus as by the official documentation I have entered the following command:
CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.
With SQL Developer I have entered the same parameter.
But with both SQLPlus and SQL Developer the connection fails.
Server Administration :: Connect 500+ Client To Remote Oracle Server?
Aug 10, 2010we have oracle server. we have to connect 500+ client machine to oracle server.
is it i need to install client version to all 500+ or any other shortcut way?
Server Administration :: Oracle 10G Client Works With 11G Server?
Jul 17, 2013Does a 10g oracle client works with an Oracle 11g server?
View 1 Replies View RelatedConnect To 10g Oracle Server From 9i Client
Apr 18, 2008Is it possible to connect to 10g oracle server from 9i client?
View 1 Replies View RelatedMobile Server :: No Upload Sync / Only Download Sync?
Sep 18, 2013platform: 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 RelatedClient Tools :: Oracle Connection To SQL Server
Mar 2, 2011I am using dg4msql to connect to SQL server from Oracle(10.2.0.4, with AIX 5.3).
#from my laptop sqlplus (10.2.0.2)
SQL>select count(*) from table1@mssql; #works
SQL>select * from table1@mssql; #ERROR
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver]String data, right truncation
{01004}[Oracle][ODBC SQL Server Driver]String data, right truncation {01004}
#from my laptop, TOAD
Both queries works fine.
i have compared
"select * from nls_session_parameters;" values , TOAD and sqlpus gives same result.
Windows :: Different Versions Of Oracle Between Server And Client?
Apr 11, 2012I'd like to know if it's possible to install a client with Windows 7 (64bits) can be installed with Oracle 11gR2 (32 bits) when the server is still with Oracle 10.1.0.2 ?
View 1 Replies View RelatedWindows :: Oracle Client On W2K8 Server
Jan 28, 2011I have installed an application suite (AppX) on Windows 2008 Server which has both Windows applications and a web GUI element (ASP.NET running through IIS 7.5).
The Windows apps are in both VB and .NET and compiled specifically for x86 (due to COM component dependencies). I have installed the "Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4)Enterprise/Standard Edition for Microsoft Windows Vista, Windows Server 2008, Windows 7" Oracle Client on the Windows 2008 Server.
After installation AppX windows modules all worked fine with the Oracle Db but the Web Application was getting the following error:
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
After a bit of research I found a few articles suggesting setting up the ORACLE_HOME directory in the Windows Environment variables. So I tried setting up the ORACLE_HOME environment setting and had some success as the AppX web application worked fine! However, the Windows apps of AppX were now broken and returning the error:
System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.
at System.Data.OracleClient.OciHandle..ctor(OciHandle parentHandle, HTYPE handleType, MODE ocimode, HANDLEFLAG handleflags)
at System.Data.OracleClient.OciEnvironmentHandle..ctor(MODE environmentMode, Boolean unicode)
at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
[code].........
So I am struggling to get both the Windows and Web App both working on the same Windows 2008 Server.
Difference Between Oracle Database Server And Client?
Jul 22, 2011Currently I am doing one Oracle installation.But very much confused where to start from. Since I am installing oracle on my personaly Laptop,do I need to install Oracle database server and Oracle client both or only installing database server is sufficient.
What is the exact difference between oracle database server and client.Only knowledge I have is that client is used to access database server remotely.are Oracle database server and client installable to be downloaded separately?
Client Tools :: How To Insert Data From SQL To Oracle Server
Dec 13, 2012I have problem: I have 1 sql server already setup SQL Server 2012 Express and 1 Oracle Database server 10g. Now i want to insert data from SQL server to Oracle database through link server.
Some step i already make:
1. Setup oracle database 10g and configure listener (Finished)
2. Setup Sql server 2012 express on Windows 7 (Finished)
3. Setup ODTwithODAC1020221 on PC already setup SQL server (Finished)
4. Make Linkserver from SQL server to Oracle database (Finished), and can select data from Oracle Database on SQL server through Linkserver.
However when i insert data from SQl server to Oracle Server not success.
select * from OPENQUERY (QVHKTEST, 'SELECT * FROM QVSYSTEM')
After i run above script, result is OK
With: "QVHKTEST" is alias of Link server from SQL to Oracle server
: "QVSYSTEM" is a table on Oracle database, that table we want to get through Linkserver on SQL server
Both Server Database contain same name table is "QVSYSTEM"
-----------
INSERT OPENQUERY (QVHKTEST, 'SELECT BODY_NO,
MERCHANDISE,
MODEL_NAME,
LINE_NAME,
DATE_ENTRY
FROM QVSYSTEM')
values('VNF4619829','3227B002CA','L1068','01','2012/09/26 03:18:11');
If i run script above directly in SQL Window query can insert OK. This is code in trigger at table on SQL server:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:<Author Name: Phuong Do Minh >
-- Create date: <Create Date: 10/12/2012>
-- Description:<Description: After data insert into table qvsystem on SQL server
-- This trigger will fire and insert that data into table qvsystem
[code].......
But when i make trigger after insert on table in SQL Server to insert data From SQL server to Oracle server, however not success and SQL server raise error below:
OLE DB provider "OraOLEDB.Oracle" for linked server "QVHKTEST" returned message "New transaction cannot enlist in the specified transaction coordinator. ".
Msg 7391, Level 16, State 2, Procedure Insert_data, Line 16
The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "QVHKTEST" was unable to begin a distributed transaction.
I don't know how to configure them.
Client Tools :: Load Tables From SQL Server To Oracle
Jan 31, 2013best method (easy and efficient) to load tables from sql server database to oracle database.
View 2 Replies View RelatedServer Administration :: Install Oracle Client 11G Software In AIX Box?
Jul 25, 2012I am trying to install Oracle client 11G software in AIX box. In /home/oracle, I find 7 profile files. I am not sure which profile file I am supposed to consider.
View 1 Replies View RelatedClient Tools :: Connection From Oracle SQL Developer To MS SQL Server
Jun 8, 2010I'd like to make a connection from Oracle SQL Developer to a MS SQL Server DB. How can I do that?
View 2 Replies View RelatedClient Tools :: No Server Option In Oracle SQL Developer?
Jan 31, 2013Using SQL Developer I am able to login using oracle credentials but I dont see any option for SQL Server. I see both Oracle and Access. Why I am not able to see the SQL Server option in SQL Developer tool? I need the SQL Server option because I want to transfer some tables from SQL Server database to Oracle database.
View 1 Replies View RelatedClient Tools :: How To Migrate Data From SQL Server To Oracle Database
Jun 13, 2013how to migrate sql server database to oracle database?
View 2 Replies View RelatedClient Tools :: How To Sync Oracle 10g Database With SQL Server 2005
Jun 27, 2013i have my oracle 10g database on my windows 7 and i install sql server 2005 on my windows server 2003 .now i want to sync my oracle 10g database with my sql 2005 means whenever i make any changes in my oracle table its automatically effect in my sql server also.
View 1 Replies View RelatedClient Tools :: Oracle Services For Microsoft Transaction Server?
Apr 2, 2012I want to use SSIS,when i use oracle 10g as a data source to SQL Server 2008 as Destination, it gives error ora-01017 invalid username/password logon denied, i did normal oracle installation and give full privileges(sysdba or sysoper) to the user(sys,system...),when i check connection it shows test connection succeeded but when click on next it gives above error.
View 3 Replies View Related