yes to all your question
you can have more than one oracle db software on server.
in your case, i will suggest that you use one oracle db software.
Note that RAC is just an oracle db software Option. you can use the same oracle db software binaries for both RAC and non-RAC DB.
dbca oracle utility give you the option of either creating RAC DB or Standalone DB(non-RAC). dbca also allow you to specifies database files path(control files,datafiles etc)
for your data gaurd configuration, the above statement apply.
you can use different OS user.BUT not that you must have similar database password files for you primary and standby DB.
Caution: it not advisable to put the primary DB and standby DB files on the same file system/Storage. \
Thanks for answering as soon.
I have some more questions.
1.- Then in the second RAC we can create a dataguard without this in RAC but executing it in the same Oracle_home to the databases in RAC. With the option of the dbca we create a database in a single node of the RAC.
The database is created as a service of RAC on a single node, and is protected with Oracle Clusterware or, on the contrary is created as a normal instance on the node that we tell.
2.- We can have more than one ASM instance on the server, I think we can only have one.
I have read this article which indicates that there can be only one ASM instance
Thank you for your help.
you are welcome.
1.you can create dataguard without RAC. you can have RAC database instance in node1 and node2. you can also create a standalone DB instance(can be standby DB in data guard) in node2.
with dbca option(there are other method, but the dbca easiest because of GUI) you can create a database in a single mode of the RAC.
it registered with oracle clusterware. But it can be remove from clusterware registry/configuration. and standalone DB instance will behave as if you do not have clusterware software on the node.
e.g. srvctl remove database -d testdb
if you are cloning a database e.g. for data guard. the database will not be registered with oracle clusterware.
2. we can only have ONE asm instance per server/node. One ASM is enough to serves all your database instances. remember ASM is oracle way of implementing LVM.
Thank you for everything, i was very clear.
In the end, we are going to create MAA, the scenario would be RAC production and in the RAC preproduction put the development instance, another of preproduction and another for the active data guard.
Another issue we can have in the RAC Site secondary of dataguard other instances that are not in the primary site.
Thank you very much