I can not start oracle using "startup " command
847022Mar 13 2011 — edited Mar 14 2011I installed the oracle 11g software on linux red hat, then i connect using “sqlplus / as sysdba”
but when I type “startup” on SQL prompt it gives the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file'/oraeng/app/oracle/product/11.1.0/dbs/initorcl.ora'
I tried: export ORACLE_SID=orcl
But it gives the same error.
Then i checked the directory “dbs” but could not find the pfile:initorcl.ora,
however there was a file named “init.ora” only. I remember that in bash_profile I set the ORACLE_SID as “orcl”
Then i searched the web and tried the following command to set the pfile
SQL> startup pfile=/oraeng/app/oracle/product/11.1.0/dbs/init.ora
but it gave me following error
ORA-00371: not enough shared pool memory, should be at least 102341017 bytes
Could anyone please help me identify the problem? why i could not start it using start it in SQL prompt.
Thanks in advance
AZ