How to make existing or new SAP system running on Oracle database to set as Read Only

 > Lets pick a SAP system running on Oracle DB and you want to set it permanant as Read Only System

To make the system in read only so that no one (none user) could make any changes into system, in this case changes made on abap side or program level will never updated into database.

 1- Now stop SAP Application ( CI<Central instance>& DB <database instance>)

    1.1 -  Login to SAP NW OS box(suppose its Aix box) with sidadm user

       Use command stopsap  à It will stop SAP (CI & DB both)

1.2 -   Now Login to OS box with orasid and connect to database through SQL , then start database in mount phase & use sql command to open database in read only mode.

  sqlplus /as sysdba > startup mount

               > alter database open ready only ;

               > commit;




2. Now start SAP CI via login with sidadm again , you may use following command

Now start SAP CI via login with sidadm again , you may use following command

·       startsap

or

·       startsap r3




3.  In the first login of SAP system, you will get short dumps like no written allowed but this is normal in our case , because our target was to make SAP system 100% read only.




Comments

Post a Comment

Popular posts from this blog

How to do cache Cleanup in SAP FIORI Systems

  There are two different kind of transactions used to clean up the cache data in SAP FIORI Login to SAP FIORI BACKEND ECC system with any user which is having right access to fire tcode /n/iwbep/cache_cleanup Execute the tcode and select button <Cache Cleanup for All module>,it will clear the cache data into FIORI Backend system. Now Login to SAP FIORI Front End Netweaver System with any user which is having right access to fire tcode “/UI2/DELETE_CACHE”  Execute tcode “/UI2/DELETE_CACHE”  make sure check box <delete in all client> selected   and user field as “* “ also selected Similarly execute Tcode ““/UI2/DELETE_CACHE_AFTER_IMP”” on FIORY Front End Netweaver System with option >delete in all client and User Filed as “*”   Similarly execute   tcode “/UI2/CHIP_SYNCHRONIZE_CACHE” on FIORY Front End Netweaver System with option >delete in all client and User Filed as...
Read more