Need to move or copy R3 to another server or change the SID or instance number? It can be done without an install...
quite easily on Unix/Oracle systems.
Move or copy SAP R3 on Unix/Oracle, changing hostname, SID and instance without installing R3 or Oracle.
<SID> = SAP SID <HOST> = Host name <##> = SAP Instance number <SAPINSTNAM> = SAP Instance name (e.g. DVEBMGS00) <SAPORAHOME> = Home directory of SAP Oracle user <SAPADMHOME> = Home directory of SAP Administrator <SAPPROFILE> = Directory containing SAP profiles <ORATNSHOME> = Directory containing oracle TNS control files <ORAHOME> = Oracle Home
- Stop SAP and Oracle (shutdown normal)
- Copy all files under /oracle/<SID>, /usr/sap/<SID> and /sapmnt/<SID>
- Rename and/or edit following changing hostname, SID and instance number
<SAPORAHOME>/.init<SID>.ora /.dbenv_<HOST>.csh /.dbenv_<HOST>.sh /.sapenv_<HOST>.csh /.sapenv_<HOST>.sh <ORATNSHOME>/tnsnames.ora /listener.ora <SAPADMHOME>/startsap_<HOST>_<##> /stopsap_<HOST>_<##> /.dbenv_<HOST>.csh /.dbenv_<HOST>.sh /.sapenv_<HOST>.csh /.sapenv_<HOST>.sh <SAPPROFILE>/<SID>_<SAPINSTNAM>_<HOST> /START_<SAPINSTNAM>_<HOST> /DEFAULT.PFL /usr/sap/PRD/<SAPINSTNAM>
- Relink Oracle executables
cd <ORAHOME>/rdbms/lib edit nmliblist and change <SID> make -f ins_rdbms.mk install
- Create script to build new DB control files
svrmgrl connect internal shutdown normal startup nomount alter database backup controlfile to trace resetlogs; alter database open; alter system switch logfile (one for each group) shutdown normal exit rename the trace file in <ORAHOME>/saptrace/usertrace/ to control.sql edit this file delete everything but the CREATE CONTROLFILE command change the CREATE CONTROLFILE statement to CREATE CONTROLFILE SET DATABASE <SID> RESETLOGS ARCHIVELOG change <SID> and alter any file location changes
- Remove or rename old control files
- Build new DB control files
svrmgrl connect internal startup nomount @control.sql alter database open resetlogs; exit
- Create the services entries in /etc/services
sapdp<##> 32<##>/tcp sapgw<##> 33<##>/tcp sapms<SID> 36<##>/tcp sapgw<##>s 48<##>/tcp