title: How to change timezone in Oracle Database specific to one SID, system having many DB SID Configured
body: <p>I have to change timezone for the particular Database(SID). Where I have DB Server is having multiple Database (SID) Configured and installed.
  When i have connected Particular SID and run below Query :</p>
  
  <pre><code>alter database set time_zone='-05:00'
  </code></pre>
  
  <p>I got below error: </p>
  
  <pre><code>ERROR at line 1:
  ORA-02231: missing or invalid option to ALTER DATABASE
  </code></pre>
  
  <p>But when i am running 
  <code>alter database set time_zone = 'EST';</code> 
  query also it did not give error but </p>
  
  <p><strong>Note</strong>: I have multiple Database configured in same DB Server I need to change the timezone for particularly to one Database (SID). I cant change in system (OS) level and DB Server level globally.</p>
  
  <p>i am not able to change time zone any one can help.</p>