Re: Shared Memory Problem - Solaris 2.4 Oracle7.1.6

Nalini Vallampati <first.last_at_xxxxxxx.aaaaa.bbb> wrote:
>>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.

What did you do to get this error to appear on your system?

>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.

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

 []
>Nalini Vallampati
>AT&T Capital - Global Information Solutions
>Miamisburg, Ohio

I did an alter database open immediately after bringing the databases up. It didn't seem to have any effect at all. What did you think it would do?

Thanks a lot for your help. I'm really grasping at straws now.

--
Gerry
Gerald Skerbitz <gsker_at_med.umn.edu> U of MN Med School Admin 6-5379
Home St. Paul,Ramsey County,Minnesota, USA