on 10-18-2016 3:19 PM
Hello Experts,
i am trying to install a HADR System on a Windows Server 2012 R2 with an empty SAP ASE 16.02.04 Database. I am stuck at the point, where i have to execute the "setuphadr <response file>" command on the companion site. (see 3.3.1 Migrating an SMP Server to an HADR System Step 20: http://help.sap.com/Download/Multimedia/zip-ase1602/SAP_ASE_HADR_Users_Guide_en.pdf)
○ (Windows) – %SYBASE%\%SYBASE_ASE%\bin\setuphadr.bat
D:\sybase\<SID>>%SYBASE%\%SYBASE_ASE%\bin\setuphadr.bat HADR_response.rs
Setup Backup server allow hosts
Backup server on "site2" site: Add host "<primary_system>" to allow dump and load...
Backup server on "site1" site: Add host "<secondary_system>" to allow dump and load...
Setup Backup server allow hosts...Success
Setup RMA
Set SAP ID to "<SID>"...
Set installation mode to "nonBS"...
Set site name "SITE1" with SAP ASE host:port to "<primary_system>:4901" and Replication Server host:port to "<primary_system>:5005"...
Error: Setup RMA...Fail
See log file "D:\sybase<SID>\ASE-16_0\init\logs\setuphadr1018.001" for detail.
I have three services running on each server: 1. database 2. bs 3. DR_Agent.
Port 7001 is used bei the DR_Agent but i don't see a service running on port 5005.
Did i miss any step of the installation guide?
Thanks for your suggestions!
Best regards
Jakob
Reconfiguration of the replication via "sap_set" solved the problem in our case,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mark,
sorry for the late respone, i had some different projects in the meantime.
- yes, all users and passwords are configured in the *.rs file
- as far as i know, there is only the one log file i already posted
- no we have not opened a case with tech support. At the moment we are testing the installation on a internal system, which is not configured for the SAP support
Regarding to the following line there are three ports that should be usable:
SetHost Failing Command sap_set_host SITE1, <system1>, 4901, <system2>, 5005, 7001,
4901 is the regular DB port, 7001 is the dr_agent and 5005 should be the port of the replication server service, but there is no such service running. Did i maybe miss the point in the guide, where this service is created?
I will try to create this service, on both sides, with the following commands from the "HADR Users Guide"
Example 1
Defines a Windows Service on the local machine with the credentials provided:
sap_set_replication_service local, sapuser, sappassword
Example 2
Defines a Windows Service on myhost logical host for the Replication Server belonging to that logical host:
sap_set_replication_service myhost, create
By default, credentials default to the local system account login. You can change the login credentials
using subsequent call to change the credentials.
Example 3
Restarts Replication Server on myhost logical host using the Windows Service for the Replication Server
belonging to that logical host:
sap_set_replication_service myhost, restart
Example 4
Sets or changes the login credentials for the Windows Service on myhost logical host to use SAP
username and SAP password:
sap_set_replication_service myhost, sapuser, sappassword
Best regards,
Jakob
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No ideas?...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Setup HADR/16.0 SP02 PL04 HF1/EBF 26466 SMP/OPT/generic/ase160sp02pl04x/0/Tue Aug 23 2016 06:37:35 PDT 2016
Confidential property SAP AG or an SAP affiliate company.
Copyright 2016
SAP AG or an SAP affiliate company. All rights reserved.
Unpublished rights reserved under U.S. copyright laws.
This software contains confidential and trade secret information of SAP AG or
an SAP affiliate company. Use, duplication or disclosure of the software and
documentation by the U.S. Government is subject to restrictions set forth in
a license agreement between the Government and SAP AG or an SAP affiliate
company, or other written agreement specifying the Government's rights to use
the software and any applicable FAR provisions, for example, FAR 52.227-19.
2016-10-18 15:38:08 (SQL command) use master
2016-10-18 15:38:08 (SQL command) use master
2016-10-18 15:38:09 Setup Backup server allow hosts
2016-10-18 15:38:09 Backup server on "site2" site: Add host "<primary_server>" to allow dump and load...
2016-10-18 15:38:09 sp_hadr_admin config_bs, '<secondary_server>', '<primary_server>'
2016-10-18 15:38:09 Backup server on "site1" site: Add host "<secondary_server>" to allow dump and load...
2016-10-18 15:38:09 sp_hadr_admin config_bs, '<primary_server>', '<secondary_server>'
2016-10-18 15:38:09 Setup Backup server allow hosts...Success
2016-10-18 15:38:09 (SQL command) use master
2016-10-18 15:38:09 (SQL command) use master
2016-10-18 15:38:09 Setup RMA
2016-10-18 15:38:09 Set SAP ID to "<SID>"...
2016-10-18 15:38:09 (SQL command) sap_set sap_sid, <SID>
2016-10-18 15:38:09 Set installation mode to "nonBS"...
2016-10-18 15:38:09 (SQL command) sap_set installation_mode, nonBS
2016-10-18 15:38:09 Set site name "SITE1" with SAP ASE host:port to "<primary_server>:4901" and Replication Server host:port to "<primary_server>:5005"...
2016-10-18 15:38:09 (SQL command) sap_set_host SITE1, '<primary_server>', 4901, '<primary_server>', 5005, 7001
TASKNAMETYPE VALUE
-------- ----------------- -------------------------------------------------------------------------------------------------------------------------------------------
Set HostStart Time Tue Oct 18 15:38:09 CEST 2016
Set HostElapsed Time 00:00:00
SetHost Task Name Set Host
SetHost Task State Error
SetHost Short DescriptionDefine a logical host with hostname and port for both ASE and Replication Server.
SetHost Long Description Validating user specified arguments.
SetHost Failing Command sap_set_host SITE1, <primary_server>, 4901, <primary_server>, 5005, 7001,
SetHost Corrective Actionsap_set_host logical_hostname, ase_hostname, ase_port_number, [report] [, replication_server_host, replication_server_port, DR Agent port ]
SetHost Task Start Tue Oct 18 15:38:09 CEST 2016
SetHost Task End Tue Oct 18 15:38:09 CEST 2016
SetHost Hostname <primary_server>
2016-10-18 15:38:09 (SQL command) sap_pre_setup_check dr, SITE1, site2
TASKNAME TYPE VALUE
-------------------- ----------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------
Diagnose EnvironmentStart Time Tue Oct 18 15:38:09 CEST 2016
Diagnose EnvironmentElapsed Time 00:00:00
DiagnoseEnvironment Task Name Diagnose Environment
DiagnoseEnvironment Task State Error
DiagnoseEnvironment Short Description Diagnose the environment for disaster recovery setup readiness.
DiagnoseEnvironment Task Start Tue Oct 18 15:38:09 CEST 2016
DiagnoseEnvironment Task End Tue Oct 18 15:38:09 CEST 2016
DiagnoseEnvironment Hostname <secondary_server>
ValidateLocalDREnv Task Name Validate Local Disaster Recovery Environment
ValidateLocalDREnv Task State Error
ValidateLocalDREnv Short Description Verify that the local environment is setup and ready for disaster recovery replication setup to run.
ValidateLocalDREnv Failing Command Error Messagesite2 - Adaptive Server Enterprise - The user name or password for the data server maintenance user has not been configured or needs to be re-entered.
ValidateLocalDREnv Hostname <secondary_server>
2016-10-18 15:38:10 Error: Setup RMA...Fail
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.