Run TP command in background
In Unix, nohup tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128 & ...
Continue Reading
Optimizer and DBchecks
October 26, 2009
oracle,
In Unix, = to run the update stats, use brconnect -u / -c -f stats -t ALL >> you may also use the above to address the kosima dbverify alert. = to run the dbcheck manually again. brconnect -u / -c -f check...
Continue Reading
TP command and how to check status
October 26, 2009
TRANSPORT,
how to add buffer via TP tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28 tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128 Check status of the transport /usr/sap/trans/tmp tail -f P28IT00687.D28 You may also user ps -ef|grep tp...
Continue Reading
Install SAP license Unix level
In Unix with SIDADM, saplicense -install enter the system ID enter Hardware key enter installlation no enter expiration date - 99991231 enter the license_key License successfully installed....
Continue Reading
Refresh df every 5mins
am2hc181:orad28 253> sh $ while true > do > df -gt | grep archivpool > sleep 300 > done C4DEM1SYM62_2324:/vol/ARCHIVE00/SITI2324_archiv_pool/D28_archivpool 1020.00 481.24 538.76 48% /oracle/D28/archivpool...
Continue Reading
Create control files
October 24, 2009
oracle,
In DBrefresh, you will need to create controlfile from tracefile. In sqlplus, alter database backup controlfile to trace resetlogs; this file can be found in /oracle/SID/saptrace/usertrace ...
Continue Reading
SQL Alter tabase
October 24, 2009
oracle,
During DB refresh, you will need to copy sapdata. Before doing so, you have to alter database backup mode for tablespace to active In sqlplus, ALTER DATABASE BEGIN BACKUP; once complete the copy of files, ALTER DATABASE END BACKUP; ...
Continue Reading
Change oraarch directory to a larger folder
October 24, 2009
oracle,
This command does not need to restart db.You can do it at run time In sqlplus, SQL> show parameter log_archive_dest; SQL> startup mount; SQL> alter system set log_archive_dest='/oracle/D28/oraarch' scope=memory; * LOCATION will be the new path for your archive log folder. * you may remove LOCATION word if sqlplus...
Continue Reading
Unix command
October 24, 2009
unix,
mkdir dbxxx - Make dir dbxxx df - g . - Current folder size df - g | grep sap - grep folder with ms.sap rm -rf exe* - Remove file and folder with name exe* cp -r exe...
Continue Reading
Manuall import transport from Unix
October 24, 2009
TRANSPORT,
In unix, execute tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28 tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128 P28KT00687 is the transport number DOMAIN_D28 is the transport domain (you get from stms) D28 is the target csystem client300 is the target client U128 is the combination of below: 0: Called a overtaker;...
Continue Reading
Login to sqlplus
October 24, 2009
oracle,
From unix, execute sqlplus "/as sysdba" ...
Continue Reading
Changing user from root
October 24, 2009
unix,
Once login to your ID, you execute sudo su - root then you can change to su -t01adm then you can also change to su - orat01 ...
Continue Reading
Migration Explained
September 29, 2009
migration,
Migration is a synonym for heterogeneous system copy. UNICODE CONVERSION Your SAP system is converted from non-Unicode to Unicode. This can also be done as part of a homogeneous or heterogeneous system copy. DISTRIBUTED SYSTEM A system that resides on more than one physical or virtual hosts in a...
Continue Reading
VNC from Windows to SuSE 10
August 20, 2009
linux,
Linux, execute yast2 > security and users > Local Security Custome > next until you see "Allow remote graphical login" (see below) Check and save. Terminal > su root vncserver Enter a password to access desktop Once finish go to cd /root/.vnc/ vi xstartup and change the original to...
Continue Reading
Mount Windows folder to Linux
August 20, 2009
linux,
1. SU root 2. Enter below command 3. test01:/ # mount -t cifs //windows/share /media/install -o user=Domain/username...
Continue Reading
BRTOOLS to turn off archive log
August 20, 2009
Firstly you check acrhivelog status BRTOOLS 1 = Instance management 6 - Show instance status Continue x2 2 - Show instance status Information about the status of database instance R53 1 - Instance number (number) ........... 1 2 - Instance thread (thread) ........... 1 3 - Instance status (status)...
Continue Reading
SuSE Linux + Netweaver 2004s installation guide
June 21, 2009
linux,
netweaver,
step by step installation guide,
Content 1) Installalling SuSE Linux Enterprise Server 10 2) Installing SAP Netweaver 2004s (ABAP+JAVA) 3) Install SAP GUI (java based) ======================================================================== 1) Installing SUSE Linux Enterprise Server 10 for AMD64 and Intel 64 ======================================================================== 01. Download the required image and burn it into a bootable DVD. 02. Power up...
Continue Reading
Subscribe to:
Posts (Atom)