ORA-16164: LGWR network server host detach error

Cause : The LGWR network server could not detach from remote host

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

The alert log contains more problem-specific information

update : 18-08-2017

ORA-16164 - LGWR network server host detach error
ORA-16164 - LGWR network server host detach error

  • ora-16218 : This database is already preparing to switch over.
  • ora-02365 : error seeking in file: string
  • ora-15039 : diskgroup not dropped
  • ora-02723 : osnpui: cannot send break signal
  • ora-06422 : NETCMN: Error in sending data
  • ora-06257 : NETNTT: cannot send command line to shadow process
  • ora-31639 : unexpected data found
  • ora-32502 : Cannot execute command. Flash Freeze is not in effect
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-19713 : invalid copy number: string
  • ora-32841 : invalid value for property string
  • ora-19914 : unable to encrypt backup
  • ora-16764 : redo transport service to a standby database is offline
  • ora-12472 : policy string is being used
  • ora-23305 : internal deferred RPC error: string
  • ora-02800 : Requests timed out
  • ora-30450 : refresh_after_errors was TRUE; The following MVs could not be refreshed: string
  • ora-29500 : NAMED keyword is invalid in CREATE JAVA CLASS
  • ora-01269 : Destination parameter string is too long
  • ora-31086 : insufficient privileges to register schema "string"
  • ora-01950 : no privileges on tablespace 'string'
  • ora-28236 : invalid Triple DES mode
  • ora-10658 : Lob column to be shrunk is marked unused
  • ora-13503 : Creating SYSAUX tablespace with invalid attributes
  • ora-10661 : Invalid option specified
  • ora-37004 : (AWLISTALL02) number reader
  • ora-15157 : rolling upgrade or downgrade is not allowed
  • 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.