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
Subscribe to:
Posts (Atom)