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 […]

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 […]

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 […]

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: […]

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 […]

ORA-01691: unable to extend lob segment

Caused By : Exception java.sql.SQLException: ORA-01691: unable to extend lob segment MARS.SYS_LOB0000127455C00011$$ by 8192 in tablespace USERS java.sql.SQLException: ORA-01691: unable to extend lob segment MARS.SYS_LOB0000127455C00011$$ by 8192 in tablespace USERSat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) …. … .. .  I am seeing this ORA-01691 error and my database is […]