Pages

▼
Friday, April 11, 2014

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.1120...
1 comment:
Monday, March 24, 2014

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_lastb...
2 comments:
Tuesday, February 11, 2014

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...
Thursday, January 30, 2014

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> sele...
Wednesday, January 08, 2014

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/...
Wednesday, November 20, 2013

Drop datafile of temp tablespace

›
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata3/temp_5/temp.data5'; ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/ora...
Tuesday, November 19, 2013

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; switc...
Tuesday, May 14, 2013

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 o...
7 comments:
Thursday, December 27, 2012

R3trans -d failed when oracle archiver get stuck

›
archiver location is full . # bdf Filesystem             kbytes    used            avail %used Mounted on /dev/vg00/lvol12   20971520 2094...
69 comments:
Wednesday, October 17, 2012

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...
4 comments: