setting up the environment - profile for oracle database
Hi,
I am trying to set up the profile for user oracle, where when I login the profile gets loaded, with .oraenv, I select the database, and it sets all environmental variables, like ORACLE_BASE, ORACLE_HOME etc.
I started a new job, where this is not set. The way it is setup now, is for every database on the server, there is a separate XXXXX_profile file. The only difference in all those profile files is ORACLE_SID has a different database name.
I'd like to set it up in a way it is setup, everywhere else, to use one login, and change the database name through oraenv. When I do that, ORACLE_SID prompts for a SID name, and than I get another prompt for ORACLE_HOME. It should not prompt for ORACLE_HOME because it was already defined in the .profile file. If I provide the value for ORACLE_HOME, it works fine, but I want it to read it from profile not ask for it.