PROBLEM: While trying to rename a RAC database using nid utility, got below error. NID-00120: Database should be mounted exclusively nid target=sys/oracle dbname=PRODPREDM DBNEWID: Release 12.1.0.2.0 – Production on Sun Jul 1 22:56:53 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to database PRODMPD (DBID=678234706) NID-00120: Database should be mounted […]

PROBLEM: While renaming a RAC database using NID utility, got below error. NID-00120: Database should be mounted exclusively nid target=sys/oracle dbname=DEVDB DBNEWID: Release 12.1.0.2.0 – Production on Sun Jul 1 22:56:53 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to database PRODDB (DBID=678234706) NID-00120: Database should be mounted exclusively Change […]

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

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

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

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

While granting SYSDBA role to a database user, got below error. SQL> grant sysdba to DEV_DB; grant sysdba to DEV_DB * ERROR at line 1: ORA-01994: GRANT failed: password file missing or disabled SOLUTION: This error says, that the password file is not present for the database, which is used for authenticating SYSDBA users remotely. […]

PROBLEM: While decreasing length of a column using alter statement, got below error. SQL> alter table dbatab modify ( dbaname varchar2(5)); alter table dbatab modify ( dbaname varchar2(5)) * ERROR at line 1: ORA-01441: cannot decrease column length because some value is too big SOLUTION: Attempt to reduce length of a column which contains data, […]

While querying a view, got below error: SQL> select * from DBA_SYN; select * from DBA_SYN * ERROR at line 1: ORA-00980: synonym translation is no longer valid SOLUTION: This error indicates that synonym is invalid , which is likely due to invalid dependent objects. Lets check this below scenarios: 1. Create a public synonym […]

PROBLEM: We have received below error in the alert log. 2017-12-07 08:01:24.890000 +03:00 Errors in file /oradbtrace/diag/rdbms/prodid2/trace/prodid2_m001_3322.trc: ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 0 allocated ANALYSIS AND SOLUTION: Lets check the trace file /oradbtrace/diag/rdbms/prodid2/trace/prodid2_m001_3322.trc. Trace file /oradbtrace/diag/rdbms/prodid2/trace/prodid2_m001_101138.trc Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production With the Partitioning, […]