RMAN-10002 ORA-00096

by

RMAN may fail with error RMAN-10002: ORACLE error: ORA-00096: invalid value SIGNATURE for parameter remote_dependencies_mode, must be from among NO_OVERFETCH, OVERFETCH. The error message is confusing here as remote_dependencies_mode can only take two values: TIMESTAMP or SIGNATURE. The suggested values may be anything else from another parameter. When running RMAN command, it tries to do … Read more

ORA-27301 OS failure message: No buffer space available

by

If you get this error ORA-27300: OS system dependent operation:sendmsg failed with status: 105ORA-27301: OS failure message: No buffer space availableORA-27302: failure occurred at: sskgxpsnd2 The solution is to: Lower MTU to 16436. To do this, add following to /etc/sysconfig/network-scripts/ifcfg-lo or replace the value if MTU is already set in this configuration file.MTU=16436 Save the … Read more

ORA-00600 [KSLGES_3]/ORA-27300

by

When using RHEL 7.2 you may encounter some database crash with the errors below: ORA-27157: OS post/wait facility removedORA-27300: OS system dependent operation:semop failed with status: 43ORA-27301: OS failure message: Identifier removedORA-27302: failure occurred at: sskgpwwait1ORA-00600: internal error code, arguments: [KSLGES_3], [], [], [], [], [], [], [], [], [], [], []ORA-27300: OS system dependent … Read more

“can’t open the fdp output file linkorderfile” Error

by

“can’t open the fdp output file linkorderfile” warning is seen during oracle binary link on HP Unix. This problem can happen if you invoke “make -f $ORACLE_HOME/rdbms/lib/ins_rdbms_mk ioracle” from directory different from $ORACLE_HOME/rdbms/libThe problem can happen on scripts tha call “ins_rdbms.mk ioracle”, for example, the “chopt” script can hit this problem. Workaround“cd $ORACLE_HOME/rdbms/lib” and rerun … Read more

Oracle Database Licensing: Editions and License Metrics

by

This article is an English translation of the original post published on 20 February 2019. It outlines Oracle Database editions and the licensing metrics discussed in the original article. Historical note: The licensing statements below are translated from a 2019 article and have not been validated as current licensing advice. Entitlements depend on the applicable … Read more

Using variables in RMAN

by

When using RMAN catalog it is preferred to use backup script stored in catalog. It is best if scripts can be reused for different retention. You can use variables in RMAN script this way: CREATE global script global_backup_full_database comment ‘backup full of database. Parameter sysdate+n,tag db, tag archivelog’ { allocate channel c1 TYPE SBT_TAPE PARMS … Read more

List number of archivelogs

by

You can list the number of archivelogs generated this way: SELECT trunc(COMPLETION_TIME,’DDD’) DAY, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB, COUNT(*) "NB_Files" FROM V$ARCHIVED_LOG GROUP BY trunc (COMPLETION_TIME,’DDD’) ORDER BY 1;