I would like to develop a system with Oracle 9i as the database and PHP 4/5 as the front end. I am not able to establish the connectivity to the database. What should I do now ?
View 3 RepliesI have installed unixodbc 2.3.1, postgres odbc driver (psqlodbc-07.03) and dg4odbc 11.2..On querying : select sysdate from dual@dblink_postgresql, the following error occurs:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found {01000}
ORA-02063: preceding 2 lines from DBLINK_POSTGRES
Similar error appears in the trace file as well.
[unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a'
$ isql -v postgresql postgres postgres@2012
[01000][unixODBC][Driver Manager]Can't open lib '/oracle/psqlodbc/lib/libpsqlodbc.a' : file not found
[ISQL]ERROR: Could not SQLConnect
However the file is present in the location and has no permission related problems.
$ pwd
/oracle/psqlodbc/lib
$ ls -lrt
total 2952
-rwxr-xr-x 1 oracle oinstall 663 Mar 25 15:28 psqlodbc.la
-rw-r--r-- 1 oracle oinstall 731419 Mar 25 15:28 libpsqlodbc.a
-rw-r--r-- 1 oracle oinstall 12215 Mar 25 22:11 win_md5.o
-rw-r--r-- 1 oracle oinstall 18100 Mar 25 22:11 options.o
[code]....
We have a requirement to connect from 9.2.0.8 database on AIX to MS SQL 2008R2 .
Source :
----------
Oracle : 9.2.0.8 (64 bit)
OS : AIX - 4.3.3.0/5.3.0.0 (64-bit)
Target :
----------
MS SQL : 2008R2
OS : Windows 2008 (64-bit)
1] Can we use - Database Gateway for SQL Server for the above set up ? If so , does this require a separate license ?
2] Where Do we need to install the "Database Gateway for SQL Server " -- soruce or target server ?
3] Is there any other solution apart from using "Database Gateway for SQL Server " ?
we have a database available in UNIX machine A which can be connected from client in UNIX machine B through port 1521.
If we give ping command from UNIX machine A to B or B to A, 0% packet loss, means connection established properly through firewall in port 1521.
Now we are setup one more UNIX machine C and installed a client here. This machine is available in different group, means if i give ping command from machine C to A, 100% packet loss. But from machine A to C, connection established with 0% packet loss.Because of this, when we tried to connect to a database from client in Machine C to database in Machine A, we got "time out" error.
My query is:
1. Is this because of not opening of port 1521 through firewall?
2. If so, is it enough to open port 1521 through firewall when we connect from machine C to A?
3. Any additional setup is required in firewall apart from opening of ports?
Environment:
Oracle 11.2.0.3
UNIX AIX 5.3/6.1
need to know how to connect remote database (ie my office oracle database) from my personal laptop. Using TOAD Software. me with the step by step procedure, and what software's I have to download.
View 26 Replies View RelatedI am having a application which is on Widows NT Operating system.I am using Oracle 10g Database, Developer suite 10g And 10g Application server.
My application uses Run_report_object to generate reports.Run_Report_Object is called in forms and Report server is configured in the same Application server where FMX are placed.
The report generation was working fine as long as oracle default login was used. When i created a form to handle login on my own, Report server is throwing "Unable to connect to database" error. My login forms takes the parameters from user and calls default logon command in on_Logon trigger.
Is it possible to connect with Oracle using C?
View 2 Replies View RelatedI am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.
View 1 Replies View RelatedI am currently using Oracle 10.2.0.1 version, in a single PC (test server) and MS-Access (2003) in it.
I was trying to use the logic of HS ODBC connectivity, but when i try to select the table from the MS-Access i am getting the following error.
"ORA-12154: TNS:could not resolve the connect identifier specified".
to create the successful connection between the MS-ACCESS and ORACLE. I just need to read some data from MS-ACCESS on a monthly base from a particular table.
i need a connectivity code to connect oracle DB in UNIX.pls send me a code exactly.
View 2 Replies View RelatedOracle 11g on linuxdestination : ms sql server 2005 i need to create the db link from oracle to ms sql server to view the tables , is it posibble without configuring the gateways( as looks like it is licenced product)
View 2 Replies View RelatedI am working on oracle and pl/sql since some time. so just a novice. I don't know much about sql server or transact sql, etc..I have a requirement to create an interface between Oracle and sql server.
we have a database on oracle and another on sql server. my requirement is to create an interface between oracle and sql server and see how can I update one (or more) tables (I am guessing using pl/sql) on sql server.
we have microsoft sql server, oracle gateway server (11G) and database server (10.2.0.5) we already make the full setup, and it's working.
we create materialized view into oracle server to read a data from sql server, but the refresh of MV take long time so we are planing to create the materialized view into oracle gateway server.
create MV into oracle gateway server?i mean i don't want to download oracle database instance for only one MV.
11.2.0.1. Using DG4ODBC to update data from oracle to sqlserver and vice-versa using dblinks?
View 6 Replies View RelatedWhat are the steps required to change an ORACLE stored procedure (on a AIX/UNIX machine) using OTG to connect to a DB2 database, to an ORACLE stored procedure that uses ODBC or JDBC connectivity?
All I need to do in the stored procedure is a simple insert statement into a DB2 table.
What kind of ODBC/JDBC driver do I need on the UNIX machine? unixODBC?
What would be different in the ORACLE stored procedure for it to use ODBC connectivity rather than OTG.
I want to connect CCTV camera with forms 6i. User can save the image or record a video either on File system or Database.
View 1 Replies View Related I get the following output for node connectivity check as part of pre clusterware installation checks.oracle@cps-oracle-1.homer.com% runcluvfy.sh comp nodecon -n cps-oracle-1,cps-oracle-2 -verbose
Verifying node connectivity
Verification of node connectivity was unsuccessful on all the nodes.
The above output i get for node connectivity component check. I pinged each public and private interface on node and found them to be working.The CRS is for Oracle10Gr2.
I 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.
select from the postgre databse works just fine (however when i select data column alone it returns as date, if i select it together with som condition in where clause it returns varchar).
-- this runs ok
select
t."idbill",
t."idpoint"
from "crm"."bills2points"@dl_carecloud t
,"crm"."bills"@dl_carecloud brg
where 1=1
and t."idbill" = brg."idbill"
and t."idbill" = 9685;
[code]....
How can I to connect and execute query from Oracle without to use others products ( DG4MSQL ....etc) ?using 9.2.08
View 5 Replies View RelatedI am trying to configure HS for Excel file. I am getting following error:
SQL> select table_name from all_tables@ODBCEXCEL;
select table_name from all_tables@ODBCEXCEL
*
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from ODBCEXCELHeres my setup:
[code]....
Oracle Corporation --- TUESDAY AUG 21 2012 11:17:46.685
Heterogeneous Agent Release 11.2.0.1.0 - 64bit Production Built with Oracle Database Gateway for ODBC
oracle server NLS_CHARACTERSET is UTF8 and mysql server Character set is UTF8, how should i configure the parameters HS_LANGUAGE(initsid.ora) and CHARSET(odbc.ini)? now i
configure the CHARSET = UTF8 and HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15,but the sql query reslut like this:
SELECT "id","name" FROM "accounts"@LNMYSQL
_______________________________________
xy-20120712-00016728 é士焱
the name Column is Garbled.
We are planning on interfacing Oracle to SQL server connectivity, I'm researching on how to create a dblink to SQL server 2005. I'm a little confused between Generic connectivity and Transparent Gateways..
I think Transparent Gateway is not free and needs to be licensed, is it better in terms of performance? Also, do I need to configure this gateway on a seperate server?
I think Generic connectivity can be configured on the same Oracle database server itself.. but I see there could be some performance issues with it..
We are running on Oracle 10.2, looks like HSODBC is not available in 10g?
We are trying to set up a RAC blade server in which they are 2nodes and runs under Linux x86-64 machine. We will be installing 11.2.0.3. The ASM disk has been created and we are in stage of installtion of GRID software. During the GUI installation we are getting below error.
INS-06003: Failed to setup passwordless SSH connectivity with the following
The SSH are working fine when we do manually. But through GUI during installtion it is not. The port which we are using here for connectivity is 2222 instead of the default ports. As per the one of thread in OTN discussion I checked port specification of /etc/ssh/ssh_config file in both the servers. It is 2222.
Oracle 11gR2
Linux 6.x
Sybase 12 (on Windows)
unixODBC 3.2.x
Sybase Client 12
------------------------
Given the following files or structures that are important to the proper operation of the ODBC Gateway connecting to a remote Sybase database:
listener.ora
tnsnames.ora
initmydblink.ora ( my version of the initdg4odbc.ini )
dblink (not a file but the dblink in the Oracle database)
odbc.ini
odbcinst.ini
What files (and what properties within those files) may/must be changed if the remote Sybase db and system is different (i.e. the Sybase database source has been changed to something 'new')? For example, I can that the odbc.ini file is going to have to be alterer to point to the new database server IP address, database port, database name?
i have created the DB LINK from Oralce 11gR2 to MS Sql Server 2005,able to access the view of Sql Server from Oralce,but the Columns which have Datatype nvarchar(max) in Sql Server am not able to access through DB Link.
View 1 Replies View RelatedI got a primary database with a logical standby database running Oracle 11g. I got two client applications, one is the production site pointing to the primary one, another one is just a backup site pointing to the logical one.Things will only be written into the primary database every mid night and client applications can only query the database but not add, update nor delete.And now, I want to apply the latest patch on both of my databases. I am also the DNS administrator, I can make the name server pointing to the backup site instead of the production one.I want to firstly apply the patch on the logical one, and then the physical one.
I found some reference which explains how to apply patches by adopting "Rolling Upgrade Method". however, I want to avoid doing any "switch over" mentioned in the reference because I can make use of name server. Can I just apply patches as the following way?
1)Stop SQL apply
2)Apply patches on logical standby database
3)let the name server point to the backup site
4)Apply patches on the primary database
5)Start SQL apply
6)Let the name server point back to the production site
i want to convert oracle database(schema data) to postgresql database
which tool would be best and url to download and steps to convert from one database to another ?
Can we use M.S Sql Server Database with Forms 6i with out oracle database install.
View 1 Replies View RelatedI'm trying to migrate a mySQL database into an Oracle database.
View 7 Replies View Related