Re: SQL*Net -error ORA-07320

: I have installed SQL*Net version 1 TCP/IP on both a client ( with
: local database ) and a server ( with a local database). System is
: Silicon Graphics IRIX 5.2 with ORACLE version 7.0.15.4.
: The problem is : When I try to connect to the server database I
: get the error :
: ERROR: ORA-01034: ORACLE not available
: ORA-07320: smsget: shmat error when trying to attach sga.
: SVR4 Error: 13: Permission denied
: The string I used to connect was:
: sqlplus username/password_at_T:server_name:database_name

The most likely cause is that your database is not up as the error suggests. Also you will most likely get the same error whether you use TCP/IP, pipes, spx etc.

--
=========================================================================
Sudhir Giroti                           | Phone:  617-895-3859
                                        | Email:  giroti_at_ksr.com
Member of Technical Staff               | USMail: Kendall Square Research
Commercial Software Development Group   |         170 Tracer Lane, 
                                        |         Waltham, Ma 02154
=========================================================================