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 : 21-08-2017
ORA-24090

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

  • ora-10932 : trace name context forever
  • ora-12483 : label not in OS system accreditation range
  • ora-23312 : not the masterdef according to string
  • ora-24201 : duplicate publisher, publisher already added to the queue
  • ora-36274 : (XSCGMDLAGG05) The operator used in this equation needs a weight variable.
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-28512 : cannot get data dictionary translations from string
  • ora-00259 : log string of open instance string (thread string) is the current log, cannot archive
  • ora-01622 : thread number must be specified - default not specific
  • ora-31114 : XDB configuration has been deleted or is corrupted
  • ora-17500 : ODM err:string
  • ora-22603 : cannot add an attribute to the already generated TDS handle
  • ora-21780 : Maximum number of object durations exceeded.
  • ora-32505 : too many watchpoints
  • ora-39111 : Dependent object type string skipped, base object type string already exists
  • ora-29887 : cannot support row movement if domain index defined on table
  • ora-36664 : (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.
  • ora-27147 : post/wait reset failed
  • ora-00487 : CTWR process terminated with error
  • ora-24313 : user already authenticated
  • ora-08234 : smsget: cannot get instance listener address
  • ora-14174 : only a may follow COALESCE PARTITION|SUBPARTITION
  • ora-24073 : cannot specify RETENTION_TIME on exception queue string.string
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-27036 : translation error, unable to expand file name
  • ora-30368 : ATTRIBUTE cannot determine column in a different relation
  • ora-31164 : cannot load object-relational XML attribute using direct path
  • ora-38794 : Flashback target time not in current incarnation
  • ora-02483 : Syntax error in process specification (string)
  • ora-28292 : No Domain Policy registered for Kerberos based authentication
  • 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.