Changing Passwords
Changing passwords depends on whether they are for a schema, a role, or for a user.
Note:
Passwords can contain only these special characters: ~ # ^ - _ + :
Passwords cannot contain these special characters: & ( ) ' % @ { } | ; , $ . * " < > ? ` ! [ / \ ] =
Passwords are case-sensitive starting from this release.
For more information, see:
- Changing the Password for a User
- Changing the Password for a Schema or Role Using the SET_PWD Utility
- Synchronizing Passwords in the WebLogic Admin Server
- Auditing Passwords
- Changing the Password for the OCPSUB
Parent topic: Setting Up User Accounts
Changing the Password for a User
Users can change their own database passwords either in SQL*Plus or with the Oracle Clinical menu by choosing Admin, then Users, and then Database Password.
In the Oracle Database Password window:
-
Type your password in Enter Password text box.
-
Type it again in the Confirm Password text box.
-
Click OK.
Administrators can change the password for an Oracle Clinical user in SQL*Plus as usual:
-
In SQL*Plus, connect to the database as the SYSTEM user.
-
Reset the password for the user:
alter user user identified by user_password;
Parent topic: Changing Passwords
Changing the Password for a Schema or Role Using the SET_PWD Utility
The following table lists the Oracle Clinical database objects that are protected by encrypted passwords stored in two locations:
-
An Oracle dictionary table
-
An Oracle Clinical passwords table
Use the SET_PWD utility to change the passwords for these accounts, encrypt the new password, and store it in both locations.
Log in to the database server and from the Windows command prompt or UNIX command line, run opa_setup with the required parameters before executing set_pwd.
set_pwd has the following two scenarios:
- Scenario 1: set_pwd rxc db_object_name
- Scenario 2: set_pwd rxc/rxc_password db_object_name db_object_password
Note:
Scenario 2 does not protect the password.
Where db_object_name is the name of the schema or role from changing-passwords.html#GUID-A9D072D9-E4CB-45EA-AB96-314B50FB9C4B__BABFAFFJ.
Example 1:
$ set_pwd rxc rxc_pd
Enter RXC Password
Enter RXC_PD Password
Password successfully encrypted and stored.
Example 2:
set_pwd rxc/your_rxc_password rxc_pd your_rxc_pd_password
Password successfully encrypted and stored.
Note:
The Oracle Database DEFAULT profile, which applies to all users by default, including these internal roles and schemas, enforces password requirements including an expiration period. You must proactively change their passwords before they expire, or parts of the system will stop working.
In rare cases you may want to change the password of the Wallet itself. See Oracle Fusion Middleware Administrator's Guide for more information. You must then change the passwords for the accounts.
Table 1-4 Password-Protected Database Objects
Name | Type | Description |
---|---|---|
RXC_MAA |
Schema |
Required for Data Extract. |
RXC_PD |
Schema |
Required for Procedure generation. |
Parent topic: Changing Passwords
Synchronizing Passwords in the WebLogic Admin Server
The passwords for the application middle tier account, RDC_MIDTIER_PROXY, must be changed to the same value in the following places:
- in Oracle Clinical or TMS using set_pwd (see Changing the Password for a Schema or Role Using the SET_PWD Utility)
- in the WebLogic Admin Server Connection Pool Manager
Parent topic: Changing Passwords
Auditing Passwords
Oracle recommends that you turn on the auditing system for roles. For information on the AUDIT command, see the Oracle SQL Reference manual.
To track failed attempts to create, alter, drop, or set a role, issue the following statement:
audit role by access whenever not successful
Parent topic: Changing Passwords
Changing the Password for the OCPSUB
The passwords for OCPSUB is stored in Oracle Wallets on the database. You cannot use the set_pwd utility to change these passwords. Instead, do the following:
-
Log on as opapps.
-
Set environment variables for the database name and code environment; see Setting Environment Variables on the Command Line
-
Open an MS-DOS window.
-
Set the server environment; see Setting Environment Variables on the Command Line
-
Enter the following command, where wallet_location is the full path to the wallet:
mkstore -wrl wallet_location - modifyCredential tns_names_entry OCPSUB_or_RXC_DISC_REP new_password
-
The system prompts you for the wallet password.
Parent topic: Changing Passwords