ORA-00205: ERROR IN IDENTIFYING CONTROL FILE

Syed Saad April 13, 2017 APPS DBA, Errors/Workarounds-Applications Leave a comment 677 Views

ERROR

Error in Alertlog file:

ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Thu Mar 12 10:15:15 2015
alter database mount
ORA-00210: cannot open the specified control file
ORA-00202: control file: ‘/u01/apps/db/apps_st/data/cntrl03.dbf’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory

 

 

SOLUTION

set the ORACLE_BASE, also verify SID and ORACLE_HOME are set it correctly.

export ORACLE_BASE=/u01/apps

About Syed Saad

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

EBS_Latest_Configurations

Apply EBS AD-TXK Release 16 Update

Step By Step Guide to Apply Oracle E-Business Suite R12.2 ADTXK Update 16 Oracle Applications …

Leave a Reply

Powered by OracleSolutions | Designed by
© Copyright 2024, https://oraclesolutions.pk All Rights Reserved