on 10-12-2016 8:26 PM
Hello SAP Basis Exports,
As part of new hardware upgrade, we have build new DB's with same oracle version on new hosts. It's went good. Now our current SAP CI and App's need to build on top of new DB's or Is their any way to re-point the current sap application servers to New Oracle DB's. (it's distributed environment)
Please advise the best method to complete my tech-refresh project.
It's highly appreciate, if you can also send my any doc's or steps for each method which you suggest.
Hope,..A Great Day,..
Thank you - MBK
Assuming that you will be restoring the database from the old server to the newly installed server. Once that is done you will need to modify the SAP profiles with the host name of the new DB host. Also the necessary file systems should be mounted between the servers. The tnsnames.ora files (The one under TNS_ADMIN and the one where listener.ora lies) should be modified with the new host name.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good to hear Mohan.
Regards,
Harish Karra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Reagan Benjamin and Harish Karra,...
I am successfully completed my cutover, all the SAP Applications and Non SAP integration like Vertex, IXOS are up and running fine.
It's appriciate your suport and help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As long as the profiles and SQL*Net files are set with the correct hostname, the system should come up. The TNS_ADMIN location should have the tsnames.ora for the Apps so make sure to update them. As you have a distributed setup you should check if the BRTools are working fine after the DB move. Apart from that you should move all the backup related configuration files from the old server to the new one. If there are some external monitoring systems (Possibly Solution Manager?) connecting to the database then you may update the hostname there are well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- SAP File systems and other mount points should be re-point to New DB's
Not sure which mount point you are talking ? Only CI and APPs share /sapmnt in SAP system & you never point/repoint any FS between servers other than mounting /sapmnt. For your cutover, only hostname changes (of DB host) in SAP profiles, Listener.ora, TNSNAMES.ora and replacing these files in TNS_ADMIN path and the host file entries are required.
Regards,
Harish Karra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for information Dishant & Reagan,..
Here are list of action items for my next week cutover plan,..
- SAP Profiles with NEW DB hosts
- Firewall Ports b/w SAP CI and Apps servers and New DB Hosts
- SAP File systems and other mount points should be re-point to New DB's
- Host entries of new DB host in Hosts file
- tnsnames.ora and listener.ora modify with new DB host names.
Please let me know, if some thing i have missed here,..
Appreciate your great help,.. and i will keep update the status once my cutover completes.
Thanks - MBK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Reagan has already covered the details . just to add please do add Host entries of new DB host in Hosts file.
and you can check the connection using R3trans -d to see the details .
and also make sure your listener port of new DB server is pinging from CI/App Server.
Cheers,
Dishant.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.