How to compile forms in 11i
we have to use f60gen for compiling forms and libraries in Oracle Applications Version 11i, But this is deprecated in R12 and we need to use frmcmp(Form Compiler) to compile…
Drop temp tablespace taking long time
Created new temporary tablespace: CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘/u01/oracle/#8217; SIZE 2g; Make new temporary tablespace as default: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Dropping old temporary tablespace, Which is…
Find size of Table,Index and USER/SCHEMA in Oracle
How to find size of Table or Index or User/Schema in Oracle Database. SIZE OF TABLE: Select segment_name,sum(bytes)/1024/1024/1024 as “SIZE in GB” from user_segments where segment_name=’TABLE_NAME’ group by segment_name; OR…
Disable Case Sensitive in Oracle Database 11g
Prior to 11g Passwords in Oracle are not case sensitive. Now from 11g Oracle passwords are Case sensitive. Parameter sec_case_sensitive_logon has been included in Oracle 11g. sql> create user test…
ORA-12547 TNS: Lost Contact
Getting the following error when trying to connect using Sql*Plus ERROR: $sqlplus / as sysdba SQL*Plus: Release – Production on Wed Mar 30 11:59:06 2011 Copyright (c) 1982, 2008, Oracle.…
Could not reserve record (2 tries). Keep trying?
When attempting to reset User password (Security / User / Define form) in R12, the following error occurs. ERROR: “Could not reserve record (2 tries). Keep trying?” CAUSE: Seams that…
Could not reserve record (2 tries). Keep trying?
When attempting to reset User password (Security / User / Define form) in R12, the following error occurs. ERROR: “Could not reserve record (2 tries). Keep trying?” CAUSE: Seams that…
FRM-92050: Failed to connect to the Server: /forms/servlet:- 1
Facing below issue when attempt to log into forms EBS R12 ERROR: FRM-92050: Failed to connect to the Server: /forms/servlet:- 1 Details… Java Exception: : Negative content-length from :port/forms/frmservlet? CAUSE:…
Could not reserve record (2 tries). Keep trying?
When attempting to reset User password (Security / User / Define form) in R12, the following error occurs. ERROR: “Could not reserve record (2 tries). Keep trying?” CAUSE: Seams that…
Recommended Browsers for Oracle E-Business Suite Release 12
Recommended Browsers for EBS R12 and any issues related to browsers, Please go through with below Oracle recommended document. ORACLE DOCUMENT: Recommended Browsers for Oracle E-Business Suite Release 12 (Doc…