Thursday, January 30, 2014

Change oracle parameter for process and sessions



Change oracle parameter for process and sessions

Above parameter can’t be changed directly through ALTER command.

SQL> select name,value,ISSES_MODIFIABLE,ISSYS_MODIFIABLE from v$parameter where NAME in ('sessions','processes');

NAME                 VALUE                ISSES ISSYS_MOD
-------------------- -------------------- ----- ---------
processes            190                  FALSE FALSE
sessions             384                  FALSE FALSE

SQL>

SQL> ALTER SYSTEM SET processes=600 SCOPE=BOTH;
ALTER SYSTEM SET processes=600 SCOPE=BOTH
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SQL> alter system set sessions=1200 scope=both;
alter system set sessions=1200 scope=both
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

Follow below step to change.
1.    Create Pfile from SPFILE.
SQL> create pfile from spfile;

File created.

SQL>

Will create file init<SAPSID>.ora (initQLS.ora) inside /oracle/QLS/112_64/dbs directory.

2.    Open Pfile with ora<sapsid> user
vi /oracle/QLS/112_64/dbs/initQLS.ora

Change above parameter as per your requirement.

3.    In SQL plus shutdown database.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

4.    Start database using Pfile.
            SQL> startup pfile='/oracle/QLS/112_64/dbs/initQLS.ora';
ORA-32006: REMOTE_OS_AUTHENT initialization parameter has been deprecated
ORACLE instance started.

Total System Global Area 4676788224 bytes
Fixed Size                  2188952 bytes
Variable Size            2348812648 bytes
Database Buffers         2315255808 bytes
Redo Buffers               10530816 bytes
Database mounted.
Database opened.

5.    Create SPfile from Pfile.

SQL> create spfile from pfile;

File created.

SQL>
6.    Shutdown database.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL>
7.    Start database with SPFILE.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 4676788224 bytes
Fixed Size                  2188952 bytes
Variable Size            2348812648 bytes
Database Buffers         2315255808 bytes
Redo Buffers               10530816 bytes
Database mounted.
Database opened.
SQL>

Wednesday, January 08, 2014

How to import transport request of other system into SAP system

Having multiple transport requested exported from other system in compress file.

1. Login with <SAPSID>adm user create folder /tmp/transportrequest
2. Copy all extracted file into /tmp/transportrequest folder
3. move data files into data directory of transport 
    cd /tmp/transportrequest
    mv R* /usr/sap/trans/data
4. move data files into data directory of transport
    cd /tmp/transportrequest
    mv K* /usr/sap/trans/cofiles
5. Login into SAP system
6. call transaction stms_import
7. follow below steps for all request
    choose extras -> Other Requests -> Add
    Enter transport request number i.e. D11K901027
    choose right arrow
8. To import request choose request and choose import request and your client on which would like to import.