RE: Connecting INGRES using database link
Thanks Mike, I'll subscribe to that list.. -Original Message- Sent: Thursday, January 24, 2002 9:25 PM To: Multiple recipients of list ORACLE-L Holly, I subscribe to the [EMAIL PROTECTED] ingres dba list. I can't find out how you can subscribe though, sorry! (no, It's not in any trailer or signature) Maybe a search engine will find something. It's fairly low traffic compared to this list but there are some peeps who know their ingres stuff (unlike me). - Mike. -Original Message- Sent: 24 January 2002 03:55 To: Multiple recipients of list ORACLE-L Dear Bambi, Unfortunatly, 10 years ago I still a kid.. ^_^ Did you know any web site/mailing list/or other resources relate with this problem (INGRES), so I can solve this problem? Thanks in advance Holly -Original Message- Sent: Thursday, January 24, 2002 1:02 AM To: Multiple recipients of list ORACLE-L Golly, that looks an awful lot like VMS. I think what it's trying to tell you is that the node you specified is not reachable, or that the SID you've specified is not on the node listed. There's some kind of connection problem there. Try doing a select from the Ingres side over the connection. If it works, I don't know what to tell you. If it fails, drop and recreate the connection string. The important thing is that this error is NOT an Oracle error... it is a wrapper around what it's getting from the Ingres side... and it looks for all the world like it's not purely an Ingres error either. That "E_" is a VMS level error (W would be "warning", F would be "fatal"). Unfortunately, I've been largely off of VMS since 93, so I'm not going to be able to help a lot there either. Wish you would have asked this question about 10 years ago... ;) Bambi. -Original Message- Sent: Tuesday, January 22, 2002 9:05 PM To: Multiple recipients of list ORACLE-L thank you Bambi. I already tried to create database link using HSODBC, but failed. It returned this messages : == SQL> select * from cond@hsodbc; select * from cond@hsodbc * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES driver][INGRES]E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_REQUEST) failure. Internal service status E_GC0132 -- User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode i (SQL State: S1000; SQL Code: -38100) ORA-02063: preceding 6 lines from HSODBC == Is someone familiar with this kind of error... TIA, Holly -Original Message- Sent: Wednesday, January 23, 2002 4:20 AM To: Multiple recipients of list ORACLE-L Holly -- It has been a long time since I have done Oracle and Ingres at the same time (about 12 years (Oracle v6/Ingres v5)). Back then, while there was "kinda-sorta" ODBC to and from both Oracle and Ingres, they weren't able to access each other directly. Generally, data transfers were to and from flat files, and queries between objects in the two databases utilized a third party tool (Passport). HTH, Bambi. -Original Message- Sent: Monday, January 21, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Dear all, Can I create database link using generic connectivity (ODBC)? Was there someony already try this? I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the offi
RE: Connecting INGRES using database link
Holly, I subscribe to the [EMAIL PROTECTED] ingres dba list. I can't find out how you can subscribe though, sorry! (no, It's not in any trailer or signature) Maybe a search engine will find something. It's fairly low traffic compared to this list but there are some peeps who know their ingres stuff (unlike me). - Mike. -Original Message- Sent: 24 January 2002 03:55 To: Multiple recipients of list ORACLE-L Dear Bambi, Unfortunatly, 10 years ago I still a kid.. ^_^ Did you know any web site/mailing list/or other resources relate with this problem (INGRES), so I can solve this problem? Thanks in advance Holly -Original Message- Sent: Thursday, January 24, 2002 1:02 AM To: Multiple recipients of list ORACLE-L Golly, that looks an awful lot like VMS. I think what it's trying to tell you is that the node you specified is not reachable, or that the SID you've specified is not on the node listed. There's some kind of connection problem there. Try doing a select from the Ingres side over the connection. If it works, I don't know what to tell you. If it fails, drop and recreate the connection string. The important thing is that this error is NOT an Oracle error... it is a wrapper around what it's getting from the Ingres side... and it looks for all the world like it's not purely an Ingres error either. That "E_" is a VMS level error (W would be "warning", F would be "fatal"). Unfortunately, I've been largely off of VMS since 93, so I'm not going to be able to help a lot there either. Wish you would have asked this question about 10 years ago... ;) Bambi. -Original Message- Sent: Tuesday, January 22, 2002 9:05 PM To: Multiple recipients of list ORACLE-L thank you Bambi. I already tried to create database link using HSODBC, but failed. It returned this messages : == SQL> select * from cond@hsodbc; select * from cond@hsodbc * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES driver][INGRES]E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_REQUEST) failure. Internal service status E_GC0132 -- User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode i (SQL State: S1000; SQL Code: -38100) ORA-02063: preceding 6 lines from HSODBC == Is someone familiar with this kind of error... TIA, Holly -Original Message- Sent: Wednesday, January 23, 2002 4:20 AM To: Multiple recipients of list ORACLE-L Holly -- It has been a long time since I have done Oracle and Ingres at the same time (about 12 years (Oracle v6/Ingres v5)). Back then, while there was "kinda-sorta" ODBC to and from both Oracle and Ingres, they weren't able to access each other directly. Generally, data transfers were to and from flat files, and queries between objects in the two databases utilized a third party tool (Passport). HTH, Bambi. -Original Message- Sent: Monday, January 21, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Dear all, Can I create database link using generic connectivity (ODBC)? Was there someony already try this? I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FA
RE: Connecting INGRES using database link
Dear Bambi, Unfortunatly, 10 years ago I still a kid.. ^_^ Did you know any web site/mailing list/or other resources relate with this problem (INGRES), so I can solve this problem? Thanks in advance Holly -Original Message- Sent: Thursday, January 24, 2002 1:02 AM To: Multiple recipients of list ORACLE-L Golly, that looks an awful lot like VMS. I think what it's trying to tell you is that the node you specified is not reachable, or that the SID you've specified is not on the node listed. There's some kind of connection problem there. Try doing a select from the Ingres side over the connection. If it works, I don't know what to tell you. If it fails, drop and recreate the connection string. The important thing is that this error is NOT an Oracle error... it is a wrapper around what it's getting from the Ingres side... and it looks for all the world like it's not purely an Ingres error either. That "E_" is a VMS level error (W would be "warning", F would be "fatal"). Unfortunately, I've been largely off of VMS since 93, so I'm not going to be able to help a lot there either. Wish you would have asked this question about 10 years ago... ;) Bambi. -Original Message- Sent: Tuesday, January 22, 2002 9:05 PM To: Multiple recipients of list ORACLE-L thank you Bambi. I already tried to create database link using HSODBC, but failed. It returned this messages : == SQL> select * from cond@hsodbc; select * from cond@hsodbc * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES driver][INGRES]E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_REQUEST) failure. Internal service status E_GC0132 -- User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode i (SQL State: S1000; SQL Code: -38100) ORA-02063: preceding 6 lines from HSODBC == Is someone familiar with this kind of error... TIA, Holly -Original Message- Sent: Wednesday, January 23, 2002 4:20 AM To: Multiple recipients of list ORACLE-L Holly -- It has been a long time since I have done Oracle and Ingres at the same time (about 12 years (Oracle v6/Ingres v5)). Back then, while there was "kinda-sorta" ODBC to and from both Oracle and Ingres, they weren't able to access each other directly. Generally, data transfers were to and from flat files, and queries between objects in the two databases utilized a third party tool (Passport). HTH, Bambi. -Original Message- Sent: Monday, January 21, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Dear all, Can I create database link using generic connectivity (ODBC)? Was there someony already try this? I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP c
RE: Connecting INGRES using database link
Golly, that looks an awful lot like VMS. I think what it's trying to tell you is that the node you specified is not reachable, or that the SID you've specified is not on the node listed. There's some kind of connection problem there. Try doing a select from the Ingres side over the connection. If it works, I don't know what to tell you. If it fails, drop and recreate the connection string. The important thing is that this error is NOT an Oracle error... it is a wrapper around what it's getting from the Ingres side... and it looks for all the world like it's not purely an Ingres error either. That "E_" is a VMS level error (W would be "warning", F would be "fatal"). Unfortunately, I've been largely off of VMS since 93, so I'm not going to be able to help a lot there either. Wish you would have asked this question about 10 years ago... ;) Bambi. -Original Message- Sent: Tuesday, January 22, 2002 9:05 PM To: Multiple recipients of list ORACLE-L thank you Bambi. I already tried to create database link using HSODBC, but failed. It returned this messages : == SQL> select * from cond@hsodbc; select * from cond@hsodbc * ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES driver][INGRES]E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_REQUEST) failure. Internal service status E_GC0132 -- User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode i (SQL State: S1000; SQL Code: -38100) ORA-02063: preceding 6 lines from HSODBC == Is someone familiar with this kind of error... TIA, Holly -Original Message- Sent: Wednesday, January 23, 2002 4:20 AM To: Multiple recipients of list ORACLE-L Holly -- It has been a long time since I have done Oracle and Ingres at the same time (about 12 years (Oracle v6/Ingres v5)). Back then, while there was "kinda-sorta" ODBC to and from both Oracle and Ingres, they weren't able to access each other directly. Generally, data transfers were to and from flat files, and queries between objects in the two databases utilized a third party tool (Passport). HTH, Bambi. -Original Message- Sent: Monday, January 21, 2002 9:40 PM To: Multiple recipients of list ORACLE-L Dear all, Can I create database link using generic connectivity (ODBC)? Was there someony already try this? I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ahmadsyah Alghozi Nugroho INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
