Creating Pluggable Database using OEM

Here in this article, I would demonstrate how we can create a new Pluggable Database using Oracle Enterprise Manager 13c.


1 - Login to the Oracle Enterprise Manager to go the Container Database target Home Page in which you want to create the new Pluggable Database.

2 - From the drop-down Menu of Cluster Database, Navigate to Provisioning > Provision Pluggable Databases.

3 - Create Pluggable Database : Creation Options page opens, Select "Create a new PDB" and provide oracle software owner credentials in the "Host Credentials" property. Click Next.

Click Next.

It validates the /tmp directory space on the nodes being provisioned.

You can schedule the provision date/time or you can just start the job right away with immediate option.

You can monitor the CreatePluggableDatabase job progress - Click on "View Execution Details" tab to monitor the progress.

Provisioning job's status now "Succeeded" and you are done with provisioning. You can validate the PDB status in OEM or by logging to the Container CDB at the host.







Hope it helps, thanks for reading, please subscribe to this blog to stay updated with latest news on Oracle Cloud Infrastructure and Oracle Autonomous Database Cloud Services and new articles.

Twitter : https://twitter.com/rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/
Facebook : https://www.facebook.com/rkushawaha

Creating Multiple PDBs in one Go using OEM

Here in this article, I would demonstrate the process steps to create multiple Pluggable Databases in just one Go using Oracle Enterprise Manager 13c.

1 - You need to make sure the underline Container Database is registered in the OEM and it is up.
2 - You need to have Oracle RDBMS software owner and password in hand.
3 - Get ASM diskgroup name handy from the ASM cluster running on the underline database server.




Let's now begin by logging into the OEM and go the Container Database target home page.

Click on the Target Home drop down option and navigate to "Provisioning" then click on "Provision Pluggable Databases"

Provision Pluggable Databases page opens > Select the option "Create New Pluggable Databases" and click on "Launch"

Select "Create a New PDB" option and provide named credentials for Oracle Software owner and its password. Click on Next.

Provide "PDB Name" that you want per the naming convention and Tick the "Create Multiple Copies" option to create the number of Pluggable Databases you want, provide PDB Administrator username/password. In my case, I am creating 5 pluggable database in one Go!

Click on Next.

Since my container database is using "+DATAC1" diskgroup for database files storage so it is selected already, click on Next.

It checks for /tmp directory location on the underline database server.

Click on Next.

Finally you can review the summary of "Create Pluggable Database" selections and click on "Submit" to start the job to create PDBs.

Click on "View Execution Details" tab to go to provisioning job details page to monitor the job steps progress.

Job is running >

Job is "Succedded" in just 11 minutes, 57 seconds - so five PDBs created this fast.

Now if you go back to Container Database home page then you would see there are 7 Pluggable databases now, earlier it was only 2.

Click on the "Pluggable Databases" to view the names of all PDBs and its target names:

You can see below, five Pluggable Databases are created per the naming convention we provided with one number incremental number appended to its name.

You can validate the same by logging into the SQLPLUS, using the SQL>show pdbs command, as below:

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDB1                           READ WRITE NO
         4 PDB2                           READ WRITE NO
         5 PDB_DEV2                       READ WRITE NO
         6 PDB_DEV3                       READ WRITE NO
         7 PDB_DEV4                       READ WRITE NO
         8 PDB_DEV5                       READ WRITE NO
        10 PDB_DEV1                       READ WRITE NO
SQL>







Hope it helps, subscribe to this blog to stay updated on latest Oracle Technologies and new articles.

Twitter : @rajsoft8899
Linkedin : https://www.linkedin.com/in/raj-kumar-kushwaha-5a289219/

Unable to Open Oracle 11g R2 OEM in Internet Explorer but works in Chrome

Today, when I entered in the office and tried to play with Oracle 11g R2 OEM then it didn't work in Internet Explorer while it was working in Google Chrome and after some investigation I came up with the following command:

C:\Windows\system32>certutil -setreg chain\EnableWeakSignatureFlags 8
Software\Microsoft\Cryptography\OID\EncodingType 0\CertDllCreateCertificateChainEngine\Config\EnableWeakSignatureFlags:

New Value:
  EnableWeakSignatureFlags REG_DWORD = 8
CertUtil: -setreg command completed successfully.
The CertSvc service may need to be restarted for changes to take effect.

C:\Windows\system32>

Finally, it worked great even on IE9.....!!

How to increase Oracle 11g OEM heap Size?

When we try to compare or synchronize data between two databases using OEM, OEM should have enough space required to perform well without any glitches. So in order to avoid Heap Size issue or to resolve Heap size issue yon can follow the following set of steps.

Run the following command to increase dbconsole heap size. You can define enough Heap Size value for the parameter -heap_size as per your requirement.

$ emctl config dbconsole -heap_size 512M

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://RAC-1:1158/em/console/aboutApplication
OMS heap size properties successfully added to emoms.properties file.

 The changes we made to increase the heap size will take effect after restarting the dbconsole.

$ emctl stop dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://RAC-1:1158/em/console/aboutApplication
The OracleDBConsoleorcl service is stopping...........

The OracleDBConsoleorcl service was stopped successfully.

 $ emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.
https://RAC-1:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...The OracleDBConsoleor
cl service is starting.....................

The OracleDBConsoleorcl service was started successfully.

 Hope it will help…………!!

Oracle 11g R2 EM Agent Unreachable

Usually Agent Unreachable status shown when agent is not running so first try to start the agent and wait for sometime that to be reflected in OEM or if  you have changed your hostname/IP or timezone of your oracle server then follow up the following steps.

1. emctl resetTZ agent

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Updating E:\app\Administrator\product\11.2.0\dbhome_1/rajkumar-pc_orcl/sysman/config/

emd.properties...

Successfully updated E:\app\Administrator\product\11.2.0\dbhome_1/rajkumar-pc_orcl/sy

sman/config/emd.properties.

2. Login as the em repository user and run the  script:

exec mgmt_target.set_agent_tzrgn('rajkumar-pc:3938','America/New_York')

and commit the changes

SQL> exec mgmt_target.set_agent_tzrgn('rajkumar-pc:3938','America/New_York')

SQL> commit

3. emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

https://rajkumar-pc:5500/em/console/aboutApplication

EM Daemon is not running.

------------------------------------------------------------------

Logs are generated in directory E:\app\Administrator\product\11.2.0\dbhome_1/COL-OR

A01_orcl/sysman/log

4. emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

https://rajkumar-pc:5500/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control ...The OracleDBConsoleor

cl service is starting...................

The OracleDBConsoleorcl service was started successfully.

Enjoy.............................

Manually Configure Oracle 11gR2 Enterprise Manager Database Control

Here I have outlined the steps to configure Oracle 11g R2 OEM manually:

C:\>emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Dec 10, 2011 11:45:23 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TESTDB
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 10, 2011 11:45:58 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\RAJKUMAR\cfgtoollogs\emca\TESTDB\emca_2011_12_10_23_45_22.log.
Dec 10, 2011 11:45:59 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Dec 10, 2011 11:46:08 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Dec 10, 2011 11:46:08 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 10, 2011 11:49:29 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 10, 2011 11:49:39 PM
C:\>emca -repos create
STARTED EMCA at Dec 10, 2011 11:50:48 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TESTDB
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:  s
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 10, 2011 11:51:08 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\RAJKUMAR\cfgtoollogs\emca\TESTDB\emca_2011_12_10_23_50_48.log.
Dec 10, 2011 11:51:08 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 11, 2011 12:00:57 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 11, 2011 12:00:57 AM


C:\>emca -config dbcontrol db
STARTED EMCA at Dec 11, 2011 12:06:01 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TESTDB
Listener port number: 1521
Listener ORACLE_HOME [ C:\app\RAJKUMAR\product\11.2.0\dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Invalid username/password.
Password for SYSMAN user:
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ C:\app\RAJKUMAR\product\11.2.0\dbhome_1
Local hostname ................ RAJKUMAR
Listener ORACLE_HOME ................ C:\app\RAJKUMAR\product\11.2.0\dbhome_1
Listener port number ................ 1521
Database SID ................ TESTDB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 11, 2011 12:06:43 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\RAJKUMAR\cfgtoollogs\emca\TESTDB\emca_2011_12_11_00_06_01.log.
Dec 11, 2011 12:07:01 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Dec 11, 2011 12:08:44 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Dec 11, 2011 12:09:08 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Dec 11, 2011 12:09:08 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Dec 11, 2011 12:10:23 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Dec 11, 2011 12:10:23 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Dec 11, 2011 12:10:52 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Dec 11, 2011 12:10:52 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Dec 11, 2011 12:12:38 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Dec 11, 2011 12:12:39 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://RAJKUMAR:1158/em <<<<<<<<<<<
Dec 11, 2011 12:12:43 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************
Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: C:/app/
RAJKUMAR/product/11.2.0/dbhome_1/RAJKUMAR_TESTDB/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusabl
e if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 11, 2011 12:12:44 AM

Hope it would help someone....