{"id":483,"date":"2021-10-26T11:16:42","date_gmt":"2021-10-26T09:16:42","guid":{"rendered":"http:\/\/blog.xoupix.fr\/?p=483"},"modified":"2022-01-27T09:58:12","modified_gmt":"2022-01-27T08:58:12","slug":"changing-documentum-oracle-database","status":"publish","type":"post","link":"https:\/\/blog.xoupix.fr\/index.php\/2021\/10\/26\/changing-documentum-oracle-database\/","title":{"rendered":"Changing Documentum Oracle database"},"content":{"rendered":"\n<p>Here is a quick tip on how to unplug Documentum from an old database and plug it to a new Oracle database.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\" id=\"changing-the-tnsnames-ora-configuration-file\"> Changing the tnsnames.ora configuration file<\/h2>\n\n\n\n<p>First of all, if your new database is located on another server, you will have to modify your tnsnames.ora file accordingly. You will have to change :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>the global name, used by Documentum to identify the correct connection string and the listener ;<\/li><li>the host name, using server or dns name ;<\/li><li>the database connection port ;<\/li><li>the service name.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"generating-the-dbpasswd-txt-file\">Generating the dbpasswd.txt file<\/h2>\n\n\n\n<p>You will have to generate the dbpasswd.txt file to encrypt the database user password. To do it :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>adding your password as plain text in the dbpasswd.txt file (located in &#8220;${DOCUMENTUM}\/dba\/config\/&lt;docbase name&gt;\/&#8221;) ;<\/li><li>go into your ${DM_HOME}\/bin directory ;<\/li><li>using the .\/dm_encrypt_password, encrypt your password in the dbpasswd.txt file (i.e. &#8220;.\/dm_encrypt_password -keyname &lt;Documentum key file, like CSaek&gt; -docbase &lt;docbase name&gt; -rdbms -encrypt&#8221;, the script will ask you for password).<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"changing-the-server-ini-properties-file\">Changing the server.ini properties file<\/h2>\n\n\n\n<p>Finally, you will have to change the db_xxx in your server.ini to indicate which database connection Documentum have to use to connect to.<\/p>\n\n\n\n<p>When it&#8217;s done, just start your docbase. It must start without error.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is a quick tip on how to unplug Documentum from an old database and plug it to a new Oracle database.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-483","post","type-post","status-publish","format-standard","hentry","category-documentum"],"_links":{"self":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts\/483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/comments?post=483"}],"version-history":[{"count":2,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts\/483\/revisions"}],"predecessor-version":[{"id":498,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/posts\/483\/revisions\/498"}],"wp:attachment":[{"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/media?parent=483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/categories?post=483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.xoupix.fr\/index.php\/wp-json\/wp\/v2\/tags?post=483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}