Category Archives: ORA- ERRORS

Drop a Tablespace With a Datafile Missing

shutdown database. startup database in mount status. alter database datafile ‘PATH/filename’ offline drop. open database. drop tablespace tablespace_name including contents. Note, the below errors could be seen in alert.log: ORA-01135: file 4 accessed for DML/query is offline ORA-01110: data file … Continue reading

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

ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates

Below errors occurred while starting up a 12.2.0.1 Oracle database instance. SQL> startup ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpcreates … Continue reading

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

ORA-03135: connection lost contact in12.1.0.2 Standby Database

Newly built 12.1.0.2 DataGuard got below errors: Primary Database alert.log: Mon Sep 11 11:35:59 2017 TT01: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3135) TT01: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned Mon Sep 11 11:35:59 2017 Errors in file /u01/app/oracle/diag/rdbms/ractest/RACTEST1/trace/RACTEST1_tt01_30967.trc: ORA-03135: connection lost … Continue reading

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

ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

The below error occurred when creating¬†a new Data Guard Broker configuration on 12.1.0.2 RAC database. DGMGRL>CREATE CONFIGURATION ‘RACTEST_DG’ as PRIMARY DATABASE IS ‘RACTEST’ CONNECT IDENTIFIER IS RACTEST; Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added SOLUTION 1)Remove /reset … Continue reading

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

ORA-15260: permission denied on ASM disk group

Problem Try to set ASM diskgroup attribute, then get below errors: $ sqlplus / as sysdba … .. . SQL> alter diskgroup OCR_VOTE SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2′; alter diskgroup OCR_VOTE SET ATTRIBUTE ‘compatible.asm’ =’11.2.0.2′ * ERROR at line 1: ORA-15032: … Continue reading

Posted in ASM, GI and RAC, ORA- ERRORS, User Privileges and Roles | Tagged , , | Leave a comment

ORA-65066: The specified changes must apply to all containers in 12C

  $ sqlplus sys@pdb1 as sysdba SQL> alter user system identified by “Password!23”; alter user system identified by “Password!23” * ERROR at line 1: ORA-65066: The specified changes must apply to all containers SQL> show con_name CON_NAME —————- PDB1   … Continue reading

Posted in 12c new features, ORA- ERRORS | Tagged , | Leave a comment

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 Configuration, GI and RAC, 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