ORA-28163: GRANT already specified

Cause : The GRANT clause was specified twice.

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

Use only one GRANT clause.

update : 27-06-2017

ORA-28163 - GRANT already specified
ORA-28163 - GRANT already specified

  • ora-32336 : cannot use USING NO INDEX to create materialized view "string"."string"
  • ora-36913 : (XSAGDNGL49) In AGGMAP workspace object, LOAD_STATUS object workspace object must be an undimensioned VALUESET over the relation dimension.
  • ora-00296 : maximum number of files (string) exceeded for RECOVER DATAFILE LIST
  • ora-12202 : TNS:internal navigation error
  • ora-06268 : NETNTT: cannot read /etc/oratab
  • ora-15079 : ASM file is closed
  • ora-19861 : additional backup pieces cannot be validated in this conversation
  • ora-29655 : USING clause is incompatible with its supertype
  • ora-29397 : cannot grant/revoke switch privilege for string
  • ora-16036 : invalid MANAGED recovery CANCEL option
  • ora-31025 : Invalid document element
  • ora-01226 : file header of log member is inconsistent with other members
  • ora-14101 : partition extended table name cannot refer to a synonym
  • ora-04042 : procedure, function, package, or package body does not exist
  • ora-13062 : topology IDs do not match in the feature table and the topology
  • ora-13205 : internal error while parsing spatial parameters
  • ora-28340 : a different encryption algorithm has been chosen for the table
  • ora-27089 : unable to release advisory lock
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-07393 : unable to delete text file
  • ora-19625 : error identifying file string
  • ora-26514 : object 'string.string' not found
  • ora-19728 : data object number conflict between table string and partition string in table string
  • ora-31621 : error creating master process
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-31608 : specified object of type string not found
  • ora-31465 : cannot obtain a lock on the subscription
  • ora-09910 : Unable to find ORACLE password file entry for user.
  • ora-13182 : failed to read element string.string.string
  • ora-27127 : unable to unlock shared memory segment
  • 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.