LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   unable to connect to oracle 11g databse (https://www.linuxquestions.org/questions/linux-newbie-8/unable-to-connect-to-oracle-11g-databse-4175427880/)

mlnm 09-18-2012 02:46 PM

unable to connect to oracle 11g databse
 
Dear friends,
I have installed oracle 11g enterprise on RHEL5.Installation was successful.
Im tried to connect to database using sys as sysdba with sqlplus but it returns this error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORCL.ora'

I tried to connect to other databases as well but i getting similar error.
Installation details:
Oracle edition: Oracle 11g enterprise
Operating system : RHEL 5
My groups dba,oninstall,oper
User : oracle
ORACLE_BASE:/u01/app/oracle
ORACLE_HOME:$ORACLE_BASE/product/11.2.0/dbhome_1
ORACLE_SID=orcl
i given permissions as:
chmod -R 0755 /u01/
chown -R oracle:oinstall /u01/

Thanks in Advance......

TB0ne 09-18-2012 02:57 PM

Quote:

Originally Posted by mlnm (Post 4783579)
Dear friends,
I have installed oracle 11g enterprise on RHEL5.Installation was successful.
Im tried to connect to database using sys as sysdba with sqlplus but it returns this error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORCL.ora'

I tried to connect to other databases as well but i getting similar error.
Installation details:
Oracle edition: Oracle 11g enterprise
Operating system : RHEL 5
My groups dba,oninstall,oper
User : oracle
ORACLE_BASE:/u01/app/oracle
ORACLE_HOME:$ORACLE_BASE/product/11.2.0/dbhome_1
ORACLE_SID=orcl
i given permissions as:
chmod -R 0755 /u01/
chown -R oracle:oinstall /u01/

Thanks in Advance......

And did you attempt to put those errors into Google, or look them up in Oracle's knowledgebase? It's telling you very plainly that the file doesn't exist. So...either create it, modify the location, or restore it from backup:
http://www.dba-oracle.com/t_ora_0107...eters_tips.htm
https://forums.oracle.com/forums/thr...hreadID=671286
http://www.dba-oracle.com/bk_lrm_001...ile_string.htm
http://www.dba-oracle.com/oracle_tips_db_copy.htm

mlnm 09-18-2012 09:31 PM

yes,i googled it,the file was there and directory have permissions and selinux was also disabled,but some folders were missing in ORACLE_BASE and i created them,that solved my issue.Thank you so much for your reply......much appreciated.


All times are GMT -5. The time now is 06:21 AM.