Sunday, 16 March 2014

Create spfile using pfile

How to create pfile/spfile from spfile/pfile?

In sql prompt issue the below commands:

 To create spfile from pfile:
SQL>create pfile from spfile;
File created.

 To create pfile from spfile:
SQL>create pfile from spfile;
File created.

No comments:

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...