Could not reserve enough space for object heap

Error Message :

Error occurred during initialization of VM
Could not reserve enough space for object heap
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.

Solution:

Create environmental variable _JAVA_OPTION and set value to -Xmx512M

"Cannot find the javaw.exe"

While running RCU
Error Message : "Cannot find the javaw.exe"

Action:

JAVA_HOME is a regular path when ever we install JDK in our machine and if it is not supporting to other tools.

ODI_JAVA_HOME we need to set as same JDK path because ODI required Java engine and it is backgrond process for ODI studio

Process:

1. Right click on computer 
2. Go to Properties
3. Advanced settings
4. Click on Environment variables
5. Click on new
6. Set values      --- Windows

set JAVA_HOME=C:\Program Files\Java\jdk1.7.0_25

set ODI_JAVA_HOME=C:\Program Files\Java\jdk1.7.0_25 

1.                     --- LINUX/UNIX
   export JAVA_HOME=/usr/java/jdk1.7.0_25
   export ODI_JAVA_HOME=/usr/java/jdk1.7.0_25

unable to access or modify the system registry

Error Message : unable to access or modify the system registry

Action:

Could you please open your Command Prompt with Administrator Privileges in order to run command Prompt with Admin Privileges

   Goto ----> start ----> All Programs -----> Accessories ---> Right Click on Command Prompt and select "Run as Administrator" option

Error: Could not find or load main class ûjar

Error Message : Could not find or load main class ûjar
Which means your java not properly installed . To resolve issue - reinstall JAVA it.

How to find version of Oracle?

SELECT version FROM V$INSTANCE; -- we can get exact version of database
/
SELECT * FROM V$VERSION; -- we can get detail information along with version (like bit - windows 32bit or 64 bit ....)

How to unlock User and Unexpire User in Oracle DB?

• Login as Admin
  SQL> connect / as SYSDBA
  Connected
• How to find accounts are expired and locked?
  select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';
• Unexpired Accounts 
  once an account has been expired, it can only be alter by assigning it a new password:
  ALTER USER HR IDENTIFIED BY HR;
• Unlock Accounts
  ALTER USER HR ACCOUNT HR;
• Disable default password expiry
  this all depends on the profile a user belongs to, to disable password expiry for all users assigned the default user profile do this:
  ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Unlock Account from SQL developer

        Log in as sys or system, then often three other user node and right click the hr user. Select edit from the           context menu and remove the check mark from 'lock account' 

Performance Tuning

Performance Tuning

The following things will increase performance at ODI level

• Select Appropriate Knowledge module to Load data
• Execution of Joins and Filter in appropriate area (i.e., Source/Stage/Target)
• Increase Array Fetch size and Batch Fetch size of the data server
• select different schema for data and work in "Physical architecture" 
• Enable Archival Logging
• Truncate mode no for temporary tables
• CDC log based improves performance