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 : 29-04-2017

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

  • ora-25277 : cannot grant or revoke object privilege on release 8.0 compatible queues
  • ora-28041 : Authentication protocol internal error
  • ora-19258 : XQ0038 - unsupported or duplicate default collation specified
  • ora-04090 : 'string' specifies same table, event and trigger time as 'string'
  • ora-25195 : invalid option for index on an index-organized table
  • ora-02235 : this table logs changes to another table already
  • ora-29398 : invalid privilege name specified
  • ora-15166 : cluster in rolling downgrade from version [string] to [string]
  • ora-08192 : Flashback Table operation is not allowed on fixed tables
  • ora-14453 : attempt to use a LOB of a temporary table, whose data has alreadybeen purged
  • ora-24165 : invalid rule engine object privilege: string
  • ora-10589 : Test recovery had to corrupt string data blocks in order to proceed
  • ora-13036 : Operation [string] not supported for Point Data
  • ora-09368 : Windows 3.1 Two-Task driver unable to spawn ORACLE
  • ora-30575 : ConText Option not installed
  • ora-02478 : merge into base segment would overflow MAXEXTENTS limit
  • ora-06790 : TLI Driver: poll failed
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-01918 : user 'string' does not exist
  • ora-06011 : NETASY: dialogue too long
  • ora-12027 : duplicate filter column
  • ora-27144 : attempt to kill process failed
  • ora-31001 : Invalid resource handle or path name "string"
  • ora-27125 : unable to create shared memory segment
  • ora-30354 : Query rewrite not allowed on SYS relations
  • ora-30486 : invalid window aggregation group in the window specification
  • ora-00096 : invalid value string for parameter string, must be from among string
  • ora-24047 : invalid agent name string, agent name should be of the form NAME
  • ora-06956 : Failed to get local host name
  • ora-36962 : (XSRELTBL08) string is not a valid workspace object.
  • 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.