{"id":14644,"date":"2020-04-24T08:44:27","date_gmt":"2020-04-24T08:44:27","guid":{"rendered":"https:\/\/ittutorial.org\/?p=14644"},"modified":"2020-09-24T08:47:41","modified_gmt":"2020-09-24T08:47:41","slug":"ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper\/","title":{"rendered":"ORA-28009: connection as SYS should be as SYSDBA or SYSOPER"},"content":{"rendered":"<p>Hi,<\/p>\n<p>Sometimes You can get &#8220;<span class=\"msg\">ORA-28009: connection as SYS should be as SYSDBA or SYSOPER<\/span><span class=\"msg\">\u00a0<\/span>&#8221; error.<\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #ff0000;\">ORA-28009<\/span><\/h1>\n<p>Details of error are as follows.<\/p>\n<pre><span class=\"msg\">ORA-28009: connection as SYS should be as SYSDBA or SYSOPER<\/span>\r\n\r\n<span class=\"msgexplankw\">Cause:<\/span>\u00a0connect SYS\/&lt;password&gt; is no longer a valid syntax\r\n\r\n<span class=\"msgactionkw\">Action:<\/span> Try connect SYS\/&lt;password&gt; as SYSDBA or connect SYS\/&lt;password&gt; as SYSOPER\r\n\r\nSQL&gt; conn sys\/welcome1\r\nERROR:\r\nORA-28009: connection as SYS should be as SYSDBA or SYSOPER\r\nWarning: You are no longer connected to ORACLE.<\/pre>\n<p>&nbsp;<\/p>\n\n<p>&nbsp;<\/p>\n<h2><span style=\"color: #ff0000;\">connection as SYS should be as SYSDBA or SYSOPER<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>To solve this error, your connection as SYS should be as SYSDBA or SYSOPER as follows.<\/p>\n<pre>SQL&gt; conn \/ as sysdba\r\nConnected.\r\nSQL&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #ff0000;\">O7_DICTIONARY_ACCESSIBILITY Parameter<\/span><\/h3>\n<p>Or You should change O7_DICTIONARY_ACCESSIBILITY parameter from False to True as follows.<\/p>\n<pre>SQL&gt; SHOW PARAMETER O7_DICTIONARY_ACCESSIBILITY\r\nNAME                            TYPE         VALUE\r\n\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014                   \u2014\u2014\u2014\u2013      \u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\r\nO7_DICTIONARY_ACCESSIBILITY     boolean      FALSE\r\n\r\n\r\nSQL&gt; ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY=TRUE scope=spfile sid='*';\r\nSystem altered.<\/pre>\n<p>&nbsp;<\/p>\n<p>Restart database as follows.<\/p>\n<p>&nbsp;<\/p>\n<pre>SQL&gt; shutdown immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\nSQL&gt; startup\r\nORACLE instance started.\r\nTotal System Global Area 3676221530 bytes\r\nFixed Size 5069288 bytes\r\nVariable Size 109051944 bytes\r\nDatabase Buffers 30361648 bytes\r\nRedo Buffers 3368280 bytes\r\nDatabase mounted.\r\nDatabase opened.<\/pre>\n<p>&nbsp;<\/p>\n<p>Once restart is completed, you can connect as sys with only password as follows.<\/p>\n<pre>SQL&gt; conn sys\/welcome1\r\nConnected.<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h4><span style=\"color: #ff0000;\">Do you want to learn Oracle Database for Beginners, then read the following articles.<\/span><\/h4>\n<blockquote class=\"wp-embedded-content\" data-secret=\"4wt7W99SZd\"><p><a href=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/\">Oracle Tutorial | Oracle Database Tutorials for Beginners  ( Junior Oracle DBA )<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Oracle Tutorial | Oracle Database Tutorials for Beginners  ( Junior Oracle DBA )&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/oracle-tutorial-oracle-database-tutorials-for-beginners-junior-oracle-dba\/embed\/#?secret=oXEWJkpUpJ#?secret=4wt7W99SZd\" data-secret=\"4wt7W99SZd\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, Sometimes You can get &#8220;ORA-28009: connection as SYS should be as SYSDBA or SYSOPER\u00a0&#8221; error.<\/p>\n","protected":false},"author":1,"featured_media":6095,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2111],"tags":[13513,9165,13514,9157,9159,9162,13517,13516,5760,9164,9163,9158,9156,2668,9161,13515,9160],"class_list":["post-14644","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-ora-errors","tag-ava-sql-sqlexception-ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper","tag-connection-as-sys-should-be-as-sysdba-or-sysoper","tag-connection-as-sys-should-be-as-sysdba-or-sysoper-sql-developer","tag-expdp-ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper","tag-java-sql-sqlexception-ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper","tag-no-more-connections-from-users-other-than-sys-and-system-allowed","tag-o7_dictionary_accessibility","tag-o7_dictionary_accessibility-parameter","tag-ora-01017-invalid-username-password-logon-denied","tag-ora-28009","tag-ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper","tag-ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper-c","tag-ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper-in-java","tag-ora-65096-invalid-common-user-or-role-name","tag-sqlplus-as-sysdba","tag-sqlplus-connection-as-sys-should-be-as-sysdba","tag-status-failure-failed-ora-28009-connection-as-sys-should-be-as-sysdba-or-sysoper"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/03\/ora-error-e1494274386931.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=14644"}],"version-history":[{"count":3,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14644\/revisions"}],"predecessor-version":[{"id":19360,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14644\/revisions\/19360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/6095"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=14644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=14644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=14644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}