I wanna do the following senario and i need your advice to how to do that
I have oracle 10.1.0.5.0 on linux OS.
i want to create 3 oracle instance manually like this
i prepare the scripts for each instance to create them.
i want to use the .bash_profile for all the 3 instances but i dont know how to do that because when i am doing export oracle_sid, i dont know which one and how to solve this conflict.
i have the following directories
i have only one user called oracle and it is the owner for the DB
I prepared the directories for each instanc like that:
and other directories in /data/oradata/
i know in by using oracle assistance, i can create many database and the wizards will take care of everything for me, in matter of fact i did that in windows server for testing purpose, but the problem now is i am trying to create them manually and i have to set up the environment and everything manually, you know what i mean
so what should i do?
should i just lunch the create database statement for each instance and it will update the environment or what
can you provide me with the right steps for doing the whole scenario?
please i need your help
Thank you .