troubleshooting Question

NLS_Parameters

Avatar of foss2002
foss2002 asked on
Oracle Database
4 Comments1 Solution3614 ViewsLast Modified:
Hi there,
Can someone help to provides answers to below:

Que000stions:
1. I Display the contents of the V_$NLS_parameters for 2 database & found out 1 of db's NLS is not the same values esp the Language & Teritory.
   Can i change the values of the NLS parameter in my database so that both db are consistent, if yes or no, will there have any impact of applications.

2. How do i change the values, cause it is merely a data dict view & not a table, can it be done via initialization parameters or alter session or how?

3. I also noticed that the values in the display contents of the V_$NLS_parameters are different when i view All Initialization Parameters in the instance
   configuration using OEM console. Are these come from the same source of data? Do i have to make it consistent for both NLS values in Initialization
   Parameters and  V_$NLS_parameters.

4. May i know if the values in All Initialization Parameters can be changed? If yes, do i have to shutdown & start up database to make into effect.?

Hope to hear from u soon...SFF.
ASKER CERTIFIED SOLUTION
CetusMOD

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros