Search code examples
oracle11goracle12c

How to get current Oracle_SID from command prompt in windows server 2012 R2?

I use Windows server 2012 with Oracle 12c installed on it. I've configured multiple PDBs in a container and want to know what ORACLE_SID is currently in use. Is there any way to identify it from command prompt? or is there other way to identify it?

Solution

  • connect

    sqlplus

    and type below command,

    select name,open_mode from v$database;

    where name represent ORACLE_SID.