Specifying Databases and Application Servers

From the Edit Profile dialog box, select the Database/Application Servers tab.

Use this tab to specify the configured databases and application servers associated with this profile. When a user enters one of these databases or application servers in the PeopleSoft Signon dialog box, PeopleTools uses the registry settings associated with this profile.

Note:

You can assign multiple databases and application servers to a single profile. However, each database and application server must be assigned to only one profile. If you try to add a database to a second profile, PeopleSoft Configuration Manager asks you if you want to remove it from the previous profile and add it to the current one.

Note:

Before you enter a database or application server on this tab, you should have already installed and configured it as documented in the PeopleSoft installation documentation for your database platform.

Application Server Name

Enter a name for an application server that you have configured. This name will appear in the drop-down list box on the PeopleSoft Signon dialog box. Choose a name that's intuitive for your site.

Note:

Application server names cannot exceed 24 characters.

Machine Name or IP Address

Enter the IP address or the resolvable server name of the application server in the Application Server Name field. This is listed in the [Workstation Listener] section of the PSAPPSRV.CFG file. For example, you could enter 192.0.2.20 or srv-hp32.

See Workstation Listener Options

Port Number

Enter the port number for the application server in the Application Server Name field. A port number is an arbitrary number between 0 and 9999 that is determined by site specifications. This is listed in the [Workstation Listener] section of the PSAPPSRV.CFG file.

See Workstation Listener Options

Note:

To configure SSL for Workstation Listener, you must enter the port number specified for the WSL SSL Port property in PSADMIN.

See Modifications in PSADMIN for more information.

TUXEDO Connect String

Use this field to support dynamic load balancing. You can specify a free-form connect string that allows a client to connect to another application server in case another is either down or being used to full capacity.

Note:

The Tuxedo connect string cannot exceed 1000 characters.

When configuring load balancing, you might choose from the following approaches:

  • Round robin load balancing.

    With this approach, you specify multiple application servers, and each client picks a server randomly. This approach assumes that application server will receive an equal number of connections. To specify round robin load balancing, use the following syntax for the connect string:

    (//IP address 1:port 1|//IP address 2:port 2|//Ip address n:port n)

    You can specify the IP address using either dotted notation or by using the server's DNS name. Either way, the slashes (//) preceding the IP address are required.

    If the selected application server is unavailable, your connection attempt fails, and the system does not try to connect you to the other application servers defined within the parentheses.

    Spaces are not allowed in any part of the connection string. The system automatically removes embedded spaces before storing the value in the registry.

  • Round robin with failover.

    With this approach, you define a failover connection string. Use the following syntax:

    (//IP address 1:port 1|//IP address 2:port 2),(//IP address 3:port 3)

    If the application server selected from the first group of parentheses (IP addresses 1 and 2) is unavailable, the system automatically attempts to connect to an application server defined in the second group (IP address 3). If that application server fails, the system attempts to connect to the next group to the right, sequentially.

    If multiple application servers are defined within any group, the system round-robins between them. If the selected application server fails, the system attempts to connect to the next application server to the right, if any. The following list shows three examples of connect strings that use this approach:

    • (//sp-ibm01:8000|//sp-ibm02:8000),(//sp-nt01:8000)

    • (//192.0.2.88:8000|//192.0.2.88:8050|//192.0.2.88:8080)

    • (//sp-sun01:8000),(//sp-sun02:8000),(//sp-sun03:8000)

Domain Connection Password

Specify for the password for establishing a connection to the domain. The domain configuration contains the DomainConnectionPwd parameter, which provides an additional layer of security for the domain by preventing connections from any unauthorized clients. Three-tier workstation connections must submit the same password as the specified DomainConnectionPwd value.

For a three-tier Windows workstation connection, you enter the password in the Domain Connection Password field.

Wallet Location

Specify the location of the Oracle Wallet for client.

See Modifications in Configuration Manager for more information.

Wallet Name

Specify the name of the Oracle Wallet for client.

See Modifications in Configuration Manager for more information.

Set and Delete Buttons

When you click Set, your application server information is displayed in the grid at the top of the dialog box. You can enter a new application server name and set up a different server if you like.

Note:

The settings in the grid are not saved until you click Apply or OK. If you click Cancel without first clicking Apply or OK, you lose all the information in the grid.

To remove an application server configuration, select its application server name in the grid and click Delete.