Salesforce

How to start a database using the startup values in the conmgr.properties file

« Go Back

Information

 
TitleHow to start a database using the startup values in the conmgr.properties file
URL NameP139813
Article Number000135750
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.x, 11.x, 12.x
OS: All supported platforms
Other: AdminServer
Question/Problem Description
Can a database be started with the pre-configured startup parameters in the conmgr.properties file?
How to PROSERVE a database using the startup values used by the AdminServer
How to start a database without having to review startup values specified in the conmgr.properties file?
Is it possible use the conmgr.properties to start a database using the proserve/_mprosrv command
How to use _mprosrv to start a database using the startup values specified in the conmgr.properties file and have it register with the AdminServer
How to get databases to register with the AdminServer when started with proserve 
How to allow databases to reconnect to OEM when started from the command line
How register a database with the AdminServer when it is started with a cron job or scheduled task
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Once a database is configured to start under the AdminServer, apart from using the DBMAN -start command line utility, the database can also be started multi-user with PROSERVE with the same pre-configured startup parameters in the conmgr.properties file and will register with the AdminServer that is currently running by using the following three parameters:
  1. -adminport : To have the database register with the AdminServer,  What are the  parameters "-port=" and -adminport=" used for by the AdminServer?  
  2. -properties : default <DLC>\properties\conmgr.properties are used when not specified and the DLC environment variable has been set
  3. -servergroup : default <db>.defaultconfiguration.defaultservergroup, where the "Logical name" of the database object specified in the conmgr.properties is used, not the physical database name
Another means of finding these parameters is reviewing the command line used by AdminServer written to the admserv.log file as message (7402) enclosed between brackets ([ ... ]). The -classpath is not strictly needed, but may be used when troubleshooting the cause of the startup failure when started under the AdminServer or with DBMAN. 

Example 1: Start a database with two login brokers using the servergroups from one configuration, additionally specifying ServerType to restrict client/server connections which was not pre-configured, to register with the AdminServer once started:

$   proserve dbname -servergroup ldbname.defaultconfiguration.defaultservergroup -ServerType sql -adminport 7846
$   proserve dbname -m3 -servergroup ldbname.defaultconfiguration.servergroup-1 -ServerType 4GL -adminport 7846

Where "ldbname" is the display name of the logical database configuration. The physical database name may be different.

When there are issues with the AdminServer running or simply when needing to start a database without being managed, but assuring the same parameter configuration is used without having to interpret conmgr.properties names into equivalent command-line startup parameters

Example 2: Starting a database with the primary login broker, adding additional parameters as needed, which will not register with the AdminServer
 
$   proserve dbname -servergroup ldbname.defaultconfiguration.defaultservergroup -Mm 8192

Example 3: Starting a database with the primary login broker, using a different conmgr.properties file or when the DLC environment variable is not set
 
$   proserve dbname -servergroup ldbname.defaultconfiguration.defaultservergroup -properties <full-path>\conmgr.properties

NOTE: Proserve without the -servergroup and -adminport does not normally register with the AdminServer and therefore the AdminServer / OEM will have no awareness of the database state (running or offline).
Workaround
Notes
Progress Articles:

 How to run two sets of databases on different Windows cluster nodes using conmgr.properties files  
 How to troubleshoot error 8619 for databases started with AdminServer 

NOTE: If the database is started with proserve and the -servergroup ldbname.defaultconfiguration.defaultservergroup is not used to start the database then the AdminServer will reject the registration of the database due mismatch in the parameter given at command line as the AdminServer expects the database to report one of the defined servergroup configurations when registering.
Example of the message reported:
proenv>proserve sports2000 -S 2500 -adminport 7846
OpenEdge Release 11.7.19 as of Fri Feb  2 14:41:19 EST 2024
18:23:08 BROKER     This broker will terminate when session ends. (5405)
18:23:08 BROKER     The startup of this database requires 17Mb of shared memory.  Maximum segment size is 1024Mb.
18:23:08 BROKER  0: Multi-user session begin. (333)
18:23:08 BROKER  0: Before Image Log Initialization at block 0  offset 632. (15321)
18:23:08 BROKER  0: Login by richards on CON:. (452)
18:23:08 BROKER  0: Started for 7077 using TCP IPV4 address 0.0.0.0, pid 10008. (5644)
18:23:08 BROKER  0: Connecting to Admin Server on port 7846. (8836)
18:23:08 BROKER  0: Successfully connected to AdminServer on port 7846 using TCP/IP IPV4 address 10.248.7.192. (14262)
18:23:08 BROKER  0: Registration ACK not received, msgcode=21. (9148)
18:23:08 BROKER  0: Admin Server rejected registration. (8844)
18:23:08 BROKER  0: Unrecoverable error in connection to Admin Server, running unmanaged. (8850)

admserv.log contains:
[2024/05/03@18:23:08.897-0400] [0] [Database]            * Property file mismatch - sending denial message. Expecting c:\dlc\properties\conmgr.properties (8500)
Keyword Phrase
Last Modified Date5/3/2024 10:32 PM

Powered by