Oracle Trace file (.trc) or Trace map (.trm) cleanup

To clean up old Oracle trace file (.trc) and trace map (.trm) files, use this command on UNIX based system: Connect sqlplus :   And, find /u01/app/oracle/diag/rdbms/sbuat01/SBUAT01/trace/*.trc -mtime +14 -exec rm {} \; find /oracle/diag/rdbms/ssekdb/ssekdb/trace/*.trm -mtime +14 -exec rm {} \; The above command will delete trace files and trace map files which is older … Continue reading Oracle Trace file (.trc) or Trace map (.trm) cleanup

Advertisements

Flash Recovery Area

Setting up a Flash Recovery Area The recovery area is defined by setting two initialization parameters. These two parameters can be dynamically altered or disabled. The db_recovery_file_dest_size sets the disk limit, expressed in bytes The db_recovery_file_dest sets the location for the recovery area Enabling a Flash Recovery Area This statement sets the disk limit for … Continue reading Flash Recovery Area

Oracle Database Disk Size

select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) + ( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) + ( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) “Size in GB” from dual;

ERROR: ORA-00257: archiver error. Connect internal only, until freed.

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 27 08:31:46 2017 Copyright (c) 1982, 2013, Oracle.  All rights reserved. ERROR: ORA-00257: archiver error. Connect internal only, until freed. Fast solution is to simply increase the value for db_recovery_file_dest_size. Steps: SQL> sho parameter db_recovery_file NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /recoveryarea db_recovery_file_dest_size big integer 200G … Continue reading ERROR: ORA-00257: archiver error. Connect internal only, until freed.

ORA-01950: no privileges on tablespace ‘USERS’ [closed]

The problem was with quota on the USERS tablespace. Granting unlimited quota for the user on the USERS tablespace resolved the problem: You cannot insert data because you have a quota of 0 on the tablespace. To fix this, run ALTER USER <user> quota unlimited on <tablespace name>; or ALTER USER <user> quota 100M on … Continue reading ORA-01950: no privileges on tablespace ‘USERS’ [closed]

CpuCount, SCSI, RAM SIZE 

Cpu Count: specifies the number of CPUs available for Oracle Database to use select value   from v$parameter where name like 'cpu_count'; SCSI: To display the SCSI devices currently attached (and recognized) by the SCSI subsystem use. cat /proc/scsi/scsi The output looks like this: [oracle@alsm ~]$ cat /proc/scsi/scsi Attached devices: Host: scsi0 Channel: 00 Id: … Continue reading CpuCount, SCSI, RAM SIZE 

How to change the DB_UNIQUE_NAME in a RAC database

1) Remove the database, instance and service resources from CRS, this does NOT affect database itself. $ srvctl stop database -d orcl $ srvctl remove database -d orcl   2) Start the database and change the db_unique_name at database level. SQL> Startup; SQL> alter system set db_unique_name=orcl_test scope=spfile sid='*'; SQL> alter system set db_domain=test.us.oracle.com scope=spfile … Continue reading How to change the DB_UNIQUE_NAME in a RAC database