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…
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…