Could I ignore the SID clause in command ‘alter system’?

  • 25 views

When we change the parameters in the RAC systems, I always recommend to specify the SID clause clearly, which means you know which or all instances will be modified.

If you ignore it, the result will be dependent on if the instance is started by spfile or not:

If you do not specify this clause, then:
    If the instance was started up with a pfile (traditional plain-text initialization parameter file), then Oracle Database assumes the SID of the current instance.
    If the instance was started up with an spfile (server parameter file), then Oracle Database assumes SID = '*'.

As a DBA or SA, when we will run any command, we should try to know the result clearly. This habit will avoid plenty of unexpected results.

  • by Published on 26/08/202123:52:23
  • Repost please keep this link: https://blogs.dbcloudsvc.com/oracle/could-i-ignore-the-sid-clause-in-command-alter-system/
匿名

Comment

Anonymous Write

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: