Home > IDERA ER/Studio TeamServer Database Creation – Oracle Edition – Pluggable Database – Part 1

IDERA ER/Studio TeamServer Database Creation – Oracle Edition – Pluggable Database – Part 1

Howdy!

In this short blog post, we shall explore on how to create a Pluggable database for our teamserver database

Here are the SQL*Plus commands to create a pluggable database (PDB) named “teamserver” for both Linux and Windows:

For Linux:

CREATE PLUGGABLE DATABASE teamserver ADMIN USER teamserver_admin IDENTIFIED BY password
FILE_NAME_CONVERT=('/path_to_data_files','/path_to_data_files')
PATH_PREFIX='/path_to_pdb_files';

 

For Windows:

CREATE PLUGGABLE DATABASE teamserver ADMIN USER teamserver_admin IDENTIFIED BY password
FILE_NAME_CONVERT=('C:\path_to_data_files','C:\path_to_data_files')
PATH_PREFIX='C:\path_to_pdb_files';

Replace /path_to_data_files and /path_to_pdb_files with the appropriate paths for your environment. Also, replace password with your desired password for the PDB admin user.

Execute these SQL commands using SQL*Plus connected as SYSDBA to create the “teamserver” PDB.

In the next series, we will reveal, the permissions and credentials needed to create the database ready for IDERA ER/Studio TeamServer Deployment

Aligning complex data environments with business goals for over 30 years.
Copyright © 2024 Idera, Inc.