Re: Server / Listener Problems

In article <4v16em$1pj_at_mtinsc01-mgt.ops.worldnet.att.net> William Luk <wsluk_at_postoffice.worldnet.att.net> writes:
>
>We are running Oracle 7 server on an X86 Solaris 2.5.
>I finished installing the Oracle 7 server (version 7.3.2.1)
>with SQL*Net version 2.3. When I tried to access the
>server from a sqlplus client, I got the following errors on
>the client:
>
> ERROR: ORA-01034: ORACLE not available
> ORA-07429: smsgsg: shmget() failed to get segment.
> NCR System 3000 Error: 2: No such file or directory
>
>Oracle support has been working on this for couple weeks, and
>is not sure where the error is coming from.
>

It seems apparent that the Solaris system is intended to be the server for clients on the MP-RAS (NCR) system. The message indicates that the client code expects Oracle to be up and running locally. Setting the environment variable "TWO_TASK" on the client to the appropriate instance name in the clients tnsnames.ora file causes the client to connect over the network.

At least that works for me.

-- 
--------------------------------------------------------------------------
Bill Hertzog, PSS                         Bill.Hertzog_at_ColumbiaSC.NCR.COM
NCR-       .*     -DataBaseEngineering    Voice: 803-939-6443 (VP 632-6443)
3325 Platt Springs Rd, W. Columbia, SC 29170              Fax: 803-939-7317