Connect Failed With Sql Error 12705 Sap
Contents |
phpBB Group
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB ora-12705 instant client Don Burleson Blog
Ora-00604 Error Occurred At Recursive Sql Level 1 Ora-12705
Resolving ORA-12705: Cannot access NLS data files or invalid environment specified Oracle tips by
Ora-12705 Toad
Burleson Question: I an getting the error "Resolving ORA-12705: Cannot access NLS data files or invalid environment specified" when I change my NLS_LANG setting. The developers need to experiment http://www.sapfans.com/forums/viewtopic.php?f=12&t=105820 with different character sets but when they issue export NLS_LANG and try to start SQLPLUS after that they get the ORA-12705 error.Answer: First, see my notes all about the ORA-12705 error. The ORA-12705 error is indeed controlled by NLS_LANG, and the ORA-12705 commonly happens when Oracle does an automatic "alter session" at login time and discovers an invalid NLS_LANG setting. http://www.dba-oracle.com/t_ora_12705_resolution.htm The Oracle documentation notes are not very helpful: ORA-12705: "invalid or unknown NLS parameter value specified" Cause: There are two possible causes: - An attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value. - The NLS_LANG environment variable contains an invalid language, territory, or character set. Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. Oracle also says that the ORA-12705 can happen under these conditions and MOSC has resolutions for these ORA-12705 conditions: 1. ORA-12705 with incorrect NLS_LANG parameter 2. ORA-12705 with incorrectly specified ORA_NLSx 3. ORA-12705 from incorrect Oracle install or configuration 4. ORA-12705 when using Special Character sets 5. ORA-12705 when connecting with SQL*Net 6. ORA-12705 during migrations 7. ORA-12705 when connecting with SQL*Plus 8. ORA-12705 when connecting with language pre-compilers 9. ORA-12705 during Export/Import For ORA-12705 errors caused by invalid NLS_LANG settings, you need to verify that it is "unset" at the system-level: Windows - The NLS_LANG m
+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. error saying "Cannot access NLS data files" Search this topic...|Search CMC...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Security and User Administration -> CMC Author Message meettaurusPrincipal MemberJoined: 10 Mar 2005Posts: 237Location: Phily Posted: Wed Oct 17, 2007 8:40 amPost subject: error saying "Cannot access NLS data files" Hi All, I have scheduled reports using the CMC. Now all the reports have failed. I am getting the following error message --- Connection or SQL sentence error: (DA0005): [Exception: DBD, ORA-12705: Cannot access NLS data files or invalid environment specified State: N/A] A connection required to refresh this document is unavailable. (DA0004): [] The following data providers have not been successfully refreshed: qry-Forecast-BRODER. (DMA0007): Any idea what this error is ? And what is the solution? Thanks Meettaurus_________________BO 6x, BO XI-R2,BOXIr3.2, Oracle 9i/10G/11G, windows 2003 SP3. Back to top meettaurusPrincipal MemberJoined: 10 Mar 2005Posts: 237Location: Phily Posted: Fri Oct 19, 2007 9:32 amPost subject: Re: error saying "Cannot access NLS data files" Hi All, got the solution for this error- need to go and update the registry NLS-Lang--- The Oracle NLS_LANG registry entry was NA. I had to change it to AMERICAN_AMERICA.WE8ISO8859P15. Then reboot the server. Thanks, Meettaurus_________________BO 6x, BO XI-R2,BOXIr3.2, Oracle 9i/10G/11G, windows 2003 SP3. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 YearOldest FirstNewest First Register or Login to Post Forum Index -> Security and User Administration -> CMC Page 1 of 1 All times are GMT - 5 Hours Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Jump to:Select a forumBusinessObjects Software------------------------------------General DiscussionBuilding Reports•Legacy C