Grid Infrastructure
srvctl status database -d $ORACLE_UNQNAME -v
In OCI database services, the ORACLE_UNQNAME parameter tends to be set by default. For on-premise databases using GI you might choose to set it in your .profile based on the value of the DB_UNIQUE_NAME database parameter.
Instance MYSID is running on node myhostname. Instance status: Open.
srvctl getenv database -d $ORACLE_UNQNAME
In OCI database services, the ORACLE_UNQNAME parameter tends to be set by default. For on-premise databases using GI you might choose to set it in your .profile based on the value of the DB_UNIQUE_NAME database parameter.
mydbunqname:ORACLE_UNQNAME=mydbunqnameTZ=UTC
srvctl config database -d $ORACLE_UNQNAME
In OCI database services, the ORACLE_UNQNAME parameter tends to be set by default. For on-premise databases using GI you might choose to set it in your .profile based on the value of the DB_UNIQUE_NAME database parameter.
Database unique name: mydbunqnameDatabase name: MYSIDOracle home: /u01/app/oracle/product/18.0.0.0/dbhome_1Oracle user: oracleSpfile: +DATA/MYDBUNQNAME/PARAMETERFILE/spfile.269.1030197305Password file:Domain: testsubnetfdata.vcnmyvcnname.oraclevcn.comStart options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools:Disk Groups: RECO,DATAMount point paths:Services:Type: SINGLEOSDBA group: dbaOSOPER group: dbaoperDatabase instance: MYYSIDConfigured nodes: myhostnameCSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services:Database is administrator managed