PROBLEM: While creating an user as below got error as ORA-30034:Undo tablespace cannot be specified as temporary tablespace SQL> create user DBATEST1 identified by DBATEST default tablespace USERS TEMPORARY TABLESPACE UNDOTBS1 ; create user DBATEST1 identified by DBATEST default tablespace USERS TEMPORARY TABLESPACE UNDOTBS1 * ERROR at line 1: ORA-30034: Undo tablespace cannot be specified […]

PROBLEM: While adding a datafile to a table space , got the error – ORA-32771: cannot add file to bigfile tablespace SQL> ALTER TABLESPACE BIGTS add datafile ‘/dmdata02/oradata/BSDMSIT2/bigts02.dbf’ size 1G; ALTER TABLESPACE BIGTS add datafile ‘/dmdata02/oradata/BSDMSIT2/bigts02.dbf’ size 1G * ERROR at line 1: ORA-32771: cannot add file to bigfile tablespace SOLUTION: A bigfile tablespace can […]

PROBLEM: While creating bigfile tablespace with multiple datafile, got error as ORA-32774: more than one file specified SQL> create bigfile tablespace BIGTS datafile ‘/dmdata02/oradata/BSDMSIT2/bigts01.dbf’ size 1G, ‘/dmdata02/oradata/BSDMSIT2/bigts02.dbf’ size 1g; create bigfile tablespace BIGTS datafile ‘/dmdata02/oradata/BSDMSIT2/bigts01.dbf’ size 1G, * ERROR at line 1: ORA-32774: more than one file was specified for bigfile tablespace BIGTS SOLUTION: This […]

PROBLEM: While enabling autoextend for an tablespace, got error like ORA-32773: operation not supported for small file table space. SQL> alter tablespace SMALLTS autoextend on; alter tablespace SMALLTS autoextend on * ERROR at line 1: ORA-32773: operation not supported for smallfile tablespace SMALLTS   SOLUTION: A standard tablespace(i.e smallfile tablespace) can multiple datafiles, So if […]

PROBLEM: While creating a table or inserting data, user is getting error ORA-01536: space quota exceeded for tablespace . SQL> create table OBJCOPY tablespace SMALLTS as select * from dba_objects; create table OBJCOPY tablespace SMALLTS as select * from dba_objects * ERROR at line 1: ORA-01536: space quota exceeded for tablespace ‘SMALLTS’ SOLUTION: Tablespace quota […]

 PROBLEM: While importing schema objects, got below errors. ORA-39083: Object type TYPE:”PADADM10″.”NAME_AND_COUNT_ARRAY” failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: CREATE EDITIONABLE TYPE “PADADM10″.”NAME_AND_COUNT_ARRAY” OID ‘576CD3FFA14D4400E05400144FFFAA04‘ IS VARRAY(30) OF name_and_count_t; ROOT CAUSE: OID value of  TYPE should be unique in the database and So if try to import TYPE with […]

PROBLEM: While starting the listener, getting an error like TNS-12542: TNS:address already in use # lsnrctl start LISTENER_TEST2 LSNRCTL for Solaris: Version 12.1.0.2.0 – Production on 03-SEP-2018 11:06:57 Copyright (c) 1991, 2017, Oracle. All rights reserved. Starting /oracle/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr: please wait… TNSLSNR for Solaris: Version 12.1.0.2.0 – Production System parameter file is /oracle/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora Log messages written […]

PROBLEM: While starting the lister , getting below error. # lsnrctl start LISTENER_TEST LSNRCTL for Solaris: Version 12.1.0.2.0 – Production on 03-SEP-2018 09:34:26 Copyright (c) 1991, 2017, Oracle. All rights reserved. TNS-01106: Listener using listener name LISTENER_DBACLASS has already been started where ( listener.ora) LISTENER_TEST = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST […]

PROBLEM: While creating a table using CTAS, got an error, ORA-01950: no privileges on tablespace ‘USERS’. SQL> create table DBACLASS.EMPLO as select * from user_objects; create table EMPLO as select * from user_objects * ERROR at line 1: ORA-01950: no privileges on tablespace ‘USERS’ SOLUTION: This error comes, when the user the user doesn’t have tablespace […]

PROBLEM:   While applying patch to binary using opatch utility got below error. ZOP-51: The patch location is not valid for apply, because it doesn’t have correct metadata, or it points to a patch directory. Argument(s) Error… Patch location is not valid for apply Please check the arguments and try again. OPatch failed with error code […]