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-06-2017
ORA-24090

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

  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-36679 : (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.
  • ora-36157 : (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
  • ora-07447 : ssarena: usinit failed.
  • ora-27049 : unable to seek to and read the last block
  • ora-24769 : cannot forget an active transaction
  • ora-26013 : List allocated may not be big enough
  • ora-06106 : NETTCP: socket creation failure
  • ora-13616 : The current user string has not been granted the ADVISOR privilege.
  • ora-02453 : duplicate HASH IS specification
  • ora-28363 : buffer provided not large enough for output
  • ora-37137 : (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-29800 : invalid name for operator
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-19812 : cannot use string without DB_RECOVERY_FILE_DEST
  • ora-28333 : column is not encrypted
  • ora-13778 : no new name or owner specified for "SQL Tuning Set"
  • ora-13619 : The procedure argument string is greater than the maximum allowable length of string characters.
  • ora-27050 : function called with invalid FIB/IOV structure
  • ora-15030 : diskgroup name "string" is in use by another diskgroup
  • ora-24014 : invalid value string, RETENTION_TIME should be FOREVER or non-negative
  • ora-00072 : process "string" is not active
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-02231 : missing or invalid option to ALTER DATABASE
  • ora-09761 : pw_destroyPorts: server call pws_stop_instance failed.
  • ora-25122 : Only LOCAL bitmap indexes are permitted on partitioned tables
  • ora-38440 : attribute set string does not exist
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • 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.