ORA-12718: operation requires connection as SYS

Cause : Tihsc ommadn acno nyl eb urnw hne ocnencitn ga sSSY

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Cnonceta sS Y St ornu hti scmomnad

update : 30-05-2017
ORA-12718

ORA-12718 - operation requires connection as SYS
ORA-12718 - operation requires connection as SYS

  • ora-32631 : illegal use of objects in MODEL
  • ora-31003 : Parent string already contains child entry string
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-10943 : trace name context forever
  • ora-16001 : database already open for read-only access by another instance
  • ora-31518 : change column string already exists in CDC change table string.string
  • ora-07235 : slemcw: fwrite error.
  • ora-24346 : cannot execute without binding variables
  • ora-30971 : illegal operation on the Path Table
  • ora-22976 : incorrect number of arguments to MAKE_REF
  • ora-16112 : log mining and apply stopping
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-24365 : error in character conversion
  • ora-12231 : TNS:No connection possible to destination
  • ora-36380 : (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.
  • ora-27100 : shared memory realm already exists
  • ora-16574 : switchover disallowed when required databases are offline
  • ora-32825 : Messaging Gateway agent has not been started
  • ora-27006 : sbtremove returned error
  • ora-09367 : Windows 3.1 Two-Task driver unable to deallocate shared memory
  • ora-01157 : cannot identify/lock data file string - see DBWR trace file
  • ora-13153 : invalid high water mark specified
  • ora-16603 : Data Guard broker detected a mismatch in configuration ID
  • ora-14303 : partitions or subpartitions are not in the right order
  • ora-06605 : LU6.2 Driver: Unexpected line turnaround
  • ora-23371 : column string unknown in table string
  • ora-06955 : Number of database servers exceed limit
  • ora-26696 : no streams data dictionary for object with number string and version number string from source database string
  • ora-36668 : (XSDPART06) string is not a legal RANGE partition.
  • ora-01862 : the numeric value does not match the length of the format item
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.