Category Archives: ORA- ERRORS

ORA-02065: illegal option for ALTER SYSTEM

In an old 10g database, when tried to change SGA_TARGET parameter in spfile, “ORA-02065: illegal option for ALTER SYSTEM” occurred. $ sqlplus / as sysdba SQL*Plus: Release 10.2.0.5.0 – Production on Tue Jun 13 15:56:37 2017 Copyright (c) 1982, 2010, … Continue reading

Posted in GI and RAC, Configuration, ORA- ERRORS | Tagged , | Leave a comment

ORA-02158: invalid CREATE INDEX option

Tried to apply Oracle Advanced Compression Feature onto IOT tables in 12.1.0.2, then got this error. SQL> CREATE TABLE TEST_IOT_TBL ( id number, sex char(1), name varchar2(20), CONSTRAINT TEST_IOT_TBL_PK PRIMARY KEY (id,sex ) ENABLE ) ORGANIZATION INDEX ; Table created. … Continue reading

Posted in ORA- ERRORS, oracle advanced compression | Tagged , , | Leave a comment

ORA-14451: unsupported feature with temporary table

It looks like temporary table can nor be compressed by using Oracle Advanced Compression Features in 12.1.0.2. SQL> alter session set current_schema=jamesh; SQL> CREATE GLOBAL TEMPORARY TABLE TEST_TBL ( id number, name varchar(20), CONSTRAINT TEST_TBL_PK PRIMARY KEY (id) ENABLE ) … Continue reading

Posted in ORA- ERRORS, oracle advanced compression | Tagged , | Leave a comment

ORA-08004: sequence TEST_SEQ.NEXTVAL exceeds MAXVALUE and cannot be instantiated

SQL> CREATE SEQUENCE test_seq START WITH 1 INCREMENT BY 1 MAXVALUE 10;  Sequence created. SQL> select test_seq.currval from dual; select test_seq.currval from dual * ERROR at line 1: ORA-08002: sequence TEST_SEQ.CURRVAL is not yet defined in this session SQL> select … Continue reading

Posted in ORA- ERRORS, SQL Scripts For DBA | Tagged , , , , , , , , , | Leave a comment

ORA-01758: table must be empty to add mandatory (NOT NULL) column

While adding NOT NULL column into a table, the below error occurred: SQL> Alter table CM_ODS_DWN_STG add MATCH_EVT_ID  CHAR(12) NOT NULL; Alter table CM_ODS_DWN_STG add MATCH_EVT_ID  CHAR(12) NOT NULL             * ERROR at line 1: ORA-01758: table must be empty … Continue reading

Posted in ORA- ERRORS | Tagged , | Leave a comment

ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/TABLE/COMMENT

When importing a schema exported from one 12cR1 AL32UTF8 database to another database  with same AL32UTF8 characterset, this ORA -error was generated : ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/TABLE/COMMENT The error message clearly shows the problem data is from … Continue reading

Posted in DataPump, ORA- ERRORS | Tagged , , , , , , , , | Leave a comment

No standby redo logfiles available for T-1

One single instance 12c Oracle database alert log shows below information;  RFS[1]: No standby redo logfiles available for T-1 DataGuard shows ORA-16857 error: DGMGRL> show database verbose “TESTSTY”; Database – TESTSTY Role: PHYSICAL STANDBY Intended State: APPLY-OFF Transport Lag: 7 minutes … Continue reading

Posted in 12c new features, CDB/PDB, DataGuard, ORA- ERRORS | Tagged , , , , , , | Leave a comment

ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group

Trying to drop a temporary tablespace which belongs to a default temporary tablespace group. SQL> select * from DBA_TABLESPACE_GROUPS; GROUP_NAME TABLESPACE_NAME ——————- —————————— TEMP_OLTP TEMP TEMP_OLTP TEMP2 TEMP_OLTP TEMP3 SQL> DROP TABLESPACE temp2 INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE temp2 INCLUDING … Continue reading

Posted in ORA- ERRORS | Tagged , , | Leave a comment

ORA-16826: apply service state is inconsistent with the DelayMins property

We received the OEM alert by complaining DataGuard status with error as “ORA-16826: apply service state is inconsistent with the DelayMins property”. Oracle official explanation is as below : $oerr ora 16826 16826, 0000, “apply service state is inconsistent with … Continue reading

Posted in DataGuard, GI and RAC, ORA- ERRORS | Tagged , , , , , , , , , , , , | Leave a comment

ORA-01105: mount is incompatible with mounts by other instances ORA-19808: recovery destination parameter mismatch

When tries to start up one instance of the RAC , got below errors. ….. …. ORA-01105: mount is incompatible with mounts by other instances ORA-19808: recovery destination parameter mismatch … Check flash recovery parameters on other node: SQL> show … Continue reading

Posted in Configuration, GI and RAC, ORA- ERRORS | Tagged , , , , , | Leave a comment