Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
40 Search Results Found
1 Forum: Networking and Gateways «» Posted on: Wed, 19 September 2018 08:55 «» By: saterp
Not able to connect to Oracle(12c) to progress using Oracle database gateway(12c) for ODBC
Need help to connect the Oracle and Progress Database using Oracle gateway for ODBC. Server1: I configured the database server TNS.ora and listner.ora entries like below. Listener.ora: --start of listener file--- SID_LIST_LISTENER = (SID_LIST ...
2 Forum: Server Administration «» Posted on: Mon, 29 January 2018 10:17 «» By: marcossantos
ORA-01012 ORA-02063 ORA-02396 Database Link Disconnect
Hi all, I get the following error: Error in cleaning up 2PC subordinates; error stack: ORA-01012: not logged on ORA-02063: preceding line from CAD_MGBR ORA-02396: exceeded max Idle Time, please connect again Can someone help? Thanks
3 Forum: Networking and Gateways «» Posted on: Fri, 28 April 2017 04:39 «» By: edwin2017
Oracle for Linux Access SQLserver Through dblink issue
Hi, everybody: My English is not good, so if my describe have some mistake plese don't care. Ok, let me speak my question. the test environment is: windows 64 / sqlserver 2008 64bit linux32 / oracle 11.2.0.4 32bit I want access sql ...
4 Forum: SQL & PL/SQL «» Posted on: Thu, 15 December 2016 02:30 «» By: mist598
ORA-01722: invalid number ORA-02063: preceding line from
Hi All, I am querying below simple statement select * from xxc_audit.xxc_number@apps_to_flexprod where SERIAL_NUMBER='ABG108' ORA-01722: invalid number ORA-02063: preceding line from APPS_TO_FLEXPROD can u please help me why it is showing th...
5 Forum: Networking and Gateways «» Posted on: Wed, 07 December 2016 02:57 «» By: dileepkallone
Re: Generic Connectivity Not Working (Oracle -MYSQL)
Hi, I am facing an issue while connecting to MySQL database from Oracle (11.2.0). The below error is popping up while testing the database link. Anyone, please help!. An error was encountered performing the requested operation: ORA-28545: error di...
6 Forum: SQL & PL/SQL «» Posted on: Tue, 17 May 2016 09:32 «» By: mjm22
MEMBER OF condition across DB Link
Hi, I have come across a scenario that I am struggling to understand... I am trying to insert to a table a subset of values selected form another table on a remote database. The selection is controlled via a MEMBER OF condition that limits the select...
7 Forum: SQL & PL/SQL «» Posted on: Tue, 26 April 2016 13:54 «» By: Michel Cadot
Re: error creating external via dbms_utility.exec_ddl_statement@myDB
You can do it using dbms_utility.exec_ddl_statement: SQL> exec dbms_utility.exec_ddl_statement@mika('create table xxx (id int)') PL/SQL procedure successfully completed. SQL> desc xxx@mika Name Null? Type -...
8 Forum: Networking and Gateways «» Posted on: Tue, 29 March 2016 05:12 «» By: hisham99
Re: connection to sqlserver using odbc
Error report - SQL Error: ORA-28500: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified {IM002} ORA-02063: 2 lines من MULTIMAXTXN 28500. 00000 - "connection from ORACLE to a non-Oracle system returned...
9 Forum: SQL & PL/SQL «» Posted on: Wed, 04 March 2015 13:05 «» By: ecivgamer
complete refresh of materialized view works fine, but non-complete doesn't
Hi all, Complete refresh of materialized view works fine, but non-complete doesn't. begin DBMS_SNAPSHOT.REFRESH('SNAP_AP_PAY_SCHED','C'); end; PL/SQL procedure successfully completed. begin DBMS_SNAPSHOT.REFRESH('SNAP_AP_PAY_SCHED'); end...
10 Forum: SQL & PL/SQL «» Posted on: Tue, 17 February 2015 09:36 «» By: qanita786
Re: how to grant database link to user
I Create a User By Name Faheem in Both Database and Assign a Selection of Data Role When i apply This Command Following Error Occured select path from interface@link2014 * ERROR at line 1: ORA-00942: table or view does not exist ORA...
11 Forum: Networking and Gateways «» Posted on: Wed, 11 February 2015 04:31 «» By: zeeshan047
ORA-28511: lost RPC connection to heterogeneous remote agent using
hello, I have use oracle11g r2 gateway for linux 64 bit and mysql-connector-odbc-5.1.13-1.rhel5.x86_64 and created dblink to access mysql database from oracle 11gr2, I am facing below error. ORA-28511: lost RPC connection to heterogeneous remote a...
12 Forum: SQL & PL/SQL «» Posted on: Tue, 18 November 2014 10:35 «» By: ecivgamer
Re: error when trying to refresh materialized view
The source of materialized view: SELECT column1, column2 FROM scheme1.table1@dblink1 ORA-01882: timezone region not found ORA-02063: preceding line from PRODFIN 01882. 00000 - "timezone region not found" *Cause: The specified r...
13 Forum: Client Tools «» Posted on: Mon, 27 October 2014 09:58 «» By: Analyst
Re: Importing Hebrew, using ODBC from Excel
I changed the NLS_LANG registry value to AMERICAN_AMERICA.AL16UTF16 and restarted my SQL Developer. Now I get a new error, while trying to import to Oracle from the same Excel file: ORA-28545: Net8 אבחן שגיאה במהלך ההתחברות לסוכן Unable to retrieve te...
14 Forum: SQL & PL/SQL «» Posted on: Mon, 29 September 2014 22:50 «» By: vjeedigunta
group by to_char resulting in Exception: ORA-00979: not a GROUP BY expression
hi , I am trying to write a query to display count(total per month) and count(defects per month ) from a table grouping it by month wise. I am getting error as below .. do you know what could be the issue here ? select to_char(openat,'MM-YYYY'), c...
15 Forum: SQL & PL/SQL «» Posted on: Sun, 17 August 2014 19:33 «» By: Oracle_Walker
ORA-04052 Error - URGENT
All, I am facing an issue while executing the below command through an SQL, EXECUTE IMMEDIATE 'BEGIN MV_REFRESH@EPT_CTA('''||'CGT_WLT_SALE'''||','||'''C'''||'); END;'; Below is the error thrown, ORA-04052: error occurred when looking up rem...
16 Forum: SQL & PL/SQL «» Posted on: Thu, 29 May 2014 05:44 «» By: muktha_22
Re: View on synonym
Hi, This is a normal process of processing data from Oracle into SQL server through Heterogeneous. Working fine so far. Now there is a synonym in sql server, we want to create a view on that in oracle end to process data. It shows the below error...
17 Forum: Networking and Gateways «» Posted on: Tue, 13 May 2014 06:55 «» By: bijuandenb
Re: Read Data from MS Sql Server - Oracle Client
Dear all, I had misplaced the tnsnames.ora file in a different folder, than the required Oracle Client folder Now it is placed correctly, so now TNSPING EMPWR is pinging OK The second part, I run an SQL command in SQLPlus, in my client PC, but still it...
18 Forum: Networking and Gateways «» Posted on: Tue, 13 May 2014 05:45 «» By: bijuandenb
Read Data from MS Sql Server - Oracle Client
I wanted to access to the data from tables of MS Sql Server residing on a Server, using an Oracle Client 11g through SQL Plus. Had setup ODBC from Oracle Database Server, TNSPing was working ok. But from my PC, through SQL, it gives below error on an sql...
19 Forum: Networking and Gateways «» Posted on: Tue, 29 April 2014 02:10 «» By: x-oracle
Re: how to connect oracle forms with ms sql server 2008
thanks again blackswan ok hostname is torcl now where i install my oracle db i am sending you listiner file also here please help me to modify my listiner file LSNRCTL> start Starting tnslsnr: please wait... TNSLSNR for 32-bit Windows: Vers...
20 Forum: Networking and Gateways «» Posted on: Fri, 25 April 2014 07:17 «» By: x-oracle
Re: how to connect oracle forms with ms sql server 2008
please help me in this john i did all this step as you give me this link but still i am getting this error C:\oracle\product\10.2.0\db_1\hs\admin\inittest.ora # HS init parameters # HS_FDS_CONNECT_INFO = test HS_FDS_TRACE_LEVEL = 0 # ...
21 Forum: SQL & PL/SQL «» Posted on: Thu, 24 April 2014 00:17 «» By: Littlefoot
Re: ORA-28002 error while connecting DB LINK
If I understood the "password" question, you wonder what happens when target database link user's password changes. DB link won't work any more, so you'll have to recreate it. Here's an example: SQL> show user USER is "SCOTT" SQL&...
22 Forum: Networking and Gateways «» Posted on: Tue, 22 April 2014 05:28 «» By: x-oracle
Re: how to connect oracle forms with ms sql server 2008
thanks for your reply little foot but i already read it this before and i follow all this steps still i am getting this error LSNRCTL> stop Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) The command completed successfully LSN...
23 Forum: Networking and Gateways «» Posted on: Mon, 21 April 2014 05:43 «» By: x-oracle
how to connect oracle forms with ms sql server 2008
here i did steps i want to connect my oracle database with ms sql server 2008 first of all i create " initsqlserver1.ora file at "C:\Oracle\product\10.2.0\db_1\hs\admin" # ODBC DSN HS_FDS_CONNECT_INFO = sqlserver1 HS_FDS_TRACE_L...
24 Forum: Networking and Gateways «» Posted on: Mon, 14 April 2014 00:28 «» By: usmanelahi
connect sql database from oracle
Hello gurus I am trying to connect sql server from oracle via db link with below options Option 1: 1. Oracle db 11.12 on AIX 64 bit 2. Sql server 2008 on Windows 7 64 bit (seperate machine) i installed oracle software only on sql server machi...
25 Forum: Networking and Gateways «» Posted on: Mon, 24 March 2014 09:30 «» By: Oussama
Configuring Oracle gateway for MS SQL Server
Hi everyone, I have two Windows XP machines connected as a LAN : machine named oracle and another machine named sqlserver (the host name) I have installed the Oracle database software on the first one (11g R2) and the SQL SERVER 2008 R2 software on t...
26 Forum: SQL & PL/SQL «» Posted on: Thu, 27 February 2014 15:54 «» By: Duane
Re: Open Cursor for with an Exception Clause
Nothing to do with ASP.net. SQL error. From what I can tell, the query fails but it doesn't run the next exception but runs the bottom exception in the original query code. select some...columns.... from some table ...
27 Forum: Networking and Gateways «» Posted on: Tue, 31 December 2013 08:36 «» By: GirishSharma
Read SQL Server table from Oracle
Hi, Oracle 11.2.0.1 Windows XP Prof Edition After creating DSN name opd when I tried to connect sql server Enterprise Edition 2005 database on the same PC, I failed to establish connectivity. Here it is what I have and done : C:\Documents and...
28 Forum: SQL & PL/SQL «» Posted on: Mon, 16 December 2013 00:41 «» By: sss111ind
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit
Hi All, We are USING A dblink TO get THE DATA AND showing A report.But sometime it IS throwing AS follows AND THE whole PACKAGE got invalidated. And after this we have to compile it manullay to get the package work correct. Error(1): ORA-04052: ...
29 Forum: Networking and Gateways «» Posted on: Sat, 07 September 2013 06:11 «» By: Manoj.Gupta.91
ORA-28500 : While selecting SQL Server data in Oracle [HSODBC]
Hi All, I'm facing ORA-28500 error while configuring HSODBC to SQL Server. Below is the complete information related to listener.ora, sqlnet.ora and tnsnames.ora files. Listener status is showing dg4msql instance successfully started. I guess I'm...
30 Forum: SQL & PL/SQL «» Posted on: Thu, 22 August 2013 06:58 «» By: noflyingzone
Re: Query over dblink from orecle9 to oracle11
I run the right query in SQL*Plus and also in TOAD and I get all record without problem. SQL> SELECT mcccdsoc, mcccdfor, mccdsfor 2 FROM my_table_owner.mcttbfor 3 WHERE mcccdsoc = 'XX' 4 GROUP BY mcccdsoc, mcccdfor, mccds...
31 Forum: SQL & PL/SQL «» Posted on: Thu, 22 August 2013 04:19 «» By: noflyingzone
Re: Query over dblink from orecle9 to oracle11
Yes correct You said originally said the transformation was adding rowid, not removing group by. Indeed the error message suggests group by remains. Start from the beginning and give us the following: 1) sql for db link 2) sql to create the tab...
32 Forum: Networking and Gateways «» Posted on: Tue, 30 July 2013 04:22 «» By: sakamboh
UNABLE TO TEST DBLINK BETWEEN ORACLE XE and MSSQL
Hello All, can anyone please guide me the below issue, i have created a dblink between oracle and mssql and tried testing the link its giving me below error. Can anyone please help me out with this. SQL Error: ORA-28500: connection from ORACLE to a...
33 Forum: SQL & PL/SQL «» Posted on: Wed, 24 July 2013 05:32 «» By: sayan13
Re: Date Values difference
SELECT /*+DRIVING_SITE(R,100)*/ R.PRIMARY_ASSET_ID, R.SECURITY_ALIAS, R.LAST_HELD_DATE, R.PREV_HELD_DATE, R.last_held_date-'21-Jun-2013' FROM ADMIN.SECURITIES@PROD.WORLD R WHERE R.last_held_date is NOT NULL order by 5 desc I am getting a in...
34 Forum: SQL & PL/SQL «» Posted on: Thu, 06 June 2013 07:57 «» By: gatetec
Re: Running queries of 2 different SID on 1 Pane
it is odd.. I created and tried more, but the same error. ERROR at line 1: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from ENIP182 ERROR at line 1: ORA-01017: invalid username/password; logon denied ORA-0206...
35 Forum: SQL & PL/SQL «» Posted on: Thu, 06 June 2013 07:47 «» By: Littlefoot
Re: Running queries of 2 different SID on 1 Pane
Besides, fact that you "created" database link doesn't mean that it really works. Have a look: SQL> create database link db_stupid_1 2 connect to whats_that_huh 3 identified by kljfjklf890234fsfjkl 4 using 'jklasdhflkajsdf'; Da...
36 Forum: SQL & PL/SQL «» Posted on: Thu, 06 June 2013 07:27 «» By: gatetec
Re: Running queries of 2 different SID on 1 Pane
Thank you for the tip. I tried the following steps. On the **DB server**, I added the entry to the tnsnames.ora: ADMINDBG_RO.WORLD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ENIP182)(PORT = 1539)) ) ...
37 Forum: Networking and Gateways «» Posted on: Wed, 27 March 2013 06:01 «» By: Littlefoot
Re: EXCEPTION HANDLING for DBLINK In TRIGGERS
This is, most probably, not the best way to do that (but I don't know better). Therefore, until someone smarter than me offers a solution, here's one option. It is based on a presumption that you don't really care WHY insert over a database link failed, as...
38 Forum: Replication «» Posted on: Fri, 20 July 2012 02:21 «» By: zeeshan007
Materialized view creation Error
Dear ALL, I have a problem in execution of below mentioned Replication script,My destination DB is ORACLE 11gR2 which is running on Linux PLATFORM and remote DB is ORACLE 10gR2 running on Linux. furthermore I have a DBA privilege I also test my DB...
39 Forum: Networking and Gateways «» Posted on: Mon, 09 July 2012 02:31 «» By: moulshree
Materialized view data replication
I have two servers: 10g server 10.1.4.30 11g server 10.1.4.32 I have a table testing_mview on 10g which do not have any primary key. I have created MV log for it: CREATE MATERIALIZED VIEW LOG ON testing_mview WITH ROWID; Materialized view log c...
40 Forum: French «» Posted on: Wed, 25 April 2012 11:10 «» By: dblanchard
Gateway installation on same machine as Oracle Database
Le serveur Oracle doit lire des tables stockées dans un serveur Sybase. Je vais créer des database link. D'abord j'ai installé Oracle Database Gateway pour Sybase sur la même machine que le serveur Oracle mais dans un ORACLE_HOME distinct mais j'ai un p...

Current Time: Tue Jun 18 15:46:04 CDT 2019