Hi,
Sometimes it is required to recover forgotten password of Oracle Content Server repository.
The purpose of this post is to identify where you are required to do changes if you are going to reset content repository database account password.
Usually the database schema owner of Oracle content server is <Your-Prefix>_OCS if your prefix during installation was DEV then username in database will be DEV_OCS.
Your DBA changed the password using following command
alter user DEV_OCS identified by newPassword;
Change In Weblogic Console:
1. Open Weblogic Admin console by following URL
http://mysername:myport/console
e.g http://myserver:7001/console
2. Go to Services > JDBC > Data Sources > CSDS > Configuration > Connection Pool
3. Enter new password and Press Save as shown
4. Weblogic will ask you to restart the data source, follow as shown in the slide
Change Password in Content Server Configuration:
To change password in Linux environment you need X-Windows / VNC or Login to Box using Tools like Reflections
1. Go to your content-server domain directory as follows
/u01/Oracle/Middleware/user_projects/domains/myDomain/ucm/cs/bin/
2. Run SystemProperties file
$ ./SystemProperties
3. A properties window will appear. Go to Database tab and change the password and hit OK
The changes will propogate out to the config.cfg file restart content server if required.
Hope this will help,
Zeeshan Baig
Sometimes it is required to recover forgotten password of Oracle Content Server repository.
The purpose of this post is to identify where you are required to do changes if you are going to reset content repository database account password.
Usually the database schema owner of Oracle content server is <Your-Prefix>_OCS if your prefix during installation was DEV then username in database will be DEV_OCS.
Your DBA changed the password using following command
alter user DEV_OCS identified by newPassword;
Change In Weblogic Console:
1. Open Weblogic Admin console by following URL
http://mysername:myport/console
e.g http://myserver:7001/console
2. Go to Services > JDBC > Data Sources > CSDS > Configuration > Connection Pool
3. Enter new password and Press Save as shown
4. Weblogic will ask you to restart the data source, follow as shown in the slide
Change Password in Content Server Configuration:
To change password in Linux environment you need X-Windows / VNC or Login to Box using Tools like Reflections
1. Go to your content-server domain directory as follows
/u01/Oracle/Middleware/user_projects/domains/myDomain/ucm/cs/bin/
2. Run SystemProperties file
$ ./SystemProperties
3. A properties window will appear. Go to Database tab and change the password and hit OK
The changes will propogate out to the config.cfg file restart content server if required.
Hope this will help,
Zeeshan Baig
Blog: http://baigzeeshan.com
LinkedIn: http://www.linkedin.com/in/baigzeeshan
Twitter: http://twitter.com/baigsorcl
YouTube: http://www.youtube.com/user/baigsorcl
Twitter: http://twitter.com/baigsorcl
YouTube: http://www.youtube.com/user/baigsorcl
