How to find / Set NLS_LANG in Solaris AIX Unix and Windows for Oracle?

What is NLS_LANG Parameter?

It is an environment parameter to specify the local behavior for the oracle software. The formatting of the date, number, time and currency parameter are changes depending on the regions, country. This parameter sets the language and territory used by the application and the oracle database server. NLS_LANG is a local environment variable for the UNIX platforms like Solaris, AIX and Linux. For windows it has to be set in registry or it can be set locally also.

Syntax to Find / Check / Change / Set Default Temporary Tablespace for Oracle 10g, 11g Database

Default Temporary tablespace Syntax

SQL> create temporary tablespace temp_tbs tempfile '/u01/app/oracle/oradata/qa01/temp_tbs_01' size 100m;

Tablespace created.

SQL> alter database default temporary tablespace temp_tbs;

Oracle 11g User Account Status LOCKED(TIMED) with FAILED_LOGIN_ATTEMPTS, PASSWORD_LOCK_TIME Parameters

At least few times you might have noticed the account status is with LOCKED(TIMED). In this topic we will discuss about how it is happens.

See one example here.

SQL> SELECT RESOURCE_NAME,LIMIT FROM DBA_PROFILES

  2  WHERE  PROFILE='DEFAULT' AND RESOURCE_NAME IN ('FAILED_LOGIN_ATTEMPTS','PASSWORD_LOCK_TIME');

RESOURCE_NAME                    LIMIT

-------------------------------- ----------------

FAILED_LOGIN_ATTEMPTS            1

PASSWORD_LOCK_TIME               1

Data Pump EXPDP FLASHBACK_SCN Parameter

In normal export utility (EXP) we have consistent=y option to ensure the data consistency of the dump. For Data Pump there is no consistent parameter whereas it has FLASHBACK_SCN and FLASHBACK_TIME parameters to achieve this goal. These two parameters are mutually exclusive. In FLASHBACK_SCN you have to pass the SCN number as the argument and in FLASHBACK_TIME you have to pass timestamp value.

IMPDP FLASHBACK_SCN, FLASHBACK_TIME Shows in Parameter Help – Is it a bug?

Impdp help=y shows FLASHBACK_SCN and FLASHBACK_TIME options in the list of parameters. But, when you try to import a dump with flashback_scn it says

ORA-39005: inconsistent arguments

ORA-39208: Parameter FLASHBACK_SCN is invalid for IMPORT jobs.

Something interesting!! J

impdp help=y

Troubleshoot Fix error IMP-00038: Could not convert to environment character set's handle

Problem Description:

Import fails with

IMP-00038: Could not convert to environment character set's handle

IMP-00000: Import terminated unsuccessfully

Solution Description:

1. In most of the cases this error occurs when you take an export using

Troubleshoot Fix IMP-00010 not a valid export file header failed verification

Problem Description:

Import (IMP) fails with IMP-00010 not a valid export file header failed verification

IMP-00000: Import terminated unsuccessfully

00010, 00000, "not a valid export file, header failed verification"

// *Cause:  Either the file was not generated by Export or it was corrupted.