ORACLE DBA- Page 3 of 4 - Compitionpoint

Archives for ORACLE DBA - Page 3

ORA-12547 TNS: Lost Contact

compitionpoint November 4, 2020 ORA-12547 TNS: Lost Contact2020-09-12T11:33:34+00:00 Oracle database No Comment

Delete expired archivelogs using RMAN

compitionpoint October 29, 2020 Delete expired archivelogs using RMAN2020-09-12T11:31:16+00:00 RMAN No Comment

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

compitionpoint October 28, 2020 Delete expired archivelogs using RMAN2020-09-12T11:31:19+00:00 RMAN No Comment

Delete expired archivelogs using RMAN

compitionpoint October 26, 2020 Delete expired archivelogs using RMAN2020-09-12T11:31:27+00:00 RMAN No Comment

ORA-01940: cannot drop a user that is currently connected

compitionpoint October 25, 2020 ORA-01940: cannot drop a user that is currently connected2020-09-12T11:31:31+00:00 Oracle database No Comment

SQL>drop user MY_USER cascade; drop user username cascade * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected SQL>select , #, , from v$session s, v$process…

ORA-39097 Data Pump job encountered unexpected error

compitionpoint October 7, 2020 ORA-39097 Data Pump job encountered unexpected error2020-09-12T11:29:53+00:00 Oracle database No Comment

ERROR: Export: Release – Production on Wednesday, 08 August, 2007 10:12:50 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release – Production With…

ORA-39181: Only partial table data may be exported due to fine grain access control

compitionpoint October 5, 2020 ORA-39181: Only partial table data may be exported due to fine grain access control2020-09-12T11:30:05+00:00 Oracle database No Comment

The below error appeared when trying to export the Schema: ORA-39181: Only partial table data may be exported due to fine grain access control on “GLOGOWNER”.”WORKFLOW_ACTION_PARAM” . . exported “GLOGOWNER”.”WORKFLOW_ACTION_PARAM”…

DATABASE SCHEMA SIZE from the database

compitionpoint October 4, 2020 DATABASE SCHEMA SIZE from the database2020-09-12T11:30:09+00:00 Oracle database No Comment

set linesize 150 set pagesize 5000 col owner for a155 select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner; Thank you !!

Find Plan Hash Values from SQLID

compitionpoint September 29, 2020 Find Plan Hash Values from SQLID2020-09-12T11:30:31+00:00 Oracle database No Comment

SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 SELECT DISTINCT sql_id, plan_hash_value FROM dba_hist_sqlstat q, ( SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap,…

SET PASSWORD LIFE TIME TO UNLIMITED

compitionpoint September 27, 2020 SET PASSWORD LIFE TIME TO UNLIMITED2020-09-12T11:30:39+00:00 Oracle database No Comment

Set the password life time to unlimited for DEFAULT profile. SQL> SELECT resource_name,limit FROM dba_profiles WHERE profile=’DEFAULT’; RESOURCE_NAME LIMIT ——————————– —————————– COMPOSITE_LIMIT UNLIMITED SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL UNLIMITED LOGICAL_READS_PER_SESSION…

1 234