{"id":969,"date":"2025-02-03T12:56:23","date_gmt":"2025-02-03T11:56:23","guid":{"rendered":"https:\/\/anjo.pt\/keyword-oracle\/?p=969"},"modified":"2025-02-03T12:56:23","modified_gmt":"2025-02-03T11:56:23","slug":"how-to-change-goldengate-adminclient-default-editor-permanently","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2025\/02\/03\/how-to-change-goldengate-adminclient-default-editor-permanently\/","title":{"rendered":"How to change Goldengate Adminclient default editor permanently"},"content":{"rendered":"\n<p>Goldengate Microservices architecture replaced the &#8220;ggsci&#8221; tool with &#8220;adminclient&#8221;. This new client has few limitations and does not work well with &#8220;rlwrap&#8221; &#8211; my favorite tool to have history between sessions.<\/p>\n\n\n\n<p>The Adminclient provides some options you can easily change after starting the tool:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ .\/adminclient\n...\nOGG (not connected) 1&gt; show\nCurrent directory: \/home\/oracle\nCOLOR            : OFF\nDEBUG            : OFF\nEDITOR           : vi\nPAGER            : more\nVERBOSE          : OFF\n\nOGG (not connected) 2&gt; set color ON\nOGG (not connected) 3&gt; set pager less\n\nOGG (not connected) 4&gt; show\n\nCurrent directory: \/home\/oracle\nCOLOR            : ON\nDEBUG            : OFF\nEDITOR           : vi\nPAGER            : less\nVERBOSE          : OFF\n<\/pre><\/div>\n\n\n<p>However to keep the settings across sessions it is not very straight forward. The way to do it is to set variables:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n$ export ADMINCLIENT_COLOR=ON  # ON, OFF in uppercase!\n<\/pre><\/div>\n\n\n<p>And ADMINCLIENT_DEBUG and ADMINCLIENT_VERBOSE for DEBUG and VERBOSE respectively<\/p>\n\n\n\n<p>For the editor and pager, the variables are simply:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nexport EDITOR=nano\nexport PAGER=less\n<\/pre><\/div>\n\n\n<p>Attention that the variable EDITOR is used also by other clients, like sqlplus &#8220;edit&#8221; command. <\/p>\n\n\n\n<p>So the way I do it, is to set everything within an alias:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nalias gg=&quot;cd $OGG_HOME\/bin; EDITOR=nano PAGER=less ADMINCLIENT_COLOR=ON $RLWRAP .\/adminclient ; cd -&quot;\n<\/pre><\/div>\n\n\n<p>And inside .bash_profile or something that sets the environment:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nRLWRAP=&quot;$(command -v rlwrap)&quot; &amp;amp;&amp;amp; RLWRAP=&quot;${RLWRAP} -c&quot;\n\nexport OGG_HOME=&quot;\/u00\/app\/oracle\/product\/ogg\/21.15&quot;\nalias gg=&quot;cd $OGG_HOME\/bin; EDITOR=nano PAGER=less ADMINCLIENT_COLOR=ON $RLWRAP .\/adminclient ; cd -&quot; \n<\/pre><\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Goldengate Microservices architecture replaced the &#8220;ggsci&#8221; tool with &#8220;adminclient&#8221;. This new client has few limitations and does not work well with &#8220;rlwrap&#8221; &#8211; my favorite tool to have history between sessions. The Adminclient provides some options you can easily change after starting the tool: However to keep the settings across sessions it is not very [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":{"0":"post-969","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-goldengate","7":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=969"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/969\/revisions"}],"predecessor-version":[{"id":970,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/969\/revisions\/970"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}