Subscribe:

Ads 468x60px

Pages

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 -install
  • enter the system ID
  • enter Hardware key
  • enter installlation no
  • enter expiration date - 99991231
  • enter the license_key
License 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 root
sudo 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 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; 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 integration system.

6: When used in import phase, it helps to overwrite objects in unconfirmed repairs.

8: During import phase it ignores the limitations caused by the table classification.

9: During import it ignores that the system is locked for this kind of transport.

Login to sqlplus

From unix, execute

  • sqlplus "/as sysdba"

Changing user from root

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
Related Posts Plugin for WordPress, Blogger...