Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem about IPC and sqlnet in database link

Problem about IPC and sqlnet in database link

From: <sj_at_china.pages.com.cn>
Date: Fri, 29 May 1998 05:26:19 GMT
Message-ID: <6klgtq$pca$1@nnrp1.dejanews.com>


hello:

  I am facing such a problem:

  We have two database server installed seperately ( one on solaris and on on HP UX ).
  We want to exchange data between them automatically , so I create a database link on the server installed on solaris 2.5.1 . But we found if I login the server by using sqlplus it always show ora-12666 error .


$ sqlplus

SQL*Plus: Release 3.3.3.0.0 - Production on Fri May 29 13:17:37 1998

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Enter user-name: sj
Enter password:

Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release With the distributed and Spatial Data options PL/SQL Release 2.3.3.0.0 - Production

SQL> select * from test_at_db_link; <-- db_link is the database link I create select * from test_at_db_link

                   *

ERROR at line 1:
ORA-12666: Message 12666 not found; product=RDBMS; facility=ORA

SQL>


  This morning , I happened to login by using sqlnet connect string . I FOUND that all works FINE.

  I just do like this :



$ sqlplus sj/xlyytfy_at_oracle

SQL*Plus: Release 3.3.3.0.0 - Production on Fri May 29 13:20:43 1998

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Connected to:
Oracle7 Server Release 7.3.3.0.0 - Production Release With the distributed and Spatial Data options PL/SQL Release 2.3.3.0.0 - Production

SQL> select * from test_at_db_link;

DATA1 NO DATA2

---------------- ---------- ----------------
test			166 1666
data1			 10 data2
data1			  2 data2
data1			 10 data2
data1			 10 data2

SQL>


  I can also insert and update table by using the database link.

  But if I login by using ,

  %sqlplus

  all goes back to the previous problem .

  I think perhaps there are something wrong with my listener or sqlnet configuration . Because I think the phenomenon I met indicate local IPC has some thing abnormal to interact with sqlnet (which is used to connect to the other server on HP UX).

  Well, I'd like to speek more about the config of my solaris server.

  The server has one ethernet card connect to the LAN , but the ethernet card was configed 3 IP address , 202.96.98.24 , 202.96.98.34 and 134.98.69.35 . the Oracle listener is configed to listen to two of them : 202.96.98.24 and 134.98.69.35 .

   I config the listener.ora to have two listener , but I found that I just can set up one listener to have IPC address . or , the listener will not start up normally . (?)

  I do not know how the sqlplus interact with sqlnet and IPC . But I think there must be some translation between them , which is not performed exactly on the solaris server.

  /* HP UX just has one IP and One server installed */

  Thank you very much !

Jing Shen

Mail to: sj_at_china.pages.com.cn

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 00:26:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US