Re: EM database control issues

From: Maureen English <maureen.english_at_alaska.edu>
Date: Fri, 18 Nov 2011 16:05:39 -0900
Message-ID: <4EC700E3.4060101_at_alaska.edu>

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 using...it 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
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 18 2011 - 19:05:39 CST