Skip to main content

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

Use of Who Columns in Oracle APPS table

By
Oracle APPS : WHO COLUMNS WHO columns are used to track the information updated or inserted by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed. Steps required to Track WHO Information in our form   1. ALTER the table by adding WHO columns in the table.   2. Open TEMPLATE.fmb in form Builder.   3. Perform all the pre‐requisites to develop a form.   4. Include all the WHO columns in the Data Block with NULL Canvas.   5. Call FND_STAND.SET_WHO procedure in Pre‐Insert and Pre‐Update triggers       at Block Level.   6. Save and Compile the Form.   7. Perform all the pre‐requisites to register the form Note: 1. WHO Columns need not register with the table registration option.           2. Table registration will be done only for KFF and DFF col...
Post a Comment
Read more

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.
2 comments
Read more

Setup steps for Drop Shipments in Oracle EBS

By
  Oracle Order Entry and Oracle Purchasing integrate to provide drop shipments. Drop shipments are orders for items that your supplier ships directly to the customer either because you don't stock or currently have the items in inventory, or because it's more cost-effective for the supplier to ship the item to the customer directly SETUP A) Associate drop shipments with a receiving location. B) Drop shipments support a Destination Type of Expense or Inventory only. C) We can handle returns of drop shipments using standard Order Entry/Shipping or Purchasing functionality. There are different ways you may want to handle returns depending on whether the customer returned the item to you or directly to the supplier. We have to consider the following setup: 1- Inventory Setup  Inventory Setup : (Define and Maintain The Item) The drop ship inventory organization, item and subinventory must be setup prior to creating any drop ship orders. All drop ship ...
3 comments
Read more