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


ADVERTISEMENT

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

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

How To Connect Between Oracle To SQL DB Server

Jul 17, 2012

OS: RHEL 5.7 64 bit
DB: 11.2.0.2 SE 64 bit

We have a scenairo in which we have two servers one is a Oracle server and the other is SQL server and we need to enable automated Emails from the oracle DB server. As the Oracle server is not whitelisted and we have a SQL server which is already whitelisted so is it possible to connect from Oracle server to Sql server so that the automated emails will be generated from the sql server (as it is whitelisted) and we do not want to whitelist the oracle server.

View 3 Replies View Related

Server Administration :: How To Connect Oracle Client To Remote Server DB

Jun 29, 2013

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

View 14 Replies View Related

Server Administration :: Connect 500+ Client To Remote Oracle Server?

Aug 10, 2010

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

View 6 Replies View Related

Connect To 10g Oracle Server From 9i Client

Apr 18, 2008

Is it possible to connect to 10g oracle server from 9i client?

View 1 Replies View Related

How To Connect To Oracle Server With Tunneling

Jul 23, 2013

Web Server(port80) and SSH Server(port 212) and Oracle client with sqlplus (192.168.137.2)
||
||
SSH client (192.168.137.1/128.21.31.111)
||
||
Oracle Server (port 1521) (128.21.31.112)

my php program have to access the db on oracle server, and then i do this on my SSH client

ssh -p 212 user@192.168.137.2 -R 1521:128.21.31.112:1521

View 1 Replies View Related

Forms :: Can Oracle 11g Connect To DB2 Or SQL Server

Sep 24, 2010

I just want to know whether Oracle forms 11g supports other databases like DB2, SQL Server etc.

Also does Oracle forms 11g supports Oracle database 9i or 10g apart from 11g?

View 1 Replies View Related

Server Administration :: Unable To Connect To Oracle 11g Using Forms 4.5

Apr 21, 2011

We are unable to connect to Oracle 11.1.0.7.0 from Oracle Forms 4.5..However we are able to connect using Oracle forms 6i

Now Forms 4.5 is old and not supported, however apart from Tests I will need prove it to the higher ups...Do we have any link, document which will cover such compatibility issue?

View 7 Replies View Related

Efficient Way To Connect SQL Server From Oracle Which Is Running On HP-UNIX

Mar 8, 2011

I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.

View 1 Replies View Related

OLE DB :: Connect Oracle DB In Windows 2003 Server From Linux Desktop

Aug 18, 2012

I have Oracle 9i DB in windows 2003 server, I want to access this DB from Linux desktop. Is there any 'client software' is available to connect Or procedure to connect the DB.

View 0 Replies View Related

Networking And Gateways :: Connect To SQL Server From Oracle Using Heterogeneous Services?

Mar 11, 2011

I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.

But I do not have any such folder(rdbms) in my $ORACLE_HOME.What does it mean? And how can I install HS alone on my system(Since I already have oracle)

View 4 Replies View Related

Server Administration :: Oracle Hang - Client Cannot Connect Database

Apr 29, 2012

all of the client cann't connect the db,and using sqlplus / as sysdba also cann't login there are many error of TNS-12535 and in the listener.log

alert.log:
Sun Apr 29 18:10:36 2012
opidcl aborting process unknown ospid (42992060) as a result of ORA-604
Sun Apr 29 18:10:54 2012
opidcl aborting process unknown ospid (26280196) as a result of ORA-604

[code]...

View 5 Replies View Related

Client Tools :: Connect Oracle Developer 6i Without Connect String

Aug 17, 2010

I have installed oracle developer 6i. in sqlplus i want to put my username and password but nothing in the connect string field.

View 1 Replies View Related

Connect Oracle Database From Delphi - Could Not Resolve Connect Identifier Specified

Oct 6, 2010

I have the following computer/setup:

Acer laptop, Intel Processor w/ Windows 7 Professional (64-bit)
Delphi 2010 Professional
Oracle XE (+ the Oracle XE client that comes with it)

I cannot can't to the Oracle database from Delphi. The error I keep getting is:

Alias is not currently opened. [Oracle][ODBC][Ora]ORA-12154:TNS: could not resolve the connet identifier specified.

Here's what I've done:

1. Create an ODBC connection to my Oracle database

- run C:WindowsSysWOW64odbcad32.exe to open the ODBC administrator.
- Data source name: bt_user
- TNS Server Name: localhost/xe
- user bt_user
- Clicked "test connection" -- Success.

2. Open Delphi and drop a TDatabase component on my main form.

- Set the Alias Name property to "bt_user" (the alias I set up in ODBC)
- Set database name to "bt_user".
- Checked "connected".

Alternatively, I tried using the Delphi ADO components (the dbGo components).

- Drop TADOConnection component on my form.
- Select "connection string" and open the dialog.
- Click "build string".
- Select "Microsoft OLE DB Provider for ODBC Drivers" from the selection.
- In "use data source", select "bt_user" from the drop-down list (my ODBC connection from #1)
- Click "test connection".

Again the same error.

My questions are:

1. Can Delphi work with Oracle XE (Express Edition)?

2. If so, then do I need to install the "Instant Client"?

3. Will the instant client for Oracle 10g work with Oracle 10g XE?

4. Do I need to install any additional ODBC driver(s)?

5. Why was I successful in creating the ODBC connection in Windows, but it failed in Delphi?

6. Will Visual Studio.NET (C#) work with Oracle XE, and what are the steps for setting that up?

View 2 Replies View Related

Oracle Connect By?

Nov 26, 2012

I've stucked with a query. Let me explain the situation: I have a table that i store the IDs of logically equal records.

For example;
A = B
B = C
X = Y
Z = Y

My query must return all equivalent records. If you call the query with parameter 'A', the result set must contain B and C. And if you call the query with parameter 'Y', the result set will contain X AND Z. I have thought that i can write the query wity using start with connect by statement. But the query does not work as i expected. Here is my code and sample data:

create table temptable (ID1 number,ID2 number);/
insert into temptable values(11,12);/
insert into temptable values(12,13);/
insert into temptable values(13,14);/
insert into temptable values(13,15);/

SELECT distinct ID1 from
(
SELECT * FROM temptable
START WITH ID1 = 13 OR ID2 = 13
CONNECT BY NOCYCLE

[code]...

In my sample the equality definitions is;
11 = 12
12 = 13
13 = 14
13 = 15

When i call the query with parameter 13, i'm expecting to get 11,12,14,15. But it returns only 12,14 and 15.

View 4 Replies View Related

PL/SQL :: Connect By Prior In Oracle 11g?

Apr 1, 2013

I am upgrading an application from 9i to 11g and I've been told that the connect by prior sql is broken. While I am waiting for the example and the error message, is 11g pickier about looping than 9i was? some documentation on 10 or 11 changes to hierarchical queries?

View 1 Replies View Related

ODP.NET :: Connect To Database Oracle With C#

Oct 19, 2012

I am trying to develop a web application with C # VS.net, my application is to connect to an Oracle database on a server (LAN), the problem I want to connect to the database without install oracle or ODP on my client machine.

View 1 Replies View Related

Connect To Oracle DB - Developer Error?

Apr 26, 2009

i've been trying to connect to the Oracle DB with Oracle SQL Developer.I get a message

State: Test Failed - IO Exception "The network adapter could not establish the connection"

When i go try tnsping 1521 It detects a connection by Oracle Database.And finally i get TNS-03505: Failed to resolve name

When i went into the "services.msc" and tryed to run the "OracleOraDb10g_home1TNSListener"

Got a message: "Error 3: The sytem could not find the specified path"

View 9 Replies View Related

How To Connect Oracle DB With C Builder 5.0 Application

Jul 27, 2010

i want to know how can i connect c builder application with oracle 10g express ? which components i have to use?

View 1 Replies View Related

Oracle Database - Cannot Connect From PHP Script

Jul 19, 2010

I have created an Oracle database on my Windows XP system but cannot connect from a php script

CODE

<?php
if (!$db = @ocilogon("big", "big", "s7s"))
    {
    $error = ocierror();
    printf("Error was: %s", $error["message"]);
    die();
    }
$stmt = ociparse($db,"SELECT count(*) FROM members");
ociexecute($stmt);
?>

When I created the database the connection I used was s7s but whether or not I include that name or just use the ID/password that script will not connect.

View 2 Replies View Related

Unable To Connect To Oracle 10g Through TOAD

Jul 28, 2010

I have installed Oracle 10g XE in my laptop having Windows 7 home 64 bit OS..I have created some users in the oracle and iam able to connect these users through cmd prompt..But the issue is that iam unable to connect to the database through TOAD..

I have given the user name and password and database as XE and connect using as : XE but still iam getting the error as "TNS could not resolve the connect identifier (XE).

View 12 Replies View Related

Unable To Connect In TOAD In ORACLE 11g

Jan 4, 2011

Unable to connect in TOAD in ORACLE 11g through sys user.

I am using Toad for ORACLE version 9.0.0.160 and ORACLE 11gR2 (11.2.0.1).

I make the FALSE to "sec_case_sensitive_logon" parameter hence not able to login through sys user. I can logged in through system user without any issue.

View 4 Replies View Related

Can't Connect To Oracle - Logon Denied

Mar 21, 2011

i installed Oracle 11.2.0 64bit & Oracle SQL developer 2.1.1.64 on Windows-7 64bit

i try to connect to database like this:

username: scott
password: tiger
role : sysdba
hostname: localhost
port : 1521
sid : ORCL

and i got this error: `ora-01017 invalid username/password; logon denied`

View 3 Replies View Related

Reports & Discoverer :: How To Connect CR8 To Oracle 11g

Feb 22, 2011

i need the crystal report application to try to get some reporys from the database .

and i am new to crystal reports and want to know how to connect to oracle database 11g .

wher to get CR 8 and step by step how to connect it to my database

View 1 Replies View Related

Windows :: Connect Oracle From Win 7 64bit

Jun 22, 2013

Recently i have installed oracle 10g.2 in my laptop under Win-7 64bit. But cannot connect oracle from Windows form [C#], Office application[Excel] and odbc. Showing error[Tns could not resolve the connect identifier specified Drivers SQLSetconnectAttr failed ]

Though I can connect oracle from toad and sqlplus and form 6i.

View 17 Replies View Related

Precompilers, OCI & OCCI :: How To Connect C++ And Oracle

Sep 17, 2008

My OS is Linux and I installed Oracle 10.2. Everything is fine.I can use sqlplus, exp, imp etc with no problem.Now I have created another linux user test in /home/test. I unzipped basic-10.2xxxxxx.zip (/home/test/instantclient_10_2) and exported LD_LIBRARY_PATH.I guess I have installed instant client in this way.

My testOra.cpp:

#include <occi.h>
int main()
{
return 0;
}

This test.cpp would not compile. It cannot find occi.

View 8 Replies View Related

Windows XP SP3 And Oracle XE10.2g Connect

Aug 24, 2010

I am having a problem understanding the relationship between users and databases within Oracle. I have a user "big" that logs on successfully on another machine to database "s7s" but on a different machine fails to connect.
The following may be interesting:-

<?php
$SGMDBUsername = "big";
$SGMDBPassword = "big";
$SGMDBName = "s7s";
$conn=OCILogon($SGMDBUsername, $SGMDBPassword, $SGMDBName);
[code].......

If I on the new machine issue the command sqlplus big/big. I successfully connect and see the tables I am looking for.

View 12 Replies View Related







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