| | Script to analyze table subpartitions
This script will analyze specified subpartitions in a loop, useful when some partitions / subpartitions in the table have been modified or re-built.
BEGIN
FOR rec IN
(SELECT subpartition_name
FROM all_tab_subpartitions
WHERE table_owner = 'SCHEMA_OWNER'
... | | More...
06/27/07 | | | | | | | | |
|
| | How to run sapinst on different port
When you have (or planning to have) more than one SAP instance on the same server, it may happen that you will need to run SAPinst at the same time as somebody else. If you attempt to run it on default port it will not start, the solution is to ... | | More...
06/05/07 | | | | | | | | |
|
|
| | Unlock shadow instance
To login to the shadow instance with a user account other than SAP* or DDIC you need to unlock it:
1. Log on as user adm
2. Enter the following command (this assumes you use /usr/sap/put as your upgrade directory):
cd /usr/sap/put/bin
./R3up unlockshd
or
./SAPup unlockshd
If shadow instance isn't running you can ... | | More...
05/18/07 | | | | | | | | |
|
| | Remove old archive logs
grep '.arc' brarchive.log | grep ARCHIVE | grep -v '.dbf' | grep -v '.cds' | \
awk '{printf("rm %s\n", $2)}' > rm_old_logs.ksh
| | More...
05/17/07 | | | | | | | | |
|
| | How to disable popup - Ran out of profile storage space
Sometimes roaming profiles can be real pain, i.e. if you are running a software installation across the network and the installer fills up your profile directory (for example java puts alot of crap there). What you get is pop-up window coming up every few seconds notifying you that you're out ... | |  
More...
05/07/07 | | | | | | | | |
|
| | How to manually clean up shared memory / semaphors
This procedure may be useful for something like Oracle database, SAP or Peoplesoft when application was shutdown but shared memory hasn't been clened up for some reason.
Get the list of all semaphors for a user:
ipcs | grep [username]
Remove (clean up) semaphor:
ipcrm -s [semaphor id]
You can also use the command below ... | | More...
04/26/07 | | | | | | | | |
|
|
| | Run external script in psql
To run a script against a PostgreSQL database from Unix / Linux command prompt do the following:
psql [database name] < [script name]
Otherwise if you are connected to database through psql and want to call an external script you can use \i for example:
testdb=# \i [script name]
| |
More...
03/30/07 | | | | | | | | |
|
| | brbackup example
This command will perform full database backup. Run it as ora user.
brbackup -u / -t online -c force -m all -p initSID.sap | | 
More...
03/08/07 | | | | | | | | |
|
<< 1 | 2 | Page 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 >>
|
