Run TP command in background
In Unix,
- nohup tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128 &
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
= 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
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
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
$ 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,
In sqlplus,
- alter database backup controlfile to trace resetlogs;
- this file can be found in /oracle/SID/saptrace/usertrace
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,
In sqlplus,
- ALTER DATABASE BEGIN BACKUP;
- once complete the copy of files,
- ALTER DATABASE END BACKUP;
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
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
Continue Reading
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
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
- tp addtobuffer P28KT00687 pf=TP_DOMAIN_D28.PFL D28
- tp import P28KT00687 D28 client300 pf=TP_DOMAIN_D28.PFL U128
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
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
Subscribe to:
Posts (Atom)
Designed By: Blogger Templates | Templatelib