Home » SQL & PL/SQL » Client Tools » SP2-0111: Cannot close save file "afiedt.buf" (12.1.0.2 Oracle Linux 6.5)
SP2-0111: Cannot close save file "afiedt.buf" [message #649577] Thu, 31 March 2016 05:03 Go to next message
juniordbanewbie
Messages: 176
Registered: April 2014
Senior Member
Dear all,


SYS@cdb1>select * from v$version;

BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
         0

PL/SQL Release 12.1.0.2.0 - Production
         0

CORE    12.1.0.2.0      Production
         0


BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
TNS for Linux: Version 12.1.0.2.0 - Production
         0

NLSRTL Version 12.1.0.2.0 - Production
         0


SYS@cdb1>ed
SP2-0111: Cannot close save file "afiedt.buf"



partial opatch lsinventory -detail output


Interim patches (2) :

Patch  20243268     : applied on Mon Mar 21 21:06:20 SGT 2016
Unique Patch ID:  19729177
   Created on 11 Jan 2016, 11:28:47 hrs PST8PDT
   Bugs fixed:
     20243268
   This patch overlays patches:
     21949015
   This patch needs patches:
     21949015
   as prerequisites




my patch set release PSR is p21419221_121020

next I update the OPatch directory to 12.1.0.1.10

opatch version
OPatch Version: 12.1.0.1.10

OPatch succeeded.


next I apply patch the following patches in the following order
p22243551_121020_Linux-x86-64.zip
p20243268_12102160119DBEngSysandDBIM_Linux-x86-64.zip

I found the following in $ORACLE_BASE/diag/rdbms/cdb1/cdb1/trace/alert_cdb1.log

Patch Id: 21694919
Patch Description: DATABASE BUNDLE PATCH: 12.1.0.2.13 (21694919)
Patch Apply Time: 2016-03-20 17:29:10 GMT+08:00
Bugs Fixed: 13683743,16087033,16777441,18727933,18758877,18778801,18803726,
18810904,18895170,18952766,18999568,19130152,19131386,19131607,19146474,
19168167,19243521,19248279,19313563,19317646,19327391,19364502,19440520,
19441649,19448499,19461428,19468612,19523462,19547774,19566592,19571055,
19571082,19583624,19590877,19632912,19647503,19680796,19701015,19705781,
19769625,19784751,19799847,19811709,19817386,19824871,19859472,19869255,
19880190,19883092,19886165,19889230,19914604,19933147,19952975,19982584,
19988852,19990037,20009569,20011646,20011897,20017509,20052269,20061399,
20124446,20130196,20227126,20233181,20261923,20340510,20441797,20471920,
20494044,20565112,20565133,20577490,20668053,20703629,20707932,20717091,
20724902,20732272,20739811,20800890,20801783,20815650,20825533,20828104,
20831538,20832474,20847534,20857041,20868862,20890311,20893843,20925795,
20936905,20988771,21032832,21087813,21091431,21136799,21151241,21153266,
21187090,21188584,21218121,21241052,21273804,21283023,21285458,21293453,
21300341,21306811,21345404,21372880,21372897,21387128,21427131,21442094,
21459225,21517261,21554789,21568648,21620471,21813529,21903230,22062026

Patch Id: 21949015
Patch Description: DATABASE BUNDLE PATCH: 12.1.0.2.160119 (21949015)
Patch Apply Time: 2016-03-20 17:30:50 GMT+08:00
Bugs Fixed: 14283239,16817656,17249267,17532734,17551063,17655240,17734040,
17994602,18603592,18705806,18749211,18797519,18893947,19141838,19151370,
19163723,19215966,19359219,19450314,19490948,19544707,19576559,19578230,
19676012,19680898,19931709,20001466,20024405,20195148,20228093,20233159,
20250147,20322560,20368850,20401975,20466322,20618595,20624914,20653340,
20672955,20673810,20708701,20723042,20777159,20794951,20801390,20842388,
                                                                        



Most of the solutions to my problem does not applies at all since they are talking about windows platform, would appreciate if someone could guide me how to resolve this.

many thanks in advance!
Re: SP2-0111: Cannot close save file "afiedt.buf" [message #649579 is a reply to message #649577] Thu, 31 March 2016 05:19 Go to previous messageGo to next message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
What do the following commands return?
SQL> HOST pwd
SQL> HOST ls -l ..
Re: SP2-0111: Cannot close save file "afiedt.buf" [message #649581 is a reply to message #649577] Thu, 31 March 2016 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SP2-00111: Cannot close save file \"%s\"\n
 *Cause:  The file was in use.
 *Action: Release the file from the other process.
Re: SP2-0111: Cannot close save file "afiedt.buf" [message #649587 is a reply to message #649581] Thu, 31 March 2016 08:09 Go to previous messageGo to next message
juniordbanewbie
Messages: 176
Registered: April 2014
Senior Member
Dear gazzag


SYS@cdb1>host pwd
/home/oracle

SYS@cdb1>host ls -l ..
total 8
drwx------. 25 olaf   olaf     4096 Mar 30 19:10 olaf
drwx------. 30 oracle oinstall 4096 Mar 31 18:40 oracle



Dear Michel

ps -ef | grep afiedt.buf
oracle     6977   6936  0 18:40 pts/4    00:00:00 grep afiedt.buf
[oracle@ol65-em12cr4 ~]$ ps -ef | grep sqlplus
oracle     6919   6868  0 18:39 pts/1    00:00:00 sqlplus   as sysdba
oracle     6979   6936  0 18:40 pts/4    00:00:00 grep sqlplus
[oracle@ol65-em12cr4 ~]$ ps -ef | grep pmon
oracle     5428      1  0 17:25 ?        00:00:00 ora_pmon_cdb1
oracle     6981   6936  0 18:40 pts/4    00:00:00 grep pmon



Maybe you are right, but I do not know which process is holding afiedt.buf. Could u tell me how to find the process that is holding afiedt.buf? thanks

many thanks
Re: SP2-0111: Cannot close save file "afiedt.buf" [message #649588 is a reply to message #649587] Thu, 31 March 2016 08:15 Go to previous messageGo to next message
BlackSwan
Messages: 25794
Registered: January 2009
Location: SoCal
Senior Member
lsof can show which process holds the file open
Re: SP2-0111: Cannot close save file "afiedt.buf" [message #649592 is a reply to message #649588] Thu, 31 March 2016 09:05 Go to previous message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

or fuser.

Previous Topic: TOAD comma question
Next Topic: Column order not as expected
Goto Forum:
  


Current Time: Thu Jan 18 07:09:57 CST 2018

Total time taken to generate the page: 0.01755 seconds