SQL Developer Connect Error - ORA-00604: SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified

By -

When using SQL Developer we will sometime get following error if our computer default language is settings don't go well with Oracle SQL Developer.


While connecting to database from the SQL Developer fails with the following error:

ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified

How to fix this?

Find sqldeveloper.conf file: under SQLDeveloper Home / Bin directory. 

Edit config file to add below options and save. 

AddVMOption -Duser.language=en

AddVMOption -Duser.country=US

Restart SQL Developer and try connection again.

Comments

Post a Comment

Popular posts from this blog

Oracle APPS Create Responsibility and User in Oracle EBS

By -
How to create Responsibility and User in Oracle EBS How to Create a Responsibility? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then Responsibility then Define Step 4: Enter the Data in the opened Window. Note: Above Information of Responsibility is stored in FND_RESPONSIBILITY Table. How to Create a User? Step 1: Connect to Oracle Application with APPSADMIN/APPSADMIN User. Step 2: Go to Application Administrator. Step 3: Go to Security then User then Define Step 4: Enter the Data in the opened Window. Note: Above Information of User is stored in FND_USER Table. User Responsibilities stored in FND_USER_RESP_GROUPS Table.
Read more

गारपीट

By -
Image
                                                ।। गारपीट ।।                              आल्या पावसाच्या धारा, सरा  मांडला पसारा, उभं पिक रानामधी, गेल्या  नासवून गारा.  झाला   फुलाले अघात, समधि गळाली रे पानं पाणी पाणी चोहीकडे  तरी जळाली रे मनं                                                          काही माणूस भी गेले                                                           काही तुटले छप्पर                  ...
Read more

Debug OAF Page

By -
How to  Debug OAF Page We can enable logging by setting the below profile option:- Option: 1) • FND: Debug Log Enabled profile set to ‘Yes’ • Turn on low level statement logging for a single user to monitor • FND: Debug Log Level= Statement Option: 1) Another way of gathering the same info is the following: 1)  Enable profile option FND: Diagnostics   2)  Add following at the end of existing page URL,    &aflog_level=Statement &aflog_module=* • Use '*' for wildcard, not '%'. '%' is a special URL character) Example: • http://host:port/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE&aflog_level=STATEMENT&aflog_module=pa You can see the log on screen by using by below code in your controller OR in Application ModuleImpl For AM getOADBTransaction().writeDiagnostics(this, "I am in the Application Module", 1); For Controller  pageContext.writeDiagnostics(this, "I am in Controller PFR", 1);
Read more