Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. 3. PDB1 and PDB2 are OPEN in READ WRITE mode. You execute these commands successfully: Which two are true? (Choose two.)
A.
Uncommitted transactions in PDB1 have been rolled back.
B.
PDB1 is closed.
C.
Uncommitted transactions in CDB1 and PDB1 have been rolled back.
SQL> alter session set container=PDBDEV;
Session altered.
SQL> shutdown immediate;
ORA-01097: cannot shutdown while in a transaction - commit or rollback first
SQL> rollback;
Rollback complete.
SQL> shutdown immediate;
Pluggable Database closed.
SQL> exit
PDB1 will be in mounted mode actually:
SQL> show con_name;
CON_NAME
------------------------------
PDB1
SQL> shutdown immediate;
Pluggable Database closed.
SQL> alter session set container=cdb$root;
Session altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 MOUNTED
With 19c it does not let you shutdown immediate and says : SQL> shutdown immediate
ORA-01097: cannot shutdown while in a transaction - commit or rollback first
https://www.oracletutorial.com/oracle-administration/oracle-shutdown/
During the SHUTDOWN IMMEDIATE, all the connected sessions are disconnected immediately, all uncommitted transactions are rolled back, and the database completely shuts down.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
taotsumiau
Highly Voted 4 years, 7 months agoyou1234
Highly Voted 4 years, 6 months agocujar2003
Most Recent 2 months agopitt84
3 months ago[Removed]
8 months, 2 weeks agogedde
10 months, 2 weeks agokaka321
1 year, 6 months agoGuhborges
1 year, 6 months agoBlob44
1 year, 6 months agoScottL
1 year, 8 months ago_gio_
1 year, 8 months agojackymak
2 years, 1 month agoTrololoshko
2 years, 3 months agonobody347
3 years, 5 months agopgtips
4 years, 4 months agojanw
4 years, 5 months agoCyborgQ
4 years, 5 months ago