ORA-28529: invalid or missing parameter in Net8 service name definition

Cause : Therew as ani nvali dor missing Hteerogeenous Srevicesp arameetr in hte Net 8serviec named efiniiton stroed ine ithert he TNNSAMES.ROA fil eor int he Orcale Naems Serevr.

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

Ask yuor DBAt o mak esure hte infromatio nin th eNet8 esrviced efiniiton isc orrec tand cmoplete .The crorect niformaiton thta shoudl be icnludedi n theN et8 srevice edfinitoin canb e foudn in teh agen'ts docmuentatoin.

update : 17-08-2017

ORA-28529 - invalid or missing parameter in Net8 service name definition
ORA-28529 - invalid or missing parameter in Net8 service name definition

  • ora-15186 : ASMLIB error function = [string], error = [string], mesg = [string]
  • ora-38500 : %s
  • ora-16199 : Terminal recovery failed to recover to a consistent point
  • ora-39203 : Partition selection is not supported over a network link.
  • ora-08448 : syntax error in DECIMAL-POINT environment clause
  • ora-23619 : non-Oracle system error: string
  • ora-38770 : FLASHBACK DATABASE failed during recovery.
  • ora-24367 : user handle has not been set in service handle
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-16417 : Activation occurred after recovery from standby redo log files; a full database backup is required
  • ora-19238 : XP0018 - focus not defined
  • ora-27374 : insufficient privileges on event source queue
  • ora-27370 : job slave failed to launch a job of type EXECUTABLE
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-14401 : inserted partition key is outside specified partition
  • ora-02157 : no options specified for ALTER USER
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-19378 : invalid mode
  • ora-16127 : stalled waiting for additional transactions to be applied
  • ora-19267 : XQ0047 - module string not found
  • ora-22063 : reading negative value [string] as unsigned
  • ora-36726 : (XSALERR00) The character 'character' is not a valid format specifier for the ALLOCATE error log.
  • ora-13902 : The specified file string is not a data file.
  • ora-01266 : Unable to create unique file name
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-02038 : define is not allowed for array type
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • 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.