ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

Cause : More than one of PROTOCOL, ADDRESS or DESCRIPTION was specified.

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

Use only one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.

update : 24-04-2017

ORA-00118 - Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
ORA-00118 - Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified

  • ora-39954 : DEFERRED is required for this system parameter
  • ora-13611 : The command string is not a valid advisor command.
  • ora-13044 : the specified tile size is smaller than the tolerance
  • ora-39315 : call to DBMS_SCHEMA_COPY.SWAP is not legal
  • ora-29351 : can not transport system, sysaux, or temporary tablespace 'string'
  • ora-28280 : Multiple entries for ORACLE database password exist.
  • ora-32822 : subscriber string is marked for removal
  • ora-03129 : the next piece to be inserted is required
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-37152 : MDX query error: (string)
  • ora-40217 : priors table mismatched with training data
  • ora-29297 : The compressed representation is too big
  • ora-12484 : invalid OS label
  • ora-17620 : failed to register the network adapter with Oracle Disk Manager library: string
  • ora-01070 : Using an old version of Oracle for the server
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-01936 : cannot specify owner when creating users or roles
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-38701 : Flashback database log string seq string thread string: "string"
  • ora-06925 : CMX: disconnect during connect request
  • ora-06402 : NETCMN: error receiving break message
  • ora-12405 : invalid label list
  • ora-19512 : file search failed
  • ora-32317 : cannot run a job from a job
  • ora-13021 : element not continuous
  • ora-31625 : Schema string is needed to import this object, but is unaccessible
  • ora-30387 : invalid rewrite mode for REWRITE_EQUIVALENCE API
  • ora-25211 : invalid DELAY specified when using sequence deviation
  • ora-07345 : The datafile name must not contain the string '..'.
  • ora-39050 : parameter string is incompatible with parameter 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.