HOW TO SAP

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

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; 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. Continue Reading

Login to sqlplus

October 24, 2009 oracle,

From unix, execute

sqlplus "/as sysdba"

Changing user from root