Creating oracle Database instace We need to create a oracle database instance similar to customer environment. What are all the parameters needs to be considered other than similar version of software.

Like Character set, Multibyte Or Single Byte and other Database, Instance, Session level parameters which are to be considered.


What happen if a Dump Successfully imported into a Database instance with different NLS parameters, Will it be having any Side effects?
Is there a standard way of creating a replica of customer instance in our local?
Oracle 'takes care' of the conversion between different NLS settings. As long as both NLS settings can store the same characters the there should be no problem. It is the same as the difference between the database and a client.

If for example the database of the customer is in UTF-8 and you create a database in ISO8859-P1 then you will loose (some) characters with accents and from non-western alphabets. The other way around gives no problem.