its been very useful. 0. sqlplus connection to 11g DB. The steps to upgrade from the version 11.2.0.2 are very … Dropping connected users in Oracle database. We all know that besides some interesting performance issues, recovery issues or RCA in a Cluster env. SYS @ PDB1 > SYS @ PDB1 > show con_name CON_NAME ----- PDB1 SYS @ PDB1 > Caution : Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. Login to EM Express for CDB2 … Continue reading Configure OEM Express 12c → Verify OEM Express already configured or not 3. 0. Hi Tom, just came to know this place for oracle doubts and clarifications, a few days ago. Verify OEM Express already configured or not for PDB4 4. Enable Oracle Enterprise Manager Express 12c Goal: Configure OEM Express for both CDB (CDB2) and PDB (PDB4) 0. Configure OEM Express for CDB (HTTPs & HTTP) 5. The login.sql way for sqlprompt was obvious but i woul like to kno can we have any trigger which will give me sqlprompt when i connect to some other user or database. Environment 1. Introduction 2. Home. Stack Overflow Public questions and answers; ... show con_name command returns SP2-0158: ... How to create a new database after initally installing oracle database 11g Express Edition? … DBA job is pretty much concise to a set of basic tasks AND A HELL LOT OF READING.In this post I’ll try to cover Basic DBA commands to manage a PDB and CDB in Oracle 12c so that we can at least be aware of the syntactic changes in 12c. Oracle DBA – A Helping Hand Rajeev Kumar Jha – Domain Head Oracle (OCP 9i, 10g, 11g, 12c & Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator) Menu. In this article we will upgrade a database running on Oracle RAC version 11.2.0.1 to version 11.2.0.3. 47.