Oracle database Upgrade from 10.2.0.2 to 10.2.0.4Prerequisites and Precautionary actions before starting DB Upgrade:1) Take a backup of the Oracle database: Online or Offline2) Take a file system level backup of 102_64 DirectoryTar command or backup command or even cp (Recursive) is recommended for oracle Read More
Last week when i tried to install ECC EHP4 with 10.2.0.4 i got the below error. After the lot of analysis i came to know the error resolution. When I try to install Oracle 10g on Windows 2008 (in a Read More
While execute R3trans -d if you get this error “ORA-00019: maximum number of session licenses exceeded” Need to be increased max sessions using below command. alter system set sessions=500 scope=spfile; alter system set sessions=500 scope=both and license max session = 0 Read More
Here i am listing some SAP Oracle SQL commands which are very useful useful many occasions. 1.Count no. of records in a table select count(*) from sapsr3.vbfs; 2. Count no. of sessions in db SELECT inst_id, count(*) “DB Read More
Here i would like to explain you how we can fix ORA-03113 end-of-file on communication channel: Observation of Problem: SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 2.6591E+10 bytes Fixed Size Read More
