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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Permissions error

RE: Permissions error

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 03 Sep 2003 04:24:59 -0800
Message-ID: <F001.005CEA20.20030903042459@fatcity.com>


John,
 If the OS is Dec Alpha OpenVMS.
 In the user environment execute the $ORACLE_HOME[.util]orauser.com to properly set the Oracle logicals for the user. A SHOW LOGICAL will display what you have set now.
Ron
>>> John.Hallas_at_gb.vodafone.co.uk 09/03/03 04:34AM >>>
The different account wil lnot have it's Oracle environment set up properly.
Check out the .profile on the account that works and the one that does not.
One will set up an Oracle_home and Oracle_sid variable, the other will not.
If it is not in the .profile then look at any other script that is called before you run sqlplus  

John

-----Original Message-----
Sent: 03 September 2003 01:19
To: Multiple recipients of list ORACLE-L

Hi All

I get this error when I try to log into sqlplus from my DEC ALPHA machine through a telnet session.

Enter user-name: testid
Enter password:
ERROR: ORA-01034: ORACLE not available
ORA-07320: smsget: shmat error when trying to attach sga. DEC OSF/1 (AXP) Error: 13: Permission denied

Did some permissions get corrupted. I am able to connect using sqlplus from my oracle account.
This happens when I try to connect from a different account.

Thanks
David

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Hallas, John, Tech Dev
  INET: John.Hallas_at_gb.vodafone.co.uk 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Sep 03 2003 - 07:24:59 CDT

Original text of this message

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