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