Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> error connecting from sqlplus

error connecting from sqlplus

From: Indra Harimurti <indra_at_sofrecom.co.id>
Date: Mon, 18 Dec 2000 17:42:20 +0700
Message-Id: <10714.124822@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0004_01C06919.DEE4A840 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear List,

try to connect using sqlplus, returned error

Enter user-name: system                                      =20
Enter password:                                             =20
ERROR: ORA-01034: ORACLE not available                      =20
ORA-07320: smsget: shmat error when trying to attach sga.   =20
Digital Unix Error: 13: Permission denied                   =20
                                    =20
database already running
-rwxrwxrwx   1 ora73    dba          784 Dec 18 17:17 sgadefdb733.dbf =20
user group the same as oracle, oracle binaries already set correctly, anything else to check ?? please inform Thanks

Romi

------=_NextPart_000_0004_01C06919.DEE4A840 Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Dear List,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>try to connect using sqlplus, =
returned=20
error</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Enter user-name:=20

system&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;=20
<BR>Enter=20
password:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>ERROR: ORA-01034: ORACLE not=20

available&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>ORA-07320: smsget: shmat error when trying to attach =
sga.&nbsp;&nbsp;&nbsp;=20
<BR>Digital Unix Error: 13: Permission=20
denied&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>database already =
running</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>-rwxrwxrwx&nbsp;&nbsp; 1 =
ora73&nbsp;&nbsp;&nbsp;=20
dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 784 Dec 18 = 17:17=20
sgadefdb733.dbf&nbsp;&nbsp;</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>user group the same as oracle, =
oracle binaries=20
already set</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>correctly, anything else to check ?? =
please=20
inform Thanks</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000000 size=3D2>Romi<BR></FONT></DIV></BODY></HTML>
Received on Mon Dec 18 2000 - 04:42:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US