{"id":3762,"date":"2018-07-31T09:09:31","date_gmt":"2018-07-31T12:09:31","guid":{"rendered":"https:\/\/www.dbarj.com.br\/?p=3762"},"modified":"2019-05-15T13:55:29","modified_gmt":"2019-05-15T16:55:29","slug":"ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/","title":{"rendered":"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created"},"content":{"rendered":"<p>Those days when I was trying to apply the <strong>Apr 2018 Release Update Revision 12.2.0.1.180717<\/strong>, I got the error below during datapatch roolback execution of the previous patch:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Patch 27013506 rollback (pdb PDB01): WITH ERRORS\r\nlogfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/27013506\/21779816\/27013506_rollback_ORCL_PDB01_2018Jul31_00_12_34.log (errors)\r\nError at line 32785: ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created<\/pre>\n<p>And in logfile there was this entry:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">3410     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','ustedes');\r\n3411     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','varias');\r\n3412     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','varios');\r\n3413     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','vosotras');\r\n3414     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','vosotros');\r\n3415     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','vuestra');\r\n3416     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','vuestras');\r\n3417     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','vuestro');\r\n3418     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','vuestros');\r\n3419     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','y');\r\n3420     sys.default_add_stopword('CTXSYS.JSONREST_MEX_SP_STOPLIST','yo');\r\n3421   end;\r\n3422  end;\r\n3423  \/\r\ndeclare\r\n*\r\nERROR at line 1:\r\nORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created\r\nORA-06512: at \"SYS.DEFAULT_CREATE_STOPLIST\", line 27\r\nORA-06512: at line 35<\/pre>\n<p>After doing some investigation I&#8217;ve found the\u00a0 &#8220;<span style=\"color: #ff0000;\">Oracle Support Document 2358409.1 (Oracle Database \/ Grid Infrastructure \/ OJVM Release Update<\/span>&#8221; saying this is an expected issue:<\/p>\n<p><em><span style=\"color: #0000ff;\"><strong>1.2 <\/strong><strong>ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created<\/strong><\/span><\/em><\/p>\n<p><em><span style=\"color: #0000ff;\"><strong>Problem:<\/strong> In the (unlikely) scenario that you are rolling back one of these Apr 2018 12.2.0.1 patches to a previous quarterly 12.2.0.1 patch, and then rolling back that previous quarterly 12.2.0.1 patch, the second rollback can fail with the error:<\/span><\/em><\/p>\n<p><strong><em><span style=\"color: #0000ff;\">ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created <\/span><\/em><\/strong><em><span style=\"color: #0000ff;\">reported by datapatch. This is due to the script ctx\/admin\/bug24899895_rollback.sql being run twice during this operation.<\/span><\/em><\/p>\n<p><em><span style=\"color: #0000ff;\"><strong>Workaround:<\/strong> If this is the only error reported by datapatch, the error can be ignored, and the status column of the sql registry can be manually updated from WITH ERRORS to SUCCESS to reflect that.<\/span><\/em><\/p>\n<p><em><span style=\"color: #0000ff;\">for example:<\/span><\/em><br \/>\n<em><span style=\"color: #0000ff;\">SQL&gt; UPDATE dba_registry_sqlpatch SET status = &#8216;SUCCESS&#8217; WHERE status = &#8216;WITH ERRORS&#8217;;<\/span><\/em><br \/>\n<em><span style=\"color: #0000ff;\">SQL&gt; COMMIT;<\/span><\/em><\/p>\n<p>Those rollbacks are happening automatically by datapatch to apply the latest RUR. After applying the workaround, I&#8217;ve just re-executed &#8220;datapatch -verbose&#8221; to ensure nothing was missing. It worked like a charm.<\/p>\n<b>Have you enjoyed? Please leave a comment or give a \ud83d\udc4d!<\/b>\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-3762 jlk' href='javascript:void(0)' data-task='like' data-post_id='3762' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-3762 lc'>+1<\/span><\/a><\/div><\/div> <div class='status-3762 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Those days when I was trying to apply the Apr 2018 Release Update Revision 12.2.0.1.180717, I got the error below during datapatch roolback execution of the previous patch: Patch 27013506 rollback (pdb PDB01): WITH ERRORS logfile: \/u01\/app\/oracle\/cfgtoollogs\/sqlpatch\/27013506\/21779816\/27013506_rollback_ORCL_PDB01_2018Jul31_00_12_34.log (errors) Error at line 32785: ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created And in logfile there was this &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-3762","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"How to solve the error &quot;ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created&quot;.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created\",\"datePublished\":\"2018-07-31T12:09:31+00:00\",\"dateModified\":\"2019-05-15T16:55:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/\"},\"wordCount\":232,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/\",\"name\":\"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2018-07-31T12:09:31+00:00\",\"dateModified\":\"2019-05-15T16:55:29+00:00\",\"description\":\"How to solve the error \\\"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created\\\".\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2018\\\/07\\\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"How to solve the error \"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created\".","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created","datePublished":"2018-07-31T12:09:31+00:00","dateModified":"2019-05-15T16:55:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/"},"wordCount":232,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/","url":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/","name":"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2018-07-31T12:09:31+00:00","dateModified":"2019-05-15T16:55:29+00:00","description":"How to solve the error \"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created\".","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2018\/07\/ora-20000-oracle-text-error-ctxsys-jsonrest_generic_stoplist-not-created\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/3762","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=3762"}],"version-history":[{"count":1,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/3762\/revisions"}],"predecessor-version":[{"id":4098,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/3762\/revisions\/4098"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=3762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=3762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=3762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}