Re: ORA-07429 ..Any idea what my problem is?

Bill Tierney wrote:
>
> I've installed Oracle 7.2.2.3 on AIX 4.1.
> When I'm on the system I can connect to
> the instance just fine. However,
> if I'm on another machine and try
> to connect I get:
>
> SQL*Plus: Release 3.2.2.0.0 - Production on Sun Jul 7 13:58:59 1996
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07429: smsgsg: shmget() failed to get segment.
> IBM AIX RISC System/6000 Error: 2: No such file or directory
>
>
> Does anyone have any ideas? My listener
> is running. My database is up..
>
> Thanks..
>
> wtierney_at_stanford.eduBill,

SQL*Plus thinks you're trying to connect to a local, and not a remote, database. You need to have a tnsnames.ora (SQL*Net V2) configuration file on the host you're trying to connect from and your SQL*Plus connect string must include the remote 'service name, as specified in tnsmames.ora. For example, sqlplus login/password_at_service, where service is a tnsnames.ora address.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.