Oracle Database Discussions

Oracle10gR2 OEL4 64bit non-RAC with ASM

Hi All,

I am trying to upgrade our database to 11g and I am getting the following error when I try to start the database with the STARTUP UPGRADE command. I am doing a manual upgrade and following the Upgrade guide:


SQL> startup upgrade pfile='/opt/app/oracle/product/11.1.0/db_1/dbs/initFPRCTEMP.ora';
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size 2151248 bytes
Variable Size 2617248944 bytes
Database Buffers 1644167168 bytes
Redo Buffers 12214272 bytes
ORA-00205: error in identifying control file, check alert log for more info

When I checked the alertlog I found the following:

ORA-00210: cannot open the specified control file
ORA-00202: control file: '+FLASH1/fprctemp/controlfile/ctrl02_fprctemp.ctl'
*ORA-17503: ksfdopn:2 Failed to open file +FLASH1/fprctemp/controlfile/ctrl02_fprctemp.ctl*
ORA-15001: diskgroup "FLASH1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-00210: cannot open the specified control file
ORA-00202: control file: '+DATA1/fprctemp/controlfile/ctrl01_fprctemp.ctl'
*ORA-17503: ksfdopn:2 Failed to open file +DATA1/fprctemp/controlfile/ctrl01_fprctemp.ctl*
ORA-15001: diskgroup "DATA1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
Thu Aug 28 14:54:49 2008
Checker run found 2 new persistent data failures
ORA-205 signalled during: ALTER DATABASE MOUNT...


What's weird is that I checked and the ASM instance is up and running. I checked all the environment variables ( set PATH and ORACLE_HOME to new 11g home) and I also set the oratab entry to point to the new Oracle Home as the documentation says. Below are my entries from the .bash_profile file and the oratab file.

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

stty erase ^H

ORACLE_BASE=/opt/app/oracle
ORA_HTTP_HOME=/opt/app/oracle/product/10.2.0/http_1
ORACLE_HOME=/opt/app/oracle/product/11.1.0/db_1
ORACLE_ASM_HOME=/opt/app/oracle/product/10.2.0/asm_1
ORACLE_SID=FPRCTEMP
ORA_NLS10=$ORACLE_BASE/product/10.2.0/db_1/nls/data
TNS_ADMIN=$ORACLE_BASE/product/10.2.0/db_1/network/admin
LD_LIBRARY_PATH=$ORACLE_BASE/product/11.1.0/db_1/lib:$ORACLE_BASE/product/10.2.0/http_1/lib
TEMP=/tmp

export ORA_HTTP_HOME
export ORACLE_SID
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_ASM_HOME
export ORA_NLS10
export TNS_ADMIN
export LD_LIBRARY_PATH
export TMP
export TEMP

unset USERNAME

PATH=$PATH:$HOME/BIN:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORA_HTTP_HOME/opmn/bin:$LD_LIBRARY_PATH

export PATH
umask 022
unset USERNAME


oratab file entry:

*:/opt/app/oracle/product/10.2.0/http_1:N
+ASM:/opt/app/oracle/product/10.2.0/asm_1:Y
FPRCTEMP:/opt/app/oracle/product/11.1.0/db_1:Y


Thank you all.