Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator
41 Search Results Found
1 Forum: Application Express, ORDS & MOD_PLSQL «» Posted on: Thu, 16 January 2020 04:58 «» By: AdrianWard
Create View Error Message
…line 592 ORA-02063: preceding line from XX_APEX_DBLINK ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_190200", line 578 ORA-06512: at "APEX_190200.WWV_FLOW_DYNAMIC_EXEC", line 2057 Now I…
2 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
…retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from SP2 " SP2 is a DB link pointing to GW_TO_PROG service name. I would like to know the what changes i need to do in each of the home(oracle and gateway) with …
3 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
4 Forum: Networking and Gateways «» Posted on: Fri, 28 April 2017 04:39 «» By: edwin2017
Oracle for Linux Access SQLserver Through dblink issue
…a non-Oracle system returned this message: ORA-02063: preceding line from MSSQL # the /tmp/mssql.log is nothing record when the error happens. but the log should be loging information when connected to the remote database(such as use isql mssql2008…
5 Forum: SQL & PL/SQL «» Posted on: Thu, 15 December 2016 02:30 «» By: mist598
ORA-01722: invalid number ORA-02063: preceding line from
…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 the above error? Thank You…
6 Forum: Networking and Gateways «» Posted on: Wed, 07 December 2016 02:57 «» By: dileepkallone
Re: Generic Connectivity Not Working (Oracle -MYSQL)
…retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQL 28545. 0000 - "error diagnosed by Net8 when connecting to an agent" *Cause: An attempt to call an external procedure or to issue SQL to a non-…
7 Forum: SQL & PL/SQL «» Posted on: Tue, 17 May 2016 09:32 «» By: mjm22
MEMBER OF condition across DB Link
…am unsure exactly why this is. Insert into local table using data from local table Item is A Thingy Item is Another Thingy Insert into local table using data from dblink ORA-00902: invalid datatype ORA-02063: preceding line from ADM…
8 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
… NUMBER(38) SQL> exec dbms_utility.exec_ddl_statement@mika('drop table xxx') PL/SQL procedure successfully completed. SQL> desc xxx@mika ERROR: ORA-04043: object xxx does not exist ORA-02063: preceding line from MIKA…
9 Forum: Networking and Gateways «» Posted on: Tue, 29 March 2016 05:12 «» By: hisham99
Re: connection to sqlserver using odbc
…and no default driver specified {IM002} ORA-02063: 2 lines من MULTIMAXTXN 28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:" *Cause: The cause is explained in the forwarded message. *Action: See the…
10 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
…table or view does not exist ORA-02063: preceding line from PLSDW ORA-02063: preceding 2 lines from PRODFIN.PLSPRO.COM ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025 ORA-06512: at "…
11 Forum: SQL & PL/SQL «» Posted on: Tue, 17 February 2015 09:36 «» By: qanita786
Re: how to grant database link to user
…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-02063: preceding line from LINK2014…
12 Forum: Networking and Gateways «» Posted on: Wed, 11 February 2015 04:31 «» By: zeeshan047
ORA-28511: lost RPC connection to heterogeneous remote agent using
…preceding line from DBLINK Process ID: 52680 Session ID: 11 Serial number: 4854 odbc.ini ********* [ODBC Data Sources] demo = MySQL ODBC Driver 5.1 [demo] Driver = /usr/lib64/libmyodbc5.so DATABASE = prayertimings DESCRIPTION = …
13 Forum: SQL & PL/SQL «» Posted on: Tue, 18 November 2014 10:35 «» By: ecivgamer
Re: error when trying to refresh materialized view
…timezone region not found ORA-02063: preceding line from PRODFIN 01882. 00000 - "timezone region not found" *Cause: The specified region name was not found. *Action: Contact Oracle Support Services. Error at Line: 33 Column: 25 …
14 Forum: Client Tools «» Posted on: Mon, 27 October 2014 09:58 «» By: Analyst
Re: Importing Hebrew, using ODBC from Excel
…retrieve text of NETWORK/NCR message 65535 ORA-02063: שגיאה מקדימה 2 lines מתוך ODBC_IMPORT_ANALYST 28545. 0000 - "error diagnosed by Net8 when connecting to an agent" *Cause: An attempt to call an external procedure or to issue SQL…
15 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
…t1, table2@db_link_name t2 where t1.col1=t2.col1 and openat between start_date and end_date group by to_char(openat,'MM-YYYY'); Exception: ORA-00979: not a GROUP BY expression ORA-02063: preceding line from db_link_name Please suggest…
16 Forum: SQL & PL/SQL «» Posted on: Sun, 17 August 2014 19:33 «» By: Oracle_Walker
ORA-04052 Error - URGENT
…remote object USR_PT_CH02.MV_REFRESH@EPT_CTA.WORLD ORA-00604: error occurred at recursive SQL level 2 ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from EPT_CTA Please help me how to research and fix this issue ASAP…
17 Forum: SQL & PL/SQL «» Posted on: Thu, 29 May 2014 05:44 «» By: muktha_22
Re: View on synonym
…Driver][SQL Server]Invalid object name '...........'. {42S02,NativeErr = 208}[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. {42000,NativeErr = 8180} ORA-02063: preceding 2 lines from HS_ODBC_TEST Regards Muktha…
18 Forum: Networking and Gateways «» Posted on: Tue, 13 May 2014 06:55 «» By: bijuandenb
Re: Read Data from MS Sql Server - Oracle Client
…at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from EMPWR Can someone pls look and help me urgently. Thanks…
19 Forum: Networking and Gateways «» Posted on: Tue, 13 May 2014 05:45 «» By: bijuandenb
Read Data from MS Sql Server - Oracle Client
…retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from EMPWR Can someone pls explain to me the steps which I have followed are correct or not? And what could be the reason for the above errors. What is the best way to read data…
20 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
…(ADDRESS = (PROTOCOL = TCP)(HOST = torcl)(PORT = 1521)) ) SQL> DESC EMP@TEST ERROR: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from TEST…
21 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
…retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from TEST SQL> C:\Documents and Settings\Administrator>TNSPING TEST TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 25-APR-2 014 17:43:27…
22 Forum: SQL & PL/SQL «» Posted on: Thu, 24 April 2014 00:17 «» By: Littlefoot
Re: ORA-28002 error while connecting DB LINK
…connect scott/tiger@ora10 Connected. SQL> select * from dual@dbl_mike; select * from dual@dbl_mike * ERROR at line 1: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from DBL_MIKE SQL>…
23 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
…= TCP)(HOST = tap)(PORT = 1522)) ) ) SQL> desc emp@sqlserver1 ERROR: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from sqlserver1…
24 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
…error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from sqlserver1 please any one give me steps of how to connect oracle database with ms sqlserver 2008…
25 Forum: Networking and Gateways «» Posted on: Mon, 14 April 2014 00:28 «» By: usmanelahi
connect sql database from oracle
…retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MICRO i searched and found the mixing of 32 or 64 drivers what is the resolution do i need to install oracle database gateway driver is that the same install sofware only …
26 Forum: Networking and Gateways «» Posted on: Mon, 24 March 2014 09:30 «» By: Oussama
Configuring Oracle gateway for MS SQL Server
…connection string attribute {01S00} ORA-02063: preceding 2 lines from DBLINK my initdg4msql file : # This is a customized agent init file that contains the HS parameters # that are needed for the Database Gateway for Microsoft SQL Server…
27 Forum: SQL & PL/SQL «» Posted on: Thu, 27 February 2014 15:54 «» By: Duane
Re: Open Cursor for with an Exception Clause
…in the original query code. select some...columns.... from some table where empid = 'my employee id' ORA-01722: invalid number ORA-02063: preceding line from db3 Mod Edit: removed column names…
28 Forum: Networking and Gateways «» Posted on: Tue, 31 December 2013 08:36 «» By: GirishSharma
Read SQL Server table from Oracle
…and no default driver specified {IM002} ORA-02063: preceding 2 lines from OPD SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real …
29 Forum: SQL & PL/SQL «» Posted on: Mon, 16 December 2013 00:41 «» By: sss111ind
Re: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit
…simultaneous SESSIONS_PER_USER LIMIT ORA-02063: preceding line from alr_dblink Why THE above ERROR IS happening AT regular basis AND how can it resolved. What IS MAIN cause OF THE above ERROR. IF we have reached THE MAX SESSIONS_PER_USER THEN we …
30 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]
…connection string attribute {01S00} ORA-02063: preceding 2 lines from DBLNK_AVL_CLUSTER2 28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:" *Cause: The cause is explained in the forwarded message. *…
31 Forum: SQL & PL/SQL «» Posted on: Thu, 22 August 2013 06:58 «» By: noflyingzone
Re: Query over dblink from orecle9 to oracle11
…1: ORA-00979: not a GROUP BY expression ORA-02063: preceding line from MCD_MCD_MCDRET11 Probably it isn't a problem of Oracle,DbLink... but something else with ODBC driver and Visual Basic…
32 Forum: SQL & PL/SQL «» Posted on: Thu, 22 August 2013 04:19 «» By: noflyingzone
Re: Query over dblink from orecle9 to oracle11
…the exact error message Source : Microsoft OLE DB Provider for Oracle Error : ORA-00979: not a GROUP BY expression ORA-02063: preceding line from MCD_MCD_MCDRET11 6) The exact version of both DBs oracle9 9.2.0.8 oracle11 11.2.0.3…
33 Forum: Networking and Gateways «» Posted on: Tue, 30 July 2013 04:22 «» By: sakamboh
UNABLE TO TEST DBLINK BETWEEN ORACLE XE and MSSQL
…and no default driver specified {IM002} ORA-02063: preceding 2 lines from MSSQL 28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:" *Cause: The cause is explained in the forwarded message. *Action: See…
34 Forum: SQL & PL/SQL «» Posted on: Wed, 24 July 2013 05:32 «» By: sayan13
Re: Date Values difference
…ADMIN.SECURITIES@PROD.WORLD R WHERE R.last_held_date is NOT NULL order by 5 desc I am getting a invalid number exception in this case. ORA-02063…
35 Forum: SQL & PL/SQL «» Posted on: Thu, 06 June 2013 07:57 «» By: gatetec
Re: Running queries of 2 different SID on 1 Pane
…invalid username/password; logon denied ORA-02063: preceding line from ENIP182 ERROR at line 1: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from ENIP182NEW ERROR at line 1: ORA-01017: invalid username/password; …
36 Forum: SQL & PL/SQL «» Posted on: Thu, 06 June 2013 07:47 «» By: Littlefoot
Re: Running queries of 2 different SID on 1 Pane
…invalid username/password; logon denied ORA-02063: preceding line from DB_STUPID_2 SQL> create database link db_stupid_3 2 connect to mike 3 identified by lion 4 using 'ora10'; Database link created. SQL> select * from dual@…
37 Forum: SQL & PL/SQL «» Posted on: Thu, 06 June 2013 07:27 «» By: gatetec
Re: Running queries of 2 different SID on 1 Pane
…invalid username/password; logon denied ORA-02063: preceding line from ENIP182 It looks like the account is locked, so I tried to unlock it. SQL> alter user ADMINDBG_RO account unlock; alter user ADMINDBG_RO account unlock * ERROR …
38 Forum: Networking and Gateways «» Posted on: Wed, 27 March 2013 06:01 «» By: Littlefoot
Re: EXCEPTION HANDLING for DBLINK In TRIGGERS
…invalid username/password; logon denied ORA-02063: preceding line from DBL_MIKE SQL> connect mike/cat@ora10 Connected. SQL> select * from abc; COL ---------- 1 SQL> SCOTT.ABC contains 2 records (as you wanted), …
39 Forum: Replication «» Posted on: Fri, 20 July 2012 02:21 «» By: zeeshan007
Materialized view creation Error
…SQL level 2 ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [55916] ORA-02063: preceding 2 lines from MAHLNK.REGRESS.RDBMS.DEV.US.ORACLE.COM regards, Zeeshan Mehboob DBA…
40 Forum: Networking and Gateways «» Posted on: Mon, 09 July 2012 02:31 «» By: moulshree
Materialized view data replication
…error occurred at recursive SQL level 2 ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [55916] ORA-02063: preceding 2 lines from ORCL10R2 Please help…
Pages (2): [1  2    »]

Current Time: Sat Jan 25 04:43:26 CST 2020