TROUBLESHOOTING

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

NID-00120: Database should be mounted exclusively

PROBLEM: While trying to rename a RAC database using nid utility, got below error. NID-00120: Database should be mounted exclusively

SOLUTION: This error comes, when we keep the cluster_database parameter to TRUE. As a prerequisite for renaming RAC database, make sure cluster_database parameter is set to FALSE.

Now run the nid tool again. […]

NID-00120: Database should be mounted exclusively

PROBLEM: While renaming a RAC database using NID utility, got below error. NID-00120: Database should be mounted exclusively

SOLUTION: This error usually comes, when cluster_database parameter is set to TRUE.

So before running the NID tool, make this parameter FALSE. (if pfile is used change the cluster_database parameter , if spfile, then run […]

ORA-09925: Unable to create audit trail file

PROBLEM: Users are getting below error, while trying to connect to the database. ERROR: ORA-09925: Unable to create audit trail file Linux-ia64 Error: 28: No space left on device Additional information: 9925 ORA-01075: you are currently logged on SOLUTION: The error occurs , because the mount point where audit logs are written is filled. check […]

ORA-00257:archiver error, connect internal only until freed

PROBLEM: Application log shows below error and users are unable to connect to the database. 0RA-00257:archiver error, connect internal only until freed ORA-16014:log 1 sequence# 280 not archived, no available destinations ORA-00312:online log 1 thread 1:’/data/oradata/orcl/redo01.log’ SOLUTION: This error comes, when the archive destination is full and there is no space to accommodate new archivelogs. […]

ORA-01541: system tablespace cannot be brought offline; shut down if necessary

PROBLEM: DBA is planning to move the system database file to a new location, for which he tried to make the system tablespace offline. SQL> alter tablespace system offline; alter tablespace system offline * ERROR at line 1: ORA-01541: system tablespace cannot be brought offline; shut down if necessary SOLUTION: A system tablespace cann’t be […]

ORA-28017: The password file is in the legacy format

PROBLEM: While granting sysdba privilege to an user, got below error. SQL> grant sysdba to MONITUSER; * ERROR at line 1: ORA-28017: The password file is in the legacy format SOLUTION: Recently we upgraded our database from 11g to 12c. And It is an expected behaviour from 12.1.0.2 database release onwards. Check the format of […]

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