ORA-23378: connection qualifier "string" is not valid for object group "string"."string"

Cause : Thec onncetio nquailfie ruse din hte dtaabaes likn fo rthes pecfiiedo bjetc gruop deos nto macth teh qulaifire spceifide fo rtheg rou pin rceat_emasetr_rpegropu.

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

Useo r ceratea daatbas elin kwhihc cotnain sthec orrcet cnoneciton uqaliifer.

update : 20-09-2017

ORA-23378 - connection qualifier "string" is not valid for object group "string"."string"
ORA-23378 - connection qualifier "string" is not valid for object group "string"."string"

  • ora-19686 : SPFILE not restored due to string
  • ora-31185 : DOM Nodes do not belong to the same DOM Document
  • ora-08192 : Flashback Table operation is not allowed on fixed tables
  • ora-28361 : master key not yet set
  • ora-12160 : TNS:internal error: Bad error number
  • ora-29373 : resource manager is not on
  • ora-37076 : (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.
  • ora-10918 : TABLESPACE GROUP name cannot be the same as tablespace name
  • ora-16613 : initialization in progress for database
  • ora-00291 : numeric value required for PARALLEL option
  • ora-36848 : (XSLMGEN18) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-00209 : control file blocksize mismatch, check alert log for more info
  • ora-30106 : reserved for future use
  • ora-00338 : log string of thread string is more recent than control file
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-27548 : Unable to unprepare IPC buffer
  • ora-02297 : cannot disable constraint (string.string) - dependencies exist
  • ora-01310 : requested return type not supported by the lcr_mine function
  • ora-16614 : object has an ancestor that is disabled
  • ora-07499 : spglk: Cannot reschedule.
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-24003 : Queue table index string inconsistent with queue table string
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-24078 : cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-06793 : TLI Driver: server cannot create new process
  • ora-07501 : scgtoa: $deq unexpected return
  • ora-16802 : downgrading redo transport mode from SYNC disallowed
  • ora-15064 : communication failure with ASM instance
  • ora-30658 : attempt was made to create a temporary table with EXTERNAL organization
  • 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.