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
