This content has been marked as final. Show 5 replies
you are not connected to a database, just to an ASM instance.
The main difference (besides a lot others, like other processes etc.) between an ASM instance and a normal database instance is that an ASM instance does not have and need any controlfiles/datafiles/redologfiles etc.
So all you can do with an ASM instance is manage storage.
Thanks for your reply, actually i want make my RAC db up,i logged as sysdba but when execute startup command, i am getting the following error.
[oracle@server ~]$ sqlplus '/ as sysdba' @ db
SQL*Plus: Release 18.104.22.168.0 Production on Thu Mar 10 16:50:21 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SP2-0310: unable to open file "db.sql"
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'DATA/sunil/spfilesunil.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
I am not sure, why it is poiting some other spfile, even though i mentioned instance specifically.what could be the reason?