Find Oracle Control File Location

1. Login to your operating system and access your Oracle database.

> sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jul 19 11:00:19 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

2. You can get the location by executing any of below commands,

SQL> show parameter control_files ;

NAME          TYPE        VALUE
------------- ----------- ----------------------------------------
control_files string      /oracle/SID/origlogA/cntrl/cntrlSID.dbf,
                          /oracle/SID/origlogB/cntrl/cntrlSID.dbf,
                          /oracle/SID/sapdata1/cntrl/cntrlSID.dbf

SQL> select VALUE from V$PARAMETER where name='control_files' ;

VALUE
------------------------------------------------------------
/oracle/SID/origlogA/cntrl/cntrlSID.dbf,
/oracle/SID/origlogB/cntrl/cntrlSID.dbf,
/oracle/SID/sapdata1/cntrl/cntrlSID.dbf

SQL> select NAME from v$controlfile;

NAME
------------------------------------------
/oracle/SID/origlogA/cntrl/cntrlSID.dbf
/oracle/SID/origlogB/cntrl/cntrlSID.dbf
/oracle/SID/sapdata1/cntrl/cntrlSID.dbf