How to Install and deinstall Oracle Text in 12.1.0.2

This post demonstrates how to deinstall / install Oracle Text in 12.1.0.2. Before doing so, DBA should make sure and understand the component dependencies as below.

Subscribe to get access

Read more of this content when you subscribe today.

How to Install and deinstall Oracle Text in 11.2.0.4

This post demonstrates how to deinstall / install Oracle Text in 11.2.0.4. Before doing so, DBA should make sure and understand the component dependency as below.

Subscribe to get access

Read more of this content when you subscribe today.

How to Terminate the Idle Sessions Automatically in Oracle

Poor application design can cause excessive connections to Oracle database, the idle sessions stuck in Oracle database forever, finally the ORA-00020 error occur in alert log.

Certainly DBA can write a job to kill the idle sessions periodically. Instead, here we will take advantage of Oracle features to terminate idle sessions in Oracle database automatically.

Subscribe to get access

Read more of this content when you subscribe today.

ERROR: currval of sequence “SEQUENCE_NAME” is not yet defined in this session

In PostgreSQL, when trying to get the current value of a sequence, the following errors occur:

select currval('SEQUENCE_NAME');

ERROR:  currval of sequence "SEQUENCE_NAME" is not yet defined in this session
SQL state: 55000

SOLUTION

Query PG_SEQUENCES to get the last value of sequences.

=> \d pg_sequences
              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          |
 sequencename  | name    |           |          |
 sequenceowner | name    |           |          |
 data_type     | regtype |           |          |
 start_value   | bigint  |           |          |
 min_value     | bigint  |           |          |
 max_value     | bigint  |           |          |
 increment_by  | bigint  |           |          |
 cycle         | boolean |           |          |
 cache_size    | bigint  |           |          |
 last_value    | bigint  |           |          |