Database Administration (MOSC)

MOSC Banner

setting up the environment - profile for oracle database

edited Jul 11, 2014 6:35PM in Database Administration (MOSC) 2 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center