Re: SCO Oracle - Linux - JDBC - shmget() error

Hi John!
John Meijer <meijer_at_pathcom.com> wrote:
> Hi:
 

> I'm running SCO Oracle 7.3 on Linux using iBCS. The database is up,
> and the listener for SQL*Net is monitoring Port 1521.
 

> With JDBC from Oracle, using the thin client, I am trying to connect
> to the database with the following error:
 

> Loading JDBC driver oracle.jdbc.driver.OracleDriver
> Connecting to jdbc:oracle:thin:userid/passwd_at_192.168.1.1:1521:orcl
> ORA-01034: ORACLE not available
> ORA-07429: smsgsg: shmget() failed to get segment.
> AT&T System V/386 Error: 2: No such file or directory
 

> I guess the last three lines of error messages occur from bottom
> to top (i.e. the "No such file.." error is the root cause), and
> suspect that since I am running a SCO version under Linux, some
> part of my directory structure is missing that is there under SCO.
You are not right. No such file or dir.. is a standard message for shmget to say that it cannot get shared memory segment because of wron identifier. Check if your db is accessible at all (use sqlplus). Check listener configuration - (use sqlplus). Make sure you have set ORACLE_SID.
> Anyway, it seems the shmget() fails causing JDBC to not have access
> to the database. Any ideas for a fix to this problem?
> --John.

I don't no much about jdbc, but I was able  to connect to my Linux-iBCS-Oracle-for-Sco  both directly and via sqlnet, even from another machine.  

 Sincerely yours, Konstantin Kivi.     Received on Sat Mar 14 1998 - 00:00:00 CST