Posts

Showing posts from October, 2009

Run TP command in background

In Unix,

nohup tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128 &

Optimizer and DBchecks

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

TP command and how to check status

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

Install SAP license Unix level

In Unix with SIDADM,

saplicense -installenter the system IDenter Hardware keyenter installlation noenter expiration date - 99991231
enter the license_keyLicense successfully installed.

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

Create control files

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

SQL Alter tabase

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;

Change oraarch directory to a larger folder

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 gives error.

Unix command

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 /oracle/W91/saptrace/usertrace    - copy folder exe to  /oracle/W91/saptrace/usertrace

sudo /usr/bin/rootsh -i -u rootsudo rootsh -i -u rb4adm(don't copy paste, type manually)

Manuall import transport from Unix

In unix, execute

tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128P28KT00687 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; change request can be imported from buffer without deleting it and then uncoditional mode 1 is used to allow another import in the correct location.

1: If U1 is used with the export then it ignores the correct status of the command file; and if it is used with import then it lets the user import the same change request again.

2: When used with tp export, it dictates the program to not to expand the selection with TRDIR brackets. If used in tp import phase, it overwrites the originals.

3: When used with tp import, it overwrites the system-dependant objects.

5: During the import to the consolidation system it permits the source systems other than the integra…

Login to sqlplus

From unix, execute

sqlplus "/as sysdba"

Changing user from root

Once login to your ID, you execute

sudo su - rootthen you can change to su -t01admthen you can also change to su - orat01