|
|
|
|
| Re: ORA-28500 [message #512447 is a reply to message #512432] |
Mon, 20 June 2011 06:26   |
Database admin
Messages: 365
Registered: September 2006
Location: india
|
Senior Member |
 
|
|
"Are you sure the synonyms and db link are in the Informix database? "
No
How could you execute this on DB2 when the synonym is on DB1?
I found db link with name 'MADDY.COM@B20011 using dba_db_link view is created
between DB1 and DB2 databases from DB1 database.
So what executed that statement.
Michel,I cannot show you what i tried in command prompt as it contains client info.
Pls provide me the solution if you really want to fix this error.
Thanks
[Updated on: Mon, 20 June 2011 07:32] Report message to a moderator |
|
|
|
|
|
| Re: ORA-28500 [message #512471 is a reply to message #512465] |
Mon, 20 June 2011 10:01 |
Database admin
Messages: 365
Registered: September 2006
Location: india
|
Senior Member |
|
|
OK.
While trying to access a table CEEOT_WORK_TYPE from DB2 database which actually belongs
to DB1 database i get errors.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> select * from CEEOT_WORK_TYPE@ DB1.SBC.COM@B20011@M70071;
select * from CEEOT_WORK_TYPE@ DB1.SBC.COM@B20011@M70071
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Transparent gateway for INFORMIX]DRV_InitTdp: DB_INF_INTERFACE (360): ; Error
-951: Incorrect password or user 'MADDY.COM@B20011 is not known on
the database server.
ORA-02063: preceding 2 lines from DB1.SBC.COM@B20011
SQL>
FYI
There is a dblink connects from DB2 to DB1
Thanks
[Updated on: Mon, 20 June 2011 10:05] Report message to a moderator |
|
|
|
|
|
|
|
| Re: ORA-28500 [message #512478 is a reply to message #512475] |
Mon, 20 June 2011 10:29 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
I stand corrected
SQL> select * from CEEOT_WORK_TYPE@ DB1.SBC.COM@B20011@M70071;
not two at signs, but THREE at signs on single SELECT along with a seemingly errant space character to the right of leftmost at sign.
Valid SQL should be used at all times.
[Updated on: Mon, 20 June 2011 10:30] Report message to a moderator |
|
|
|
|
|
| Re: ORA-28500 [message #512613 is a reply to message #512608] |
Tue, 21 June 2011 03:12 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
There can't be a database link named "DB1.SBC.COM@B20011@M70071" because a database link cannot contain 2 "@".
Post the result of:
set lines 120 pages 100
col owner format a15
col db_link format a40
col host format a40
col username format a15
select owner, db_link, username, host from dba_db_links;
Regards
Michel
[Updated on: Tue, 21 June 2011 03:13] Report message to a moderator |
|
|
|
|
|
|
|
| Re: ORA-28500 [message #512636 is a reply to message #512626] |
Tue, 21 June 2011 04:47 |
Database admin
Messages: 365
Registered: September 2006
Location: india
|
Senior Member |
|
|
Pls check now
SQL> set lines 120 pages 100
SQL> col owner format a15
SQL> col db_link format a40
SQL> col host format a40
SQL> col username format a15
SQL> select owner, db_link, username, host from dba_db_links;
OWNER DB_LINK USERNAME HOST
--------------- ---------------------------------------- --------------- ----------------------------------------
PUBLIC TCONTSTC.SBC.COM@SWPA_NR_BALA SWPA_NR_BALA TCONTSTC.SBC.COM
PUBLIC BALAD4.SLDC.SBC.COM@BALA BALA BALAD4.SLDC.SBC.COM
PUBLIC BALAP1.SLDC.SBC.COM@M15092 M15092 BALAP1.SLDC.SBC.COM
PUBLIC BALAD5.SLDC.SBC.COM@BALAARCHIVE BALAARCHIVE BALAD5.SLDC.SBC.COM
PUBLIC IMGA001T.SBC.COM@IMG_BALA IMG_BALA IMGA001T.SBC.COM
PUBLIC TG4SQLP2.SLDC.SBC.COM BALATEO TG4SQLP2
PUBLIC TG4SQLP1.SLDC.SBC.COM VRF_CF TG4SQLP1
PUBLIC Q1YODA.WORLD M68781 Q1YODA.WORLD
PUBLIC OSTL681.SBC.COM@TEO_MIC TEO_MIC OSTL681.SBC.COM
PUBLIC BALAD3.SLDC.SBC.COM@BALA BALA BALAD3.SLDC.SBC.COM
PUBLIC OSTL155.SBC.COM@M34648 M34648 OSTL155.SBC.COM
PUBLIC HELDORDT.SBC.COM@M31500 m31500 HELDORDT.SBC.COM
PUBLIC BALAP2.SLDC.SBC.COM@BALA BALA BALAp2.sldc.sbc.com
PUBLIC CFASDEVA.SBC.COM SWPA_BALA CFASDEVA.SBC.COM
PUBLIC BALAD5.SLDC.SBC.COM@BALA BALA BALAD5.SLDC.SBC.COM
PUBLIC GG26.SBC.COM@M46298 M46298 GG26.SBC.COM
PUBLIC TCONTSTC.SBC.COM@SWPA_BALA SWPA_BALA TCONTSTC.SBC.COM
PUBLIC OPTI01D.SBC.COM@BALA BALA OPTI01D.SBC.COM
BALA ACAS BALA ACAS
PUBLIC AOTX01T.SBC.COM@M29978 M29978 AOTX01T.SBC.COM
PUBLIC BALAD1.SLDC.SBC.COM@M61794 M61794 BALAD1.SLDC.SBC.COM
PUBLIC BALAD1.SLDC.SBC.COM@BALA BALA BALAD1.SLDC.SBC.COM
PUBLIC DB1.SBC.COM@B20011 B2001 OSPCMITA.SBC.COM
PUBLIC LV1_HHT009AC.SLDC.SBC.COM@M60915 M60915 lv1_hht009ac.db.att.com
PUBLIC T1ACA1D1.DB.ATT.COM@UNIFACE UNIFACE T1ACA1D1.DB.ATT.COM
PUBLIC OSPCMITF.SBC.COM@M70071 B2001 OSPCMITF.SBC.COM
PUBLIC TG4SQLP5.SBC.COM@BALATEO BALATEO TG4SQLP5.SBC.COM
PUBLIC OSTL680.SBC.COM IMG_BALA OSTL680.SBC.COM
28 rows selected.
[Updated on: Tue, 21 June 2011 04:48] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
