If we have 10 databases i.e Prod1 to Prod10 in a single server. If i want to connect to 10th database i.e Prod10 we do export ORACLE _SID=Prod10 sqlplus / sys as sysdba and then we startup the database. But in real time Production databases all will be up and running.
So how to connect to Database if i have 10 databases and all are up and running?
Kindly share your valuable views here.
Thanks in advance.