RE: sp2-0110 Cannot create save file "afiedt.buf"

From: <maheswara.rao_at_brass.com>
Date: Wed, 25 Feb 2004 11:50:52 -0500
Message-ID: <B60C45996A628B4ABF1F9149DF5FD43B0113874F@HUB-EXCHANGE.internal.sungard.corp>

Thank you very much for your help, Ron, David, Thomas, Mladen.

When I typed !host, then, my current directory is pointing to another directory.

Talked with our sysadmin and he changed my group perms.

Now, the problem resolved.

Thanks to you all for the help.

Rao

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Wednesday, February 25, 2004 11:35 AM To: oracle-l_at_freelists.org
Subject: Re: sp2-0110 Cannot create save file "afiedt.buf" - help please

Or try to truss sqlplus and see where it is attempting to open the afiedt.buf file. Alternatively, convince your SA to assign you uid=0. That way, you'll have no problems with file protection. This is what I have in mind:

A typical /etc/passwd file entry looks something like this:

       
        rpc:x:32:32:Portmapper RPC user:/:/sbin/nologin

User rpc has uid=32 and group=32. If your SA makes the entry look like this:

rpc:x:0:32:Portmapper RPC user:/:/sbin/nologin

you will no longer have any problems with file protection. It is customary to duck and take cover when you suggest something like this to a system administrator.

On 02/25/2004 11:18:14 AM, Ron Rogers wrote:
> From the SQL> type !host to get out of sqlplus and into the OS. Then
> type pwd to see where you are. It may be that you are not in your home
> directory and do not have permissions to write to the directory you are
> in.
> Ron
>
> >>> maheswara.rao_at_brass.com 02/25/2004 10:42:18 AM >>>
> OS : Solaris 8
> Database : 817
>
> Recently our root disk crashed and the sysadmin changed my home
> directory.
>
> Now, in SQLPLUS when I try to edit I get this error.
>
> sp2-0110 Cannot create save file "afiedt.buf"
>
> I checked the permissions. At unix level, I could create a file
> through vi in my home directory.
>
> In my .profile, I have EDITOR=vi.
>
> Please help in resolving this.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Feb 25 2004 - 10:48:08 CST

RE: sp2-0110 Cannot create save file "afiedt.buf" - help please