How to create a database link in Oracle?

The syntax has been enhanced to remove the need to epscify a TNS service_name: CREATE PUBLIC DATABASE LINK <Link_Name>  CONNECT TO <remote_username> IDENTIFIED BY <PWD> USING ''tns_service_name';    


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

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


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