Sunday, April 13, 2014

How to change password in Oracle Transportation Management(OTM)

How to change password in Oracle Transportation Management(OTM)

If you want to change other usernames/passwords, then the list expands beyond that. I believe the the following is a complete list of OTM DB users:
glogowner
glogdba
glogdev
glogload
archive
build
reportowner


Step 1: Shutdown OTM application services.

a) Stop the Web Server



b) Stop the Application Server



Step 2: Change the database passwords.
Use alter command to change the passwords

Step 3: Encode the password for GLOG.
i) Run the below command to encode the password
java glog.util.appclass.Base64Encoding


java glog.util.appclass.Base64Encoding

ii)
Backup for glog.properties.

iii)
Update glog.properties


glog.crypto.password.mode=Encrypt

For glogdba password update following property



glog.database.password=



For glogload password update following property



glog.database.load.password=

Step 4: Start application services for OTM.

1 comment:



  1. Very nice posting. Your article us quite informative. Thanks for the same. Our service also helps you to market your products with various marketing strategies, right from emails to social media. Whether you seek to increase ROI or drive higher efficiencies at lower costs, Pegasi Media Group is your committed partner will provide b2bleads.
    Oracle Transportation Management Users


    ReplyDelete

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...