SQL & PL/SQL :: ORA-00904 Reading Via Dg4SQL Gateway From SQL Server 2008

Feb 11, 2011

I have trouble reading a field called "Description" from a SQL Server 2008 DB using the gateway:

SQL> select "Description"
from opportunity@mscrm
select "Description"
from opportunity@mscrm
*
Error at line 1
ORA-00904: "Description": ungültiger Bezeichner

My first thought was, that "Description" was a reserved word in Oracle but it's not:

SQL> create table delete_this ("Description" varchar2 (50 char))
Table created.
SQL> select "Description" from delete_this
no rows selected.

So everythings fine here. Then I thought, that I might have mispelled the column name, but no:

SQL> select column_name
from v_mscrm_tab_columns
where table_name = 'opportunity'
and column_name like 'Desc%'

[code]....

View 3 Replies


ADVERTISEMENT

Networking And Gateways :: Oracle Gateway For MS SQL Server

Mar 11, 2013

I want to connect ORACLE-11gR2 that is on linux with an MS sql server. DO i need to use some third party drivers like easy soft ? Can i configure the database gateway without any third party drivers ?

Secondly if my oracle is on linux, can i configure the gateway on a seperate windows machine(that will connect to linux oracle and ms sql server) as i have found the gateway installation setup only for windows version.

View 3 Replies View Related

Networking And Gateways :: Where To Download The Oracle Gateway For Sql Server

Dec 5, 2011

where can i download the oracle gateway for sql server? i can't find the download web site .

View 4 Replies View Related

Networking And Gateways :: Running DML Statement On Oracle Transparent Gateway For SQL Server?

Dec 5, 2011

how can i run dml statement on the oracle transparent gateway for sql server ,such as insert ,update,delete.

View 4 Replies View Related

Server Utilities :: Impdp Procedure Or Function 10.2.0.4 Error ORA-00904

Sep 16, 2011

I have error ORA-00904: "USERNAME" : identificateur non valide. What is the problem ?

My command impdp :
impdp datapump/password@%ORACLE_SID% DIRECTORY=datapump schemas=gcom INCLUDE=PROCEDURE remap_tablespace=gpao_indx:indx remap_tablespace=gpao_data:data DUMPFILE=%ORA_DUMPFILE% LOGFILE=Imp_%annee%%mois%%jour%%hh%%min%%sec%_%ORACLE_SID%.log

The result :
;;;
Import: Release 10.2.0.4.0 - Production on Jeudi, 15 Septembre, 2011 17:47:16

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connecté à : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Table maître "DATAPUMP"."SYS_IMPORT_SCHEMA_29" chargée/déchargée avec succès

[Code]....

View 2 Replies View Related

Server Utilities :: ORA-00904 POLTYP / Invalid Identifier When Export

Jan 26, 2012

First I got errors when I did the export with an export tool of Release 11.1.0.7.0 and there were lot of ORA-00904 and ORA-01003 like the following:

XP-00008: ORACLE error 904 encountered
ORA-00904: "MAXSIZE": invalid identifier
. . exporting table XRATE_INFO
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed

Then I tried to do export with another version of export tool (Release 10.2.0.4.0) The errors changed to the follwing:

.about to export FM's tables via Direct Path...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully

The export tool I used is of Release 10.2.0.4.0

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

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

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

Server Utilities :: Reading From Oracle Dump

Jun 14, 2006

Is there is any way of reading from oracle dump file?

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

Connect Win 2008 32 Bit Server And Win 7 64 Bit Client?

Jul 17, 2012

can connect a 64 bit Oracle 11g Release 2 on a Windows 7 client with a 32 bit Oracle 11g Release 2 on a Windows 2008 server?

View 5 Replies View Related

SQL & PL/SQL :: Ftp File To Remote Server By Reading Data From Table?

May 1, 2012

I need a way to ftp file to remote server by reading data from table. I searched a couple of sites which asked me to use Chris xutl_ftp package..but unfortunately the site is no accessible..

Here is the code

CREATE OR REPLACE PACKAGE UTL_FTP
AUTHID CURRENT_USER
AS
/**
* LICENSE: GNU Lesser General Public License (LGPL)
* Copyright (C) 2003-2006 Russ Johnson (john_2885@yahoo.com)

[code].....

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

Ora-12560 When Creating Database In 2008 Server

Aug 14, 2010

i have win 2008 server and oracle 10g when im try to install oracle it terminate successfully but when insall domain controller in windows , oracle dont terminate the installation and break in creating data base (2%) and return the error message : ora-12560 tns adaptator protocol error

View 1 Replies View Related

Forms :: Version 10.1.2.0.2 With Windows Server 2008 64 Bit

Dec 12, 2011

is Forms [32 Bit] Version 10.1.2.0.2 not supported with Windows Server 2008 64 bit ?? i tried to install it and it was failed.!

View 2 Replies View Related

Windows :: How To Schedule Backup On 2008 Server

Jun 27, 2010

On windows 2008, need to schedule task for database backup.

View 4 Replies View Related

Windows :: How To Install Oracle 11g In Server 2008 R2

Dec 24, 2011

How to install oracle 11g in Window Server 2008 R2.

View 6 Replies View Related

Enterprise Manager 11g On Windows Server 2008 R2 X64

Oct 18, 2012

EM displays: Enterprise Manager is not able to connect to the database instance

And yest the Database Instance status show open and the instance is up; Listener status is Up; Agent Connection to Instance status is Succeeded (but no details)

emctl status dbconsole shows ""Oracle Enterprise Manager 11g is running"

emctl status agent shows "Agent is Running and Ready"

I can connect with SQL Developer and see everything in the database.

View 11 Replies View Related

10.2.0.5 Patch On Windows 2008 Server R2 64bit

Apr 28, 2011

I have HP server with Windows 2008 Server R2 64bit. I installed latest 64-bit version of Oracle Database 10.2.0.4 and everything works fine and later installed the patch 10.2.0.5 (64 bits) as the Oracle maintains that with the R2 version of the system it is necessary to correct work.

Now, after uploading the patch database starts and closes after about 15 minutes - an additional log file is changed to the binary version which do not see anything.

how to solve problem? The move to Oracle 11 drops.

This is the link to my alert log file (it's strange after 10.2.0.5 patch installation):

[URL].......

I attached my spfile.ora file too:

[URL].......

View 1 Replies View Related

How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server...So far i have just installed the oracle software on 64bit windows 2008 server.how to move the data or migrate from old server to new server..

View 1 Replies View Related

Windows :: Accessing Oracle 7 Database From Server 2008

Jan 11, 2013

We have been upgrading our servers to Server2008 and are getting..

[ORA-3134: Connections to this server version are no longer supported.]

..using the drivers we used to use in XP and Server2003 to access a legacy Oracle7 db. Connections to this db are needed for typical CRUD functionality by multiple applications, some written in Classic ASP and some in C# .NET 3.5 & 4.0. I have tried ODBC drivers (System.Data.Odbc) and also ODP (Oracle.DataAccess.Client) to no avail.

Any existing driver solution to make this connection without have to resort to a custom HLI interface?

I would think we aren't the only ones needing to access Oracle7 from Server2008.

View 7 Replies View Related

Networking And Gateways :: Oracle 9i To Sql Server 2008 R2 Migration?

Apr 2, 2013

We are having oracle 9i as database and migrating to sql server 2008. Our oracle 9i database connects to another oracle databases and these databases are having different oracle version(9.2.0.8.0, 9.2.0.7.0,10.2.0.5.0,11.2.0.2.0,9.2.0.6.0,10.2.0.4.0,8.1.7.4.0 )

I do have two queries :

1) how to connect from Sql server 2008 R2 to different Oracle databases

2) How will other oracle databases connect to Sql server 2008 R2 database

View 2 Replies View Related

Windows :: Installing 6i Forms On Server 2008 64bit?

Mar 12, 2012

Can I installed 6i forms on windows server 2008 64bit.

View 2 Replies View Related

How To Download Oracle 10gR2 To Windows 2008 Server R2

Jun 27, 2012

I'm trying to download Oracle RDBMS 10.2.0.5 for Windows Server 2008 R2. But i don't see it on OTN or edelivery....i can't find any link...Have i to request a SR on metalink?

View 2 Replies View Related

Apply Patch 13 To 11.2.0.3 Database For Windows Server 2008 R2?

Nov 27, 2012

I want to apply patch 13 to 11.2.0.3 database for windows server 2008 R2. I saw the pre requisites and found that opatch should be 11.2.0.1.9 or later. My optach is 11.2.0.1.7. I downloaded the patch # 11846294 and unzipped under the opatch directory. In one of the step it asked me to run the following command

$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps <bundle patch location>

but then it says oplan is not recognized. I have set the Oracle_home and path variable

my path is C:Oraclegrid_homein;C:Oracledbhome_1in;C:Oraclegridin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesArcGISArcSDEora11gexein;C:Program FilesXIVhost_attachin;C:Oracledbhome_1oplan

Note that my database version is 11.2.0.3 with ASM

View 7 Replies View Related

Data Guard :: Logical Standby On Windows Server 2008

Sep 8, 2010

Can i create logical_stand_by for windows server 2008, the primary data base is HP UX , both operating systems are 64 bits and data bases are Oracle 10g 10.2.0.1.0.

View 6 Replies View Related

Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit

Oct 6, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.

Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit

I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).

View 4 Replies View Related

Forms :: (32Bit) Version 10.1.2.0.2 Crashed With Windows Server 2008 64bit

Dec 19, 2011

i need to upgrade this version to 10.1.2.3, and i don't have an account in metalink to download the patch.

View 11 Replies View Related

Messaging Gateway - UnsatisfiedLinkError

Aug 29, 2011

I have 11g RAC database in Solaris 10 - 64bit server. When i start messaging gateway agent in node1, it goes fine. But in node2, i am getting the following error.

java.lang.UnsatisfiedLinkError: /usr/app/oracle/product/11.1.0/lib/libocijdbc11.so: Can't load Sparc v9 64-bit .so on a Sparc 32-bit platform

I tried 467166.1 note but it didn't sort out the issue.

View 1 Replies View Related







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