Some, many, most professional DBAs maintain their own database specific configuration files; like DEV.env, QA.env, PROD.env, DWH.env, etc. & source in the desired file prior to initiating activity against the specific database.

I'd agree with the "some" and even perhaps the "many". Not so sure about the "most". Maybe I'm in the vast minority and don't know it (who really is in a position to know for sure?)but I just rely on oraenv. Not sure of the advantage, if any, of a series of custom scripts when oracle has already provided a good one.

That said, I do have a series of 'env' scripts to be executed at the command line on my one pair (prod and test) of Windows boxes.

Quote:

Depending upon .bash_profile to establish Oracle environment is amateurish at best.

Realize that .bash_profile is only executed when you actually LOGIN to the OS; not when you open a new Terminal window.
You can observe this behavior by inspect the contents of /tmp/login_capture.txt any time you get curious about its content.
Some, many, most professional DBAs maintain their own database specific configuration files; like DEV.env, QA.env, PROD.env, DWH.env, etc. & source in the desired file prior to initiating activity against the specific database.
Depending upon .bash_profile to establish Oracle environment is amateurish at best.]]>BlackSwan2015-06-19T23:17:50-00:00Re: # .bash_profile of linux serverhttp://www.orafaq.com/forum/./mv/msg/197657/638748/#msg_638748
]]>krish962015-06-19T13:23:38-00:00Re: # .bash_profile of linux serverhttp://www.orafaq.com/forum/./mv/msg/197657/638747/#msg_638747
gazzag wrote on Fri, 19 June 2015 06:15

Lousy memory

So if I answered you today, you would post same question again next week.
So not worth my effort to do more.
]]>BlackSwan2015-06-19T13:20:41-00:00Re: # .bash_profile of linux serverhttp://www.orafaq.com/forum/./mv/msg/197657/638746/#msg_638746
krish962015-06-19T13:17:14-00:00Re: # .bash_profile of linux serverhttp://www.orafaq.com/forum/./mv/msg/197657/638745/#msg_638745
krish962015-06-19T13:16:53-00:00Re: # .bash_profile of linux serverhttp://www.orafaq.com/forum/./mv/msg/197657/638744/#msg_638744
]]>gazzag2015-06-19T13:15:16-00:00Re: # .bash_profile of linux serverhttp://www.orafaq.com/forum/./mv/msg/197657/638743/#msg_638743
http://www.orafaq.com/forum/m/638330/#msg_638330]]>BlackSwan2015-06-19T13:13:32-00:00Re: .bash_profilehttp://www.orafaq.com/forum/./mv/msg/197657/638330/#msg_638330
This question bears no real connection with Oracle database.
Please find a more appropriate forum.
The topic is locked.
If I'm wrong, please, PM me (or report this message to a moderator, explain why you think it should be unlocked and it might be done).

]]>Michel Cadot2015-06-09T14:57:08-00:00.bash_profilehttp://www.orafaq.com/forum/./mv/msg/197657/638327/#msg_638327
Is there a way to automatically execute .bash_profile or propmts for setting evironment variables after you login into server, Instead of running executing .bash_profile manually everytime you login to server..