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

  • From: <maheswara.rao@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Feb 2004 11:50:52 -0500

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On 
Behalf Of Mladen Gogala
Sent: Wednesday, February 25, 2004 11:35 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: