Re: Shared Memory Problem - Solaris 2.4 Oracle7.1.6

>In article <culbertsDDFDAp.9vx_at_netcom.com> Lon Culbertson writes:
>Gerald Skerbitz (gsker) wrote:
>: I've just installed Oracle on Solaris2.4 but I can only connect as oracle.
>: I can't connect as any other user.
>: The database is installed on thor.
 

>: (thor)/var/opt/oracle>sqlplus
>:
>: SQL*Plus: Release 3.1.3.7.1 - Production on Wed Aug 16 10:30:22 1995
>:
>: Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>:
>: Enter user-name: scott/tiger
>: ERROR: ORA-01034: ORACLE not available
>: ORA-07429: smsgsg: shmget() failed to get segment.
>: SVR4 Error: 2: No such file or directory
 

>: Is this a permissions problem?
>
> Probably.
>
>: What file or directory is it trying to get?
>
> $ORACLE_HOME/bin/oracle
>
> Permissions: 6751

Nope, this does not look like a permissions problem. I think the instance has to be running first before you can log into sqlplus as any user.

Try this :

Enter user-name: $
$ sqlplus scott/tiger

SQL*Plus: Release 3.1.3.5.1 - Production on Thu Aug 17 09:29:16 1995

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

ERROR: ORA-01034: ORACLE not available
ORA-07429: smsgsg: shmget() failed to get segment. NCR System 3000 Error: 2: No such file or directory

SQLDBA> connect internal
Connected.
SQLDBA> startup mount
ORACLE instance started.
Database mounted.
SQLDBA> alter database open;
Statement processed.
SQLDBA> exit
SQL*DBA complete.
$ sqlplus scott/tiger

SQL*Plus: Release 3.1.3.5.1 - Production on Thu Aug 17 09:31:19 1995

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

bla bla bla

SQL> The key words in the error messages that you are getting are : ORACLE not available

Hope this helps.

Nalini Vallampati
UNIX Admin/Oracle DBA
AT&T Credit GIS
Miamisburg, Ohio 45342

Nalini Vallampati
AT&T Capital - Global Information Solutions Miamisburg, Ohio Received on Thu Aug 17 1995 - 00:00:00 CEST