help to create multiple instances in Solaris.

[manasa]

I have to create 3 instances in anew solaris server. I have installled Oracle 9iR2 and ready to create instances.

I have set the .profile for Oracle user and should i need to create 3 profiles for 3 instances or just with one. If so how can iset 3 oracle sid's in one .profile file?

Also when i login as Oracle every time i am executing the profile manually after login. How to set this automatic so that when i login as Oracle user all the profile, shell and env's are set.

Thanks

[davey23uk]

it depends on what shell you are using as to what file you change.

Also dont put the ORACLE_SID in the profile, use the oraenv utility else you will get into difficulties

[manasa]

I am using bash shell and could you elaborate how to set oraenv. Is that different from .profile?

I have set all the oracle related env setting in .profile. Is that right to do?

Thanks

[davey23uk]

.profile is fo rthe k shell, you want .bash_profile

[KenCunningham]

Use oraenv to be sure your settings are correct:

. oraenv (note the space between . and oraenv)

At the prompt, type the SID you wish to use.