Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

make oracle_sid permanent

DBA_1976Mar 26 2010 — edited Mar 29 2010
Hi,
I am setting up a database. I have ORACLE_SID to prod. I made the change in /etc/oratab like this

prod:/app01/app/oracle/product/10.2.0:N

But still every time I open up a putty session, when I type sqlplus it says command not found. I have to set up the . oraenv every time. It will ask for the SID name and if I supply prod, it will automatically takes the ORACLE_HOME from the oratab. I want to make the SID also permanent. How?. For now this is the only instance that is going to be in this server.

Thank you.
This post has been answered by EdStevens on Mar 26 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2010
Added on Mar 26 2010
#general-database-discussions
15 comments
2,663 views