LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 09-18-2012, 02:46 PM   #1
mlnm
Member
 
Registered: Jun 2011
Posts: 96

Rep: Reputation: Disabled
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 oracleinstall /u01/

Thanks in Advance......
 
Old 09-18-2012, 02:57 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 19,003

Rep: Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333Reputation: 4333
Quote:
Originally Posted by mlnm View Post
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 oracleinstall /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
 
Old 09-18-2012, 09:31 PM   #3
mlnm
Member
 
Registered: Jun 2011
Posts: 96

Original Poster
Rep: Reputation: Disabled
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Oracle 11g R1 install on Oracle Enterprise Linux martymedina Linux - Newbie 4 10-27-2013 01:24 PM
[SOLVED] oracle 11g install - oracle user passwd- Authentication Token Maniperror cdhar Linux - Newbie 3 08-21-2012 09:48 PM
Oracle redhat6.1 x86 install Oracle 11g r2 error. reconcil Linux - Newbie 3 11-03-2011 10:11 AM
unable to connect to oracle in linux veeravicky Linux - Software 3 03-20-2010 08:29 AM
read the data from the text file which is located in remote machin to oracle databse marthesh Linux - Newbie 1 07-07-2008 07:05 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 04:30 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration