Opatch apply come across file in use

During Opatch apply come across below error message.

D:\>cd oracle\MIS\11204\Patches.11204\18069285\

D:\oracle\MIS\11204\Patches.11204\18069285>d:\oracle\MIS\11204\OPatch\opatch app
ly
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : D:\ORACLE\MIS\11204
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : D:\ORACLE\MIS\11204\cfgtoollogs\opatch\18069285_Apr_10_2014_
18_51_57\apply2014-04-10_18-51-57PM_1.log

Applying interim patch '18069285' to OH 'D:\ORACLE\MIS\11204'
Verifying environment and performing prerequisite checks...
Patch 18069285: Optional component(s) missing : [ oracle.sysman.agent, 10.2.0.4.
3, higher version 10.2.0.4.5 found. ] , [ oracle.has.cfs, 11.2.0.4.0 ] , [ oracl
e.has.crs, 11.2.0.4.0 ] , [ oracle.has.cvu, 11.2.0.4.0 ]
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following files are active :
D:\ORACLE\MIS\11204\bin\orapls11.dll
D:\ORACLE\MIS\11204\bin\orageneric11.dll
D:\ORACLE\MIS\11204\bin\oraclient11.dll
D:\ORACLE\MIS\11204\bin\oracommon11.dll
D:\ORACLE\MIS\11204\bin\oraxml11.dll
D:\ORACLE\MIS\11204\bin\orahasgen11.dll
D:\ORACLE\MIS\11204\bin\oraocr11.dll
D:\ORACLE\MIS\11204\bin\oraocrb11.dll
D:\ORACLE\MIS\11204\bin\oraocrutl11.dll
Log file location: D:\ORACLE\MIS\11204\cfgtoollogs\opatch\18069285_Apr_10_2014_1
8_51_57\apply2014-04-10_18-51-57PM_1.log

Recommended actions: OPatch needs to modify files which are being used by some p
rocesses.

OPatch failed with error code = 41

D:\oracle\MIS\11204\Patches.11204\18069285>

To resolve need to stop Windows Management Instrumentation service service.

Also during stopping  Windows Management Instrumentation service service also stopped below.
    IP Helper
    HP ProLiant Agentless Management Service

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []

Getting below error message post restarting server after abnormal power off.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1319546880 bytes
Fixed Size                  2254904 bytes
Variable Size             671090632 bytes
Database Buffers          637534208 bytes
Redo Buffers                8667136 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

To resolve followed below steps. post getting above error.

SQL> alter database recover database;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1319546880 bytes
Fixed Size                  2254904 bytes
Variable Size             671090632 bytes
Database Buffers          637534208 bytes
Redo Buffers                8667136 bytes
Database mounted.
Database opened.
SQL>

move tables to different tablespace using Brtools i.e. TTREE tables during EHP update

IPLQLS:oraqls 3> brtools

BR0651I BRTOOLS 7.20 (31)

BR0280I BRTOOLS time stamp: 2014-02-11 12.44.31
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

 1 = Instance management
 2 - Space management
 3 - Segment management
 4 - Backup and database copy
 5 - Restore and recovery
 6 - Check and verification
 7 - Database statistics
 8 - Additional functions
 9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2014-02-11 12.44.37
BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2014-02-11 12.44.37
BR0656I Choice menu 7 - please make a selection
-------------------------------------------------------------------------------
Database segment management

 1 = Reorganize tables
 2 - Rebuild indexes
 3 - Export tables
 4 - Import tables
 5 - Alter tables
 6 - Alter indexes
 7 - Additional segment functions
 8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2014-02-11 12.44.42
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2014-02-11 12.44.42
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables

 1 - BRSPACE profile (profile) ...... [initQLS.sap]
 2 - Database user/password (user) .. [/]
 3 ~ Reorganization action (action) . []
 4 ~ Tablespace names (tablespace) .. []
 5 ~ Table owner (owner) ............ []
 6 ~ Table names (table) ............ []
 7 ~ Table partitions (tabpart) ..... []
 8 - Confirmation mode (confirm) .... [yes]
 9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initQLS.sap -s 20 -l E -f tbreorg]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2014-02-11 12.44.48
BR0663I Your choice: '6'
BR0681I Enter string value for "table" []:
TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK
BR0280I BRTOOLS time stamp: 2014-02-11 12.46.08
BR0683I New value for "table": 'TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK'

BR0280I BRTOOLS time stamp: 2014-02-11 12.46.08
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables

 1 - BRSPACE profile (profile) ...... [initQLS.sap]
 2 - Database user/password (user) .. [/]
 3 ~ Reorganization action (action) . []
 4 ~ Tablespace names (tablespace) .. []
 5 ~ Table owner (owner) ............ []
 6 ~ Table names (table) ............ [TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK]
 7 ~ Table partitions (tabpart) ..... []
 8 - Confirmation mode (confirm) .... [yes]
 9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initQLS.sap -s 20 -l E -f tbreorg -t "TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK"]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2014-02-11 12.46.16
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initQLS.sap -s 20 -l E -f tbreorg -t "TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK"'

BR0280I BRTOOLS time stamp: 2014-02-11 12.46.16
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2014-02-11 12.46.18
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.20 (31)
BR1002I Start of BRSPACE processing: seneityh.tbr 2014-02-11 12.46.19
BR0484I BRSPACE log file: /oracle/QLS/sapreorg/seneityh.tbr

BR0280I BRSPACE time stamp: 2014-02-11 12.46.19
BR1009I Name of database instance: QLS
BR1010I BRSPACE action ID: seneityh
BR1011I BRSPACE function ID: tbr
BR1012I BRSPACE function: tbreorg

BR0280I BRSPACE time stamp: 2014-02-11 12.46.19
BR1039I Selecting information about tables and indexes...
BR0285I This action can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2014-02-11 12.46.38
BR0814I Number of tables in schema of owner SAPSR3: 84397

BR0280I BRSPACE time stamp: 2014-02-11 12.47.05
BR0815I Number of indexes in schema of owner SAPSR3: 101127

BR0280I BRSPACE time stamp: 2014-02-11 12.47.07
BR0660I List display 352 - no selection possible
-------------------------------------------------------------------------------
List of tables for reorganization

  Pos.  Owner    Table                Pt. DgPk.     Rows   Used[KB]  Data[KB:%]

    1 - SAPSR3   TTREEI               NO   1     1378200    146864     91521:62
    2 - SAPSR3   TTREEP               NO   1      439270     42736     35605:83
    3 - SAPSR3   TTREET               NO   1       56890      6528      5167:79
    4 - SAPSR3   TTREE_APPL           NO   1       16943      2000      1241:62
    5 - SAPSR3   TTREE_FLNK           NO   1        2382       584       235:40

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2014-02-11 12.47.56
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2014-02-11 12.47.56
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREEI,... (5 tables)

 1 * Reorganization action (action) ............ [reorg]
 2 - Reorganization mode (mode) ................ [online]
 3 - Create DDL statements (ddl) ............... [yes]
 4 ~ New destination tablespace (newts) ........ []
 5 ~ Separate index tablespace (indts) ......... []
 6 - Parallel threads (parallel) ............... [1]
 7 ~ Table/index parallel degree (degree) ...... []
 8 ~ Category of initial extent size (initial) . []
 9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... [ora_proc]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRSPACE time stamp: 2014-02-11 12.48.01
BR0663I Your choice: '4'
BR0681I Enter string value for "newts" []:
PSAPSR3731
BR0280I BRSPACE time stamp: 2014-02-11 12.48.11
BR0683I New value for "newts": 'PSAPSR3731'

BR0280I BRSPACE time stamp: 2014-02-11 12.48.11
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREEI,... (5 tables)

 1 * Reorganization action (action) ............ [reorg]
 2 - Reorganization mode (mode) ................ [online]
 3 - Create DDL statements (ddl) ............... [yes]
 4 ~ New destination tablespace (newts) ........ [PSAPSR3731]
 5 ~ Separate index tablespace (indts) ......... []
 6 - Parallel threads (parallel) ............... [1]
 7 ~ Table/index parallel degree (degree) ...... []
 8 ~ Category of initial extent size (initial) . []
 9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... [ora_proc]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2014-02-11 12.48.15
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1098W Tablespace PSAPSR3731 should be auto-extensible for reorganization
BR0691W Warning by checking input value for 'newts'

BR0280I BRSPACE time stamp: 2014-02-11 12.48.15
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-02-11 12.48.17
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2014-02-11 12.48.17
BR1108I Checking tables for reorganization...

BR0280I BRSPACE time stamp: 2014-02-11 12.48.17
BR1112I Number of tables selected/skipped for reorganization: 5/0

BR0280I BRSPACE time stamp: 2014-02-11 12.48.17
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-02-11 12.48.24
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0370I Directory /oracle/QLS/sapreorg/seneityh created

BR0280I BRSPACE time stamp: 2014-02-11 12.48.25
BR1101I Starting 'online' table reorganization...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.25
BR1124I Starting 'online' reorganization of table SAPSR3.TTREEI ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.47
BR1105I Table SAPSR3.TTREEI reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.47
BR1141I 1 of 5 tables processed - 1378200 of 1893685 rows done
BR0204I Percentage done: 71.42%, estimated end time: 12:48
BR0001I ************************************______________
BR0280I BRSPACE time stamp: 2014-02-11 12.48.47
BR1124I Starting 'online' reorganization of table SAPSR3.TTREEP ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.54
BR1105I Table SAPSR3.TTREEP reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.54
BR1141I 2 of 5 tables processed - 1817470 of 1893685 rows done
BR0204I Percentage done: 94.54%, estimated end time: 12:48
BR0001I ***********************************************___
BR0280I BRSPACE time stamp: 2014-02-11 12.48.54
BR1124I Starting 'online' reorganization of table SAPSR3.TTREET ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.56
BR1105I Table SAPSR3.TTREET reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.56
BR1141I 3 of 5 tables processed - 1874360 of 1893685 rows done
BR0204I Percentage done: 97.98%, estimated end time: 12:48
BR0001I *************************************************_
BR0280I BRSPACE time stamp: 2014-02-11 12.48.56
BR1124I Starting 'online' reorganization of table SAPSR3.TTREE_APPL ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.57
BR1105I Table SAPSR3.TTREE_APPL reorganized successfully
BR0280I BRSPACE time stamp: 2014-02-11 12.48.57
BR1124I Starting 'online' reorganization of table SAPSR3.TTREE_FLNK ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR1105I Table SAPSR3.TTREE_FLNK reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR1141I 5 of 5 tables processed - 1893685 of 1893685 rows done
BR0204I Percentage done: 100.00%, estimated end time: 12:48
BR0001I **************************************************

BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR1102I Number of tables reorganized successfully: 5

BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2014-02-11 12.42.34
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2014-02-11 12.42.37
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user

BR1008I End of BRSPACE processing: seneithh.tbr 2014-02-11 12.42.37
BR0280I BRSPACE time stamp: 2014-02-11 12.42.37
BR1007I BRSPACE terminated with errors

###############################################################################

BR0292I Execution of BRSPACE finished with return code 2

BR0280I BRTOOLS time stamp: 2014-02-11 12.42.37
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRTOOLS time stamp: 2014-02-11 12.42.38
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2014-02-11 12.42.40
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2014-02-11 12.42.40
BR0654I BRTOOLS terminated with errors

Change oracle parameter for process and sessions

Change oracle parameter for process and sessions

Above parameter can’t be changed directly through ALTER command.

SQL> select name,value,ISSES_MODIFIABLE,ISSYS_MODIFIABLE from v$parameter where NAME in ('sessions','processes');

NAME                 VALUE                ISSES ISSYS_MOD

-------------------- -------------------- ----- ---------

processes            190                  FALSE FALSE

sessions             384                  FALSE FALSE

SQL>

SQL> ALTER SYSTEM SET processes=600 SCOPE=BOTH;

ALTER SYSTEM SET processes=600 SCOPE=BOTH

                 *

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set sessions=1200 scope=both;

alter system set sessions=1200 scope=both

                 *

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

Follow below step to change.

1.    Create Pfile from SPFILE.

SQL> create pfile from spfile;

File created.

SQL>

Will create file init<SAPSID>.ora (initQLS.ora) inside /oracle/QLS/112_64/dbs directory.

2.    Open Pfile with ora<sapsid> user

vi /oracle/QLS/112_64/dbs/initQLS.ora

Change above parameter as per your requirement.

3.    In SQL plus shutdown database.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

4.    Start database using Pfile.

            SQL> startup pfile='/oracle/QLS/112_64/dbs/initQLS.ora';

ORA-32006: REMOTE_OS_AUTHENT initialization parameter has been deprecated

ORACLE instance started.

Total System Global Area 4676788224 bytes

Fixed Size                  2188952 bytes

Variable Size            2348812648 bytes

Database Buffers         2315255808 bytes

Redo Buffers               10530816 bytes

Database mounted.

Database opened.

5.    Create SPfile from Pfile.

SQL> create spfile from pfile;

File created.

SQL>

6.    Shutdown database.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

7.    Start database with SPFILE.

SQL> startup;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 4676788224 bytes

Fixed Size                  2188952 bytes

Variable Size            2348812648 bytes

Database Buffers         2315255808 bytes

Redo Buffers               10530816 bytes

Database mounted.

Database opened.

SQL>

How to import transport request of other system into SAP system

Having multiple transport requested exported from other system in compress file.

1. Login with <SAPSID>adm user create folder /tmp/transportrequest
2. Copy all extracted file into /tmp/transportrequest folder
3. move data files into data directory of transport 
    cd /tmp/transportrequest
    mv R* /usr/sap/trans/data
4. move data files into data directory of transport
    cd /tmp/transportrequest
    mv K* /usr/sap/trans/cofiles
5. Login into SAP system
6. call transaction stms_import
7. follow below steps for all request
    choose extras -> Other Requests -> Add
    Enter transport request number i.e. D11K901027
    choose right arrow
8. To import request choose request and choose import request and your client on which would like to import.

Drop datafile of temp tablespace

ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata3/temp_5/temp.data5';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_6/temp.data6';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_7/temp.data7';

cd /oracle/PIP/sapdata3/
rmdir temp_5


cd /oracle/PIP/sapdata6/
rmdir temp_6

cd /oracle/PIP/sapdata6/
rmdir temp_7

Switching oracle database archive to non archive mode and vice versa.

switching off archive mode.

    shutdown immediate;
    startup mount;
    alter database noarchivelog;
    alter database open;

switching on archive mode.

    shutdown immediate;
    startup mount;
    alter database archivelog;
    alter database open;

Mount windows share into HP-UX

Create mount point
mkdir winshare

Mount H drive of windows server 10.32.0.164 where nikunj is local user of that server and having rights on shared drive H

# cifsmount //10.32.0.164/h /winshare -U nikunj -P testing
The CIFS Client is not running.
#

Start CIFS Client

# cifsclient
CIFS Client started; process id: 14102

Mount H drive of windows server 10.32.0.164
# cifsmount //10.32.0.164/h /winshare -U nikunj -P testing
LOC: Netbios session refused
LOC: Netbios session refused


To resolve LOC: Netbios session refused error do the entry into /etc/hosts
10.32.0.164     BACKUPSRV.domain.com


Mount H drive of windows server 10.32.0.164
# cifsmount //BACKUPSRV.domain.com/h /winshare -U nikunj -P testing


Check file system mounted
# bdf
Filesystem          kbytes    used   avail %used Mounted on
backupsrv.domain.com:/h
                   2711840 2711840       0  100% /winshare
#


Unmount mounted windows shared
cifsumount /winshare


Stop CIFS Client
# cifsclient stop
No CIFS filesystems to unmount.
The CIFS Client has been shut down.
#

R3trans -d failed when oracle archiver get stuck

archiver location is full.
# bdf
Filesystem             kbytes    used            avail %used Mounted on
/dev/vg00/lvol12   20971520 20947873   22276  100% /oracle/PIP/oraarch

test R3trans -d which failed with return code 0012.
tstmig:pipadm 42> R3trans -d
This is R3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_o                                                                                        ra_tnsname = 'PIP'"
R3trans finished (0012).
 
archiver location free
tstmig:pipadm 43> bdf
Filesystem          kbytes    used   avail %used Mounted on
/dev/vg00/lvol12   20971520 1151649 18581263    6% /oracle/PIP/oraarch




test R3trans -d which success with return code 0000.
tstmig:pipadm 44> R3trans -d
This is R3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).
unicode enabled version
R3trans finished (0000).
tstmig:pipadm 45>

How to make table editable in sap &SAP_EDIT

How to make table editable in sap

Earlier you can use &SAP_EDIT functionality in se16n so users can update table.

SAP has removed this function through note 1420281 which was delivered in Release 600 with Support Package 17 and Support Package 18.

Now other alternet as below.

1. call transaction se16n
2. Type '/h' to enter into the debug mode.
3. type two below variable name
    gd-sapedit
    gd-edit
4. change there value to X
5. execute

congratulation table open in editing mode.