Home » RDBMS Server » Networking and Gateways » ORA-28500 (Oracle,11.1.0.7.0,Unix)
ORA-28500 [message #512430] Mon, 20 June 2011 05:41 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

There are 2 synonyms 'S1','S2'owned by Public user in DB1 database with db link name 'MADDY.COM@B20011'

The other database name is DB2 .

When i query the synonym 'S1' like 'select * from S1' from DB2 database i get error.

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 B20011@PF002.COM is not known on the
database server.
ORA-02063: preceding 2 lines from MADDY.COM@B20011

One info

DB1 -- Informix (I do not have enough of info about this db)
DB2 -- Oracle database with 11g version which we are using

Need your advice on how to fix this error?

Thanks
Re: ORA-28500 [message #512432 is a reply to message #512430] Mon, 20 June 2011 05:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
DB1 -- Informix (I do not have enough of info about this db)

Quote:
There are 2 synonyms 'S1','S2'owned by Public user in DB1 database with db link name 'MADDY.COM@B20011'

Are you sure the synonyms and db link are in the Informix database?

Quote:
When i query the synonym 'S1' like 'select * from S1' from DB2 database i get error.

How could you execute this on DB2 when the synonym is on DB1?

Your post is completly inconsistent.

Quote:
Incorrect password or user B20011@PF002.COM is not known on the database server.

Actually the info is returned by the database.

Once again DO NOT TRY TO EXPLAIN WHAT YOU DON'T UNDERSTAND, SHOW US.

Regards
Michel
Re: ORA-28500 [message #512447 is a reply to message #512432] Mon, 20 June 2011 06:26 Go to previous messageGo to next message
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 #512465 is a reply to message #512447] Mon, 20 June 2011 08:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Michel,I cannot show you what i tried in command prompt as it contains client info.

As we can't trust what you say as you don't understand what you have then we are in the following situation:
- you have the information but do not want to give us
- we have no information

So what do you expect from us?

Regards
Michel
Re: ORA-28500 [message #512471 is a reply to message #512465] Mon, 20 June 2011 10:01 Go to previous messageGo to next message
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 #512472 is a reply to message #512471] Mon, 20 June 2011 10:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>SQL> select * from CEEOT_WORK_TYPE@OSPCMITA.SBC.COM@M70071;
two at signs might confuse the parser.
in any case data dependent error which must be solved locally.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: ORA-28500 [message #512475 is a reply to message #512471] Mon, 20 June 2011 10:11 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

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
Re: ORA-28500 [message #512478 is a reply to message #512475] Mon, 20 June 2011 10:29 Go to previous messageGo to next message
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 #512608 is a reply to message #512478] Tue, 21 June 2011 03:01 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



I didnt get your point Swan.Can you be more clear ?

Thanks
Re: ORA-28500 [message #512613 is a reply to message #512608] Tue, 21 June 2011 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 #512620 is a reply to message #512613] Tue, 21 June 2011 04:03 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

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@M70071                       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                  m70071          OSPCMITF.SBC.COM
PUBLIC          TG4SQLP5.SBC.COM@BALATEO                  BALATEO          TG4SQLP5.SBC.COM
PUBLIC          OSTL680.SBC.COM                          IMG_BALA         OSTL680.SBC.COM

28 rows selected.



dblink name --DB1.SBC.COM@M70071
username -B2001


i gave query like this

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
select * from CEEOT_WORK_TYPE@ DB1.SBC.COM@B20011
*
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




Re: ORA-28500 [message #512626 is a reply to message #512620] Tue, 21 June 2011 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no database link named "DB1.SBC.COM@B20011" in what you posted.

Regards
Michel
Re: ORA-28500 [message #512636 is a reply to message #512626] Tue, 21 June 2011 04:47 Go to previous messageGo to next message
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

Re: ORA-28500 [message #512637 is a reply to message #512636] Tue, 21 June 2011 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OK and then what happens now?

Regards
Michel
Re: ORA-28500 [message #512644 is a reply to message #512637] Tue, 21 June 2011 05:38 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


I am still facing this below error.

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
select * from CEEOT_WORK_TYPE@ DB1.SBC.COM@B20011
*
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


Thanks
Re: ORA-28500 [message #512651 is a reply to message #512644] Tue, 21 June 2011 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So the error is still the same one and it is clear.
What don't you understand in it?

Regards
Michel
Re: ORA-28500 [message #512654 is a reply to message #512644] Tue, 21 June 2011 06:11 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
-951: Incorrect password or user 'MADDY.COM@B20011 is not known on
the database server.


Have you goggled for this error ?


I don`t know much about it But this Just try to help you

http://www.iiug.org/forums/ids/index.cgi/noframes/read/5631

sriram

[Updated on: Tue, 21 June 2011 06:12]

Report message to a moderator

Re: ORA-28500 [message #513081 is a reply to message #512654] Thu, 23 June 2011 08:37 Go to previous message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thanks Ram.

Can there be a dblink like this...DB1.SBC.COM@B20011?

Why i am asking is, this time i get different error. when i query a remote table
without @dblink from local db, i get error like 'table or view does not exist'.When i
query a table with @dblink i get error like..

ORA-00942: table or view does not exist
[Transparent gateway for INFORMIX]DRV_DescribeTable: DB_INF_RECORD (812): ;
Error -206: The specified table (CEEOT_WORK_TYPE) is not in the database.
ORA-02063: preceding 2 lines from DB1.SBC.COM@B20011

I checked the users privs on tables , everything is fine.I think the problem could be with dblink DB1.SBC.COM@B20011.

Am i correct? can somebody suggest me ?

Thanks




Previous Topic: Need help to connect Oracle Report and Forms 6i to sysbase
Next Topic: Sun OS
Goto Forum:
  


Current Time: Fri Mar 29 08:21:10 CDT 2024