Setting up Pluggable Database for IDERA ER/Studio Repository

Howdy! all,

In today's blog, we will be exploring on how to create a pluggable database and grant it the required permissions to create the IDERA ER/Studio Repository. These steps are identical for the Professional and Team Server Editions.

We will be covering version 19c for this example.

[Windows]

Connecting to an Oracle Container Database (CDB) involves using SQLPlus or another database client. Here’s an example of how to connect to the root container (CDB$ROOT) using SQLPlus:

Open a Command Prompt:

Navigate to the Oracle Home Directory:

Change directory to the Oracle Home where SQL*Plus is located. Replace <oracle_home> with the actual path to your Oracle Home.

Connect to the Root Container (CDB$ROOT):

Use the following command to connect as the SYS user:

You’ll be prompted for the SYS password. Enter the password associated with the SYS user.

Connected to CDB$ROOT:

Once connected, you’ll see the SQL*Plus prompt. You are now connected to the root container (CDB$ROOT) of the multitenant database.

Remember to replace <oracle_home> with the actual path to your Oracle Home.

[Oracle Linux]

Connecting to an Oracle Container Database (CDB) in Oracle Linux involves using SQLPlus or another database client. Here’s an example of how to connect to the root container (CDB$ROOT) using SQLPlus:

1. Open a Terminal:

2. Navigate to the Oracle Home Directory:

3. Connect to the Root Container (CDB$ROOT):

4. Connected to CDB$ROOT:

5. Find Service Names:

Create a Pluggable Database - Windows

Please replace the path locations to suit your environment.

Create a Pluggable Database - Oracle Linux

Please replace the path locations to suit your environment.

Connecting to your PDB(Pluggable Database) - Windows and Linux

now go ahead and create the following user erstudio with a strong password and permissions needed.

Tablespace Size

Alter TableSpace Size upon user creation - Linux shown here

Windows example

And now verify that you can connect to the PDB and you should be all set!

Congratulations!! you have successfully!

Holler if you have any questions!

#Oracle #PDB #PluggableDatabase #Repository #IDERA