SAP Migration – Win/MaxDB Win & Linux/Oracle DB – PART 6
2.4. Central Instance installation (sapwinci host – Win Srv 2012 (R2))
Start the installation of the last phase – Central Instance:
You can see in the following video all the details of the “Parameter Summary” screen:
Finish with success:
– New LOD system in SAPMMC console (with ASCS and CI Instances):
I will not describe here in detail all the follow-up activities that you need to perform after a heterogeneous system copy, this is not the goal of this document, but you need to read and complete all the steps that are mentioned in the SAP system copy guide and also in the SAP installation guide. Next I’ll describe some tasks that are required to do in a similar scenario:
– Performing a full installation backup (you can use the Oracle BR*Tools);
– Install the SAP license;
– Checking the recommended Oracle database parameters (Check the SAP notes 1431798 (Oracle 11.2.0: Database Parameter Settings); 1171650 (Automated Oracle DB parameter check));
– Updating Oracle optimizer statistics (Check the SAP note 974781 (Oracle internal maintenance jobs);
– Delete all entries from the following tables: DBSTATHORA, DBSTAIHORA, DBSTATIORA, DBSTATTORA;
– Delete the user OPS$<SOURCE_SAPSID>ADM;
– Update the SAP Kernel and the BR*Tools (DBA* files);
– Check the RFC´s, Jobs, STMS, etc…
=> Other tips:
– Check the SAP and Oracle services:
1. Check if the database is running via sqlplus (select status from v$instance;):
2. Check in the linux host all the oracle processes:
3. Check in the windows host all the SAP services:
– Stop SAP / Oracle database (LOD system)
1. Stop the SAP system (LOD) in the sapwinci host as <sid>adm:
2. Stop the Oracle database (LOD) in the saplindb host (using the sqlplus):
3. Stop the Oracle listener service as ora<sid>:
– Start SAP / Oracle database (LOD system)
1. Start the Oracle listener service as ora<sid>:
2. Start the Oracle database (LOD) in the saplindb host (using the sqlplus):
3. Start the SAP system (LOD) in the sapwinci host as <sid>adm:
– Disable Archive log mode (NOARCHIVELOG):
First of all always make sure that you got a backup plan for your SAP system and in this case you need to set the oracle database to “Archivelog Mode” so you can be able to recover your system. But sometimes you may need to set your oracle database to “Noarchivelog Mode“, for instance when you run the SGEN transaction in your SAP system. In this kind of tasks, I always recommend that you change it because if you don´t do this the database will generate a lot of archive logs and possibly will completely fill up the size of your file system. For this task you need to stop the SAP system and then use the following SQL commands:
– Disable the Oracle password life time:
Just a quick reminder about maybe the most common small problem in new 11g installations / upgrades.
When you entering in the Oracle 11g world, remember to do something to the default setting of password life time of 180 days. If you do nothing, your users / schema, the SAP system will cease to work after 180 days, so this is very important. For this you need to run the following sql command:
select profile, limit from dba_profiles where RESOURCE_NAME=’PASSWORD_LIFE_TIME’;
alter profile default limit PASSWORD_LIFE_TIME unlimited;
– BR*Tools for Oracle DBA:
BR*Tools is the program package containing BRSPACE, BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT, and BRTOOLS.
BRTOOLS is the program that displays the character-based menus from which the other BR programs are called. It works together with BRGUI to generate a graphical user interface.
As ora<sid> run the command “brtools”:
– DBA Cockpit
The DBA Cockpit is a platform-independent tool that you can use to monitor and administer your database. It provides a graphical user interface (GUI) for all actions and covers all aspects of handling a database system landscape.
You access the DBA Cockpit by calling transaction DBACOCKPIT:
Thanks for your blog.
It is very helpful.
Thanks master for such a nice documents and screen shots.
Very nice and knowledge full documents.
thanks for sharing, great doc
Nice Document and thanks for sharing it
Very Useful one..:)