Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I successfully installed Oracle 11g R2 on my laptop for evaluation, by mixing various sources of documentation. I saw the Oracle daemons after installation. But I have a few problems :

  • After a reboot, the instance does not start, and does not even create a log file. (only the TNSLSNR starts).
  • The oracle user's ORACLE_SID gets a default value (AL32UTF8) where the value I set in the /etc/profile.d/oracle.sh initialisation script is INFO (created during install). Where does this come from?
  • Where can I start investigating?

Thanks for your help.

Note : Only one line not commented out in the /etc/oratab file :

INFO:/u01/app/oracle/product/11.2.0/dbhome_1:N

Best regards,

Fred

share|improve this question
    
Seems strange that the ORACLE_SID is AL32UTF8 - that is the character set... Is there an /etc/oratab file on your system? If so, edit your question with its contents. –  Phil May 19 '13 at 11:21
    
Well, understanding the content of this oratab file, my instance is not supposed to be started ! I modify it in order to allow the database to start ... –  user1185081 May 19 '13 at 15:59
add comment

1 Answer 1

up vote 1 down vote accepted

Edit your /etc/oratab file to read:

INFO:/u01/app/oracle/product/11.2.0/dbhome_1:Y

I guess it's just one of those things you need to know to look for!

share|improve this answer
    
Yes Phil, this is the solution here. Thanks for your help :-) –  user1185081 May 21 '13 at 18:54
    
Note : ORACLE_SID = AL32UTF8 is a default value set at install by OIU and used in the /home/oracle/.profile file. It was automatically initialised each time I was switching to oracle user typing "su - oracle". –  user1185081 May 21 '13 at 19:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.