Oracle RAC instance startup - ORA-29760

Having worked on Oracle RAC since 9i, there hasn't been a time when I haven't faced something new or realized something was not what I thought it was. I think this is one of the reasons why I enjoy working on these systems - always a challenge.
I stopped my RAC database to put it into noarchivelog mode using the srvctl command
[oracle@oradba10t oracle]$ srvctl stop database -d labrac

Next I proceeded to connect to the first instance to startup in mount mode
[oracle@oradba10t oracle]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 5 09:47:15 2011
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORA-29760: instance_number parameter not specified

Wait, what's this? I've never encountered this error message before. Googled a bit and realized that most of the responses were a bit far fetched since the database had been in perfect working order before I stopped it.
Then I realized that my ORACLE_SID was set to the database name and not the instance name. Makes sense.

[oracle@oradba10t oracle]$ echo $ORACLE_SID
labrac

Set the ORACLE_SID to the instance name and startup again
[oracle@oradba10t oracle]$ export ORACLE_SID=labrac1
[oracle@oradba10t oracle]$ sqlplus /nolog              
SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 5 09:50:42 2011
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1207959552 bytes
Fixed Size                  2083632 bytes
Variable Size             905970896 bytes
Database Buffers          285212672 bytes
Redo Buffers               14692352 bytes
Database mounted.

That's all there is to it. The correct solution would be to put the environment variables in the .profile of .bash_profile of the oracle user. This is one of my lab environments and I hadn't put the usual scripts in place to take care of the environment variables for RAC.


Comments

Post a Comment

Popular posts from this blog

Setup a Wordpress site in 10 Minutes using Oracle Container Cloud Service

Image
Oracle Container Cloud Service Oracle Container Cloud Service lets you easily deploy applications based on docker images. If you don't have an existing application you can create one on docker. However, the easiest method to get a full application up and running is by deploying a stack. Oracle Container Cloud Service provides several example stacks that you can deploy, including web servers based on NGINX or Apache, MongoDB database, and Wordpress. You can find more examples on Oracle GitHub Site . Let's see just how easy it is to spin up a Wordpress site using the Oracle Container Cloud Service. Prerequisites: Access to Oracle Cloud Account Subscription to Oracle IaaS Service First, go to the Oracle Container Cloud Service console and launch a new service. In this example, I created a service with three containers. One manager and two worker nodes. Choose an appropriate "shape" for your compute instances. Note: Oracle uses the term "shape" to r...
Read more

Oracle Home Cloning: Tools and Techniques

One of the many necessary and frequent tasks that a database administrator performs before creating a database is installing the Oracle database binaries. These binaries form what is known as an Oracle Home (referenced by the ORACLE_HOME environment variable on Linux and UNIX environments). Unfortunately, this is also one of the most mundane and uninteresting tasks a DBA can perform. So like all good DBAs know, the best way to deal with such repetitive task is to automate it. Automating installations of Oracle database binaries enables us to reliably repeat the process to enable faster installation as well as provide identical copies of the software in multiple environments. Fortunately, Oracle allows us to clone the Oracle database binaries from one environment to another. Cloning your Oracle binaries from a source copy with all the necessary patches applied enables us to have gold images which can then be deployed to multiple environments. The procedure for cloning an Oracle home...
Read more

Using XFS on Oracle Linux

Install xfs packages on Oracle Linux 6.6 via Oracle Public Yum [root@matthew ~]# yum install xfsprogs Loaded plugins: refresh-packagekit Setting up Install Process public_ol6_UEKR3_latest | 1.2 kB 00:00 public_ol6_UEK_latest | 1.2 kB 00:00 public_ol6_UEK_latest/primary | 19 MB 00:02 public_ol6_UEK_latest 407/407 public_ol6_addons | 1.2 kB 00:00 public_ol6_addons/primary | 77 kB 00:00 public_ol6_addons 269/269 public_ol6_latest | 1.4 kB 00:00 public_ol6_latest/primary | 46 MB 00:05 public_ol6_latest 29302/29302 http://public-yum.oracle.com/beta/repo/OracleLinux/OL6/uek3/x86_64/repodata/repomd.xml: [Errno 14] PYCURL ERROR 22 - "The requested URL returned error: 404 Not Found" Trying other mirror. Resolving Dependencies --> Running transaction check ---> Package xfsprogs.x86_64 0:3.1.11-1.0.5.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================...
Read more