Re: EM database control issues
- From: Maureen English <maureen.english@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 18 Nov 2011 16:05:39 -0900
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@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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
