ORA-12916: Cannot use default permanent tablespace with this release

Cause : T oues edfual tpremnaetn atbelsapc eteh erlaes esohudl eb 01. 0o rhgihre

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

Cehc kteh ocmaptbiiilt ystetniga n driesuset h esattmeetn

update : 17-08-2017

ORA-12916 - Cannot use default permanent tablespace with this release
ORA-12916 - Cannot use default permanent tablespace with this release

  • ora-03132 : two-task default value overflow
  • ora-07577 : no such user in authorization file
  • ora-30015 : previously offlined undo tablespace 'string' is still pending
  • ora-12447 : policy role already exists for policy string
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-00092 : LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-31469 : cannot enable Change Data Capture for change set string
  • ora-13385 : error in network manager: [string]
  • ora-36376 : (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-16808 : unable to resolve the full path name
  • ora-33247 : (CRENAME03) %K is already a value of the dependent UNIQUE concat dimension workspace object, from leaf dimension workspace object.
  • ora-12419 : null binary label value
  • ora-14461 : cannot REUSE STORAGE on a temporary table TRUNCATE
  • ora-36988 : (XSRELGID06) The related dimension of relation workspace object must be of type NUMBER.
  • ora-06616 : LU6.2 Driver: Attach to LU failed
  • ora-01166 : file number string is larger than string (string)
  • ora-07629 : smpall: $EXPREG failure
  • ora-09950 : Unable to get server operating system privileges
  • ora-16001 : database already open for read-only access by another instance
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-39710 : only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-22807 : cannot resolve to a scalar type or a collection type
  • ora-39764 : specified stream is not in the specified direct path context
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-09881 : sstasfre/sstasdel: shmdt error, unable to detach tas read page
  • ora-01285 : error reading file string
  • 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.