How do I change the password for SharePlex user in the database? (4298402)

How do I change the password for SharePlex user in the database?

How do I change the password for SharePlex user in the database?

General information.

Changing the password for a SharePlex user is a two staged process. The first stage involves changing the password in the connections.yaml file by running the connection commands for setting the username and the password respectively. The second stage involves changing the password in the database by issuing the command "alter user identified by <password>". Here are the details:

The sp_ctrl command “connection” can be used to change the password for SharePlex user as recorded in the connections.yaml file. Here is an example:

connection o.SID1 set user=myuser

connection o.SID1 set password=mypassword

This will result in login credentials for SharePlex user to be updated in the connections.yaml file. However, for the change to be recognized by the database, you will need to carry out the following steps:

1. Shutdown SharePlex
2. Change the password in the database for that user by logging into SQL*Plus as a DBA user and issuing the command:

SQL>alter user <myuser> identified by <mypassword>   (where the myuser and mypassword refer to the user and the password respectively)

1. Restart SharePlex.

For Unix, there is a SharePlex command ora_chpwd that can be used to achieve the above. Running the ora_chpwd command requires SharePlex to be shutdown. See article # 147902 for details. The ora_chpwd command is not documented anymore in SharePlex manuals. For Windows, the “connection” command is the only option. Perhaps the ora_chpwd command was available in older versions but it does not exist for later versions as the “connection” command can achieve this and many more things. For details on “connection” command, please refer to SharePlex Reference Guide.