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

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Wed, 25 Feb 2004 11:35:18 -0500
Message-ID: <20040225163518.GA2316@mladen.wangtrading.com>

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

Received on Wed Feb 25 2004 - 10:32:43 CST

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