Re: EM database control issues

From: Maureen English <>
Date: Fri, 18 Nov 2011 16:05:39 -0900
Message-ID: <>

It figures...*after* I sent this message, I figured out my problem.

I'm not too sure what I did, but after playing with EM a bit, I was able to start the database. I watched the messages in the alert log and saw that the database SID was different from what I was had an _1 added to it.

When I used set my ORACLE_SID to the other value, I was able to connect via sqlplus.

I think it's time for a vacation....

  • Maureen

Maureen English wrote:
> I'm having trouble stopping and starting a new database, both manually
> and with Enterprise
> Manager Database Control.
> We have a 4 node linux system with the Grid Infrastructure installed and
> we're using ASM. I
> installed the RAC One Node rdbms software and then created a RAC One
> Node database yesterday,
> but I'm unable to connect to it from the local machine unless I use
> sqlplus myid_at_DBID instead
> of just sqlplus myid. This is true even when I'm connected as oracle.
> I was able to shutdown the database manually, but now I can't start it
> up. I get the following
> error:

>> SQL> startup
>> ORA-01078: failure in processing system parameters
>> LRM-00109: could not open parameter file 
>> '/u01/app/oracle/product/rel112020/dbs/initDBA1.ora'

> I'm sure this has something to do with the spfile being stored
> differently with ASM.
> When I try to use Enterprise Manager Database Control to stop or start
> the database, I get errors
> that I don't have permission to do this. The files I don't have
> permission on are owned by oracle,
> with no group or other privileges. I'm logging in to my own account
> from EM, not the oracle account,
> since I don't have the password for the oracle account. My id belongs
> to the same groups as the
> oracle user, but that doesn't help when the files have no group
> permissions.
> I know I'm missing something, but I'm not completely sure what that is,
> maybe environment variables....
> I've been reading through the ASM and RAC and Database Administrator
> manuals, but nothing I've found
> yet seems to resolve my problem(s).
> Any suggestions?
> - Maureen
Received on Fri Nov 18 2011 - 19:05:39 CST

Original text of this message