I'm new with Oracle DBA in my new office, and they gave me a development server that already have a lot SID database online in SuSe (I checked with
My questions are :
- How to check what SID instance that really live/online, because turns out when I checked again with
ps ax|grep ora, only 3 of databases live/online?
If only 3 SID databases that really online like in 1st question, how do I know where all the 3 SID the database file position that already live/online? what do I have to type to know it?
I try to login
sqlplus sys as sysdbawhen I checked with
select name from v$database;I was logging in 1 SID database. Continuing from 2nd question, How do I logout from current SID database and then switch to other 2 SID database?
(example in MongoDB, I type
use tutorialto enter tutorial database and type
use dbdevelopmentto switch to database dbdevelopment)