TROUBLESHOOTING

ORA-30034: Undo tablespace cannot be specified as temporary tablespace

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 […]

ORA-32771: cannot add file to bigfile tablespace

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 […]

ORA-32774: more than one file was specified for bigfile tablespace

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 […]

ORA-32773: operation not supported for smallfile tablespace

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 […]

ORA-01536: space quota exceeded for tablespace

PROBLEM: While creating a table or inserting data, user is getting error ORA-01536: space quota exceeded for tablespace .

SOLUTION: Tablespace quota is the storage allocated for an user in a tablespace. Once the user reaches the max allocated space it will throw error like this.

Here DBACLASS user can use maximum upto […]

ORA-02304: invalid object identifier literal while import with CREATE TYPE OID

 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 […]

TNS-12542: TNS:address already in use

PROBLEM: While starting the listener, getting an error like TNS-12542: TNS:address already in use

SOLUTION: To find out the issue, Let’s check the content of the listener in listener.ora file.

Inside the listener entry, we have 2 ADDRESS entries with same host and same port number(1524) . So starting the listener is failing […]

TNS-01106: Listener using listener name has already been started

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)

We are trying to start LISTENER_TEST, However, the error we […]

ORA-01950: no privileges on tablespace ‘USERS’

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 […]

ZOP-51: The patch location is not valid for apply

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 […]

Page 1 of 1512345...10...Last »
Skip to toolbar