1

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

Improve this question
2
  • 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, 2013 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, 2013 at 15:59

1 Answer 1

Reset to default
1

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!

Improve this answer
1
  • 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, 2013 at 19:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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