Hmm, this sounds suspiciously like a known issue for
Oracle 8.0 on Unixware 7.0. It's not supposed to
happen on 7.1 because the sockets implementation was
changed on that release. The solution was to increase
the number of semaphores.
The other culprit, if you have a large number of
connections is that you may need to increase the
number of TCP/IP sockets.
Check out the following docs on MetaLink for more
details:
Note 1017932.102 - "ORA-27500 ORA-27300 ATTEMPTING
DATABASE CONNECTION ON UNIXWARE 7.0.X"
Note 68694.1 - "Increasing Number of Concurrent
Connections to RDBMS"
HTH,
- Anita
- cyhu_at_eachnet.com wrote:
>
> hi,everyone.
> I created a db link and ran sql statements well .
> But now the problem
> arose as follows:
>
> SQL> select count(*) from mytable_at_mydb;
> select count(*) from mytable_at_mydb
> *
> ERROR at line 1:
> ORA-27500: inter-instance IPC error
> ORA-27300: OS system dependent operation:port_create
> failed with status:
> 134
> ORA-27301: OS failure message: Transport endpoint is
> not connected
> ORA-27302: failure occurred at: skgxpcini1
> ORA-02063: preceding 4 lines from mydb
>
> My databases are all based on UNIXWARE7.1 and ORACLE
> 8.0.5.
>
> Can anyone give me the reasons and how to correct
> it?
> Thanks in advance.
>
> cyhu_at_eachnet.com
>
>
> --
> Author:
> INET: cyhu_at_eachnet.com
>
> 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: ListGuru_at_fatcity.com (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).
Do You Yahoo!?
Received on Mon Jul 03 2000 - 00:10:29 CDT
