Wednesday, June 29, 2016

nls_session_parameters give different output sql devloper server



The output of nls_session_parameters parameter is different  in sql developer and server. Its because of  default parameter configuration in sql developer.

Server:-



Sql Developer:-

Tools ->Preferences->Database->NLS


Monday, June 27, 2016

Restore Enterprise Edition(EE) backup in Standard Edition(SE2) server oracle 12c 12.1.0.1.0

We can restore enterprise edition RMAN backup in the server where standard edition two binaries installed.

Production Database




Standby Database