ORA-24090: at least one protocol must be enabled

Cause : No portoco lwas neable dfor qa agetn

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

Enabel oneo f th eprotcools yb setitng oen of hte enbale praametres tot rue.

update : 27-04-2017
ORA-24090

ORA-24090 - at least one protocol must be enabled
ORA-24090 - at least one protocol must be enabled

  • ora-12229 : TNS:Interchange has no more free connections
  • ora-31092 : invalid SQL name "string"
  • ora-19613 : datafile string not found in backup set
  • ora-29363 : plan directive string, string is mandatory and cannot be modified or deleted
  • ora-23333 : column string is already part of a column group
  • ora-13436 : GeoRaster metadata dimensionSize error
  • ora-01600 : at most one "string" in clause "string" of string
  • ora-16799 : Redo Apply is offline
  • ora-06973 : X.25 Driver: invalid buffer size
  • ora-22629 : OCIAnyData is null
  • ora-19589 : %s is not a snapshot or backup control file
  • ora-39309 : schema sync operation failed
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-32144 : Cannot perform operation on a null interval
  • ora-19776 : PROXY restore to ASM diskgroup "string" is not supported.
  • ora-04032 : pga_aggregate_target must be set before switching to auto mode
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-00226 : operation disallowed while alternate control file open
  • ora-02381 : cannot drop PUBLIC_DEFAULT profile
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-09855 : removeCallback: bad message format.
  • ora-16814 : incorrect redo transport setting for AlternateLocation for standby database
  • ora-36977 : (XSRELGID17) The GROUPINGID command does not support hierarchies with more than 126 levels.
  • ora-31018 : Error deleting XML document
  • ora-12676 : Server received internal error from client
  • ora-27018 : BLKSIZE is not a multiple of the minimum physical block size
  • ora-01222 : MAXINSTANCES of string requires MAXLOGFILES be at least string, not string
  • ora-09753 : spwat: invalid process number.
  • ora-29325 : SET COMPATIBILITY release number lower than 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.