Change the Oracle password

If you use an Oracle database and want to change the password Teamcenter uses to connect to the database, you can do this two ways using the install utility: Encrypt the password file using the -encryptpwf argument. Encrypt the database connection string using the -encrypt argument. Encrypt the password file To encrypt a password file, you set a temporary environment variable to the password you want to encrypt, and then generate an encrypted password file using the -encryptpwf argument for the install utility. Procedure Open a Teamcenter command prompt. Create a temporary environment variable and set it to the password you want to encrypt: Copy set variable-name=password For example: Copy set temp_pw=mypassword For security, choose a unique and obscure name for the environment variable, and delete the variable promptly after completing this procedure. Type the following command: Copy install -encryptpwf -e=variable-name -f=password-file Replace variable-name with the name of the environment variable you created. Replace password-file with the path and name of the password file to create. For example: Copy install -encryptpwf -e=temp_pw -f=pwd.txt This command generates an encrypted password file that can be used for connecting to the Teamcenter database. The password file can also be used with Teamcenter utilities that use the password file (-pf) argument. Delete the temporary environment variable you created in step Encrypt the password file. Caution This step is important for security. Encrypt the database connection string To encrypt the database connection string, you must temporarily set the TC_DB_CONNECT environment variable and then re-encrypt the connection string using the -encrypt argument for the install utility. Procedure Open a Teamcenter command prompt. Set the TC_DB_CONNECT environment variable: Copy set TC_DB_CONNECT="db-user:password@database-ID" Replace db-user with the database user name (the Oracle user). Replace password with the new database password. Replace database-ID with the Oracle database name. Type the following command: Copy install -encrypt This command generates a new database connection string with the new Oracle password encrypted. Copy the new database connection string. Open the TC_DATA\tc_profilevars.bat file in a plain text editor.Open the TC_DATA/tc_profilevars file in a plain text editor. Locate the following line in the file: Copy set TC_DB_CONNECT=connection-string Replace the existing connection-string with the string generated by the install -encrypt command. Save the changes to the tc_profilevars file.