PDB_To display the main Container name

 ### To display the main Container name.

SQL> show con_name;

CON_NAME

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

CDB$ROOT

SQL>

### To display the All the Container names which is under CDB ROOT Folder.

SQL> show pdbs;

    CON_ID     CON_NAME    OPEN MODE  RESTRICTED

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

         2     PDB$SEED                      READ ONLY      NO

         3     PDBPRIM                        READ WRITE     NO

         4     PDBPRIM2                      READ WRITE     NO

SQL>

### To open Pluggable Database folder ( SUB Container name = PDBPRIM).

SQL> alter session set container=PDBPRIM;

Session altered.

### To display the main Container name.

SQL> show con_name;

CON_NAME

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

PDBPRIM

SQL>

### To display the All the Container names which is under PDBPRIM Folder.

SQL> show pdbs

    CON_ID     CON_NAME          OPEN MODE      RESTRICTED

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

         3             PDBPRIM               READ WRITE     NO

### To SUTDOWN the Pluggable database PDBPRIM from READ WRITE to MOUNTED Status.

SQL> shutdown immediate;

Pluggable Database closed.

SQL> show pdbs;

    CON_ID     CON_NAME         OPEN MODE      RESTRICTED

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

         3             PDBPRIM              MOUNTED

## To start the Pluggable DB, The Mode will be changed from MOUNTED WRITE to READ WRITE YES

SQL> startup open restrict

Pluggable Database opened.

SQL> show con_name;

CON_NAME

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

PDBPRIM

SQL> show pdbs;

    CON_ID     CON_NAME        OPEN MODE      RESTRICTED

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

         3             PDBPRIM             READ WRITE     YES

### To open Pluggable Database folder ( SUB Container name = PDBPRIM2).

SQL> alter session set container=PDBPRIM2;

Session altered.

SQL> show con_name;

CON_NAME

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

PDBPRIM2

SQL> show pdbs;

    CON_ID     CON_NAME        OPEN MODE        RESTRICTED

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

         4             PDBPRIM2            READ WRITE         NO

SQL> shutdown immediate;

Pluggable Database closed.

## Once shutdown the Pluggable DB, The Mode will be changed from READ WRITE to MOUNTED

SQL> show pdbs;

    CON_ID CON_NAME              OPEN MODE      RESTRICTED

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

         4 PDBPRIM2                           MOUNTED

## To start the Pluggable DB, The Mode will be changed from MOUNTED WRITE to READ WRITE YES

SQL> startup open restrict

Pluggable Database opened.

SQL> show con_name;

CON_NAME

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

PDBPRIM2

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         4 PDBPRIM2                       READ WRITE YES

## To Rename the pluggable database PDBPRIM2 to PDBPRIM3

SQL> alter pluggable database PDBPRIM2 rename global_name to PDBPRIM3;

Pluggable database altered.

SQL> show con_name;

CON_NAME

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

PDBPRIM3

SQL> show pdbs;

    CON_ID CON_NAME              OPEN MODE      RESTRICTED

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

         4 PDBPRIM3                           READ WRITE YES

SQL> shutdown immediate;

Pluggable Database closed.

SQL> show con_name;

CON_NAME

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

PDBPRIM3

SQL> show pdbs;

    CON_ID CON_NAME              OPEN MODE      RESTRICTED

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

         4 PDBPRIM3                          MOUNTED

SQL> alter pluggable database PDBPRIM3 rename global_name to PDBPRIM2;

alter pluggable database PDBPRIM3 rename global_name to PDBPRIM2

                                                        *

ERROR at line 1:

ORA-01109: database not open

SQL> startup open restrict

Pluggable Database opened.

SQL> alter pluggable database PDBPRIM3 rename global_name to PDBPRIM2;

Pluggable database altered.

SQL> show con_name;

CON_NAME

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

PDBPRIM2

SQL> show pdbs;

    CON_ID CON_NAME              OPEN MODE   RESTRICTED

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

         4 PDBPRIM2                         READ WRITE   YES

SQL> shutdown immediate;

Pluggable Database closed.

SQL> show pdbs;

    CON_ID CON_NAME              OPEN MODE      RESTRICTED

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

         4 PDBPRIM2                       MOUNTED

SQL> alter session set container=CDB$ROOT;

Session altered.

SQL> show con_name;

CON_NAME

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

CDB$ROOT

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                                   READ ONLY      NO

         3 PDBPRIM                                     MOUNTED

         4 PDBPRIM2                                   MOUNTED

SQL>


Comments

Post a Comment

Popular posts from this blog

IVR Test

Image
IVR:  Interactive Voice Response NLU:  Natural Language Understanding TFN:  Toll Free Number DTMF:   Dual Time Multi Frequency ANI:   Automatic Number Identification ACD:  Automatic Call Distributor TTS:  Text to Speech CLI:  Calling Line Identifier CTI:  Cloud Telephony Integration DNS ARU:  Audio Response Unit MPSR:  Multi Pass Speech Recognition PESQ:  Perceptual Evaluation of Speech Quality PSST:  Post Speech Silence Timeout AX:  Agent Experience CYARA   CYARA is a IVR Automation Testing tool   By using CYARA we can create Test Cases, Blocks, Campaigns and Execute the Test Cases. To Creation TC :  Test Cases Prepared by using Pre-Coded Prompts ( Steps ) with the help of Call Flow.. Campaign : Design the test for Execution Prompt Analyzer :  ( To verify the Text) Analyze the Prompt or Step. What is IVR System? (Interactive Voice Response ) IVR is an automated technology that allows interac...
Read more

What to do when a particular step is failing with low confidence?

Image
  There will be few cases where you might face issues with a particular test case step failing with low confidence. To troubleshoot such scenario we advise to use the Prompt Analyzer feature which can be accessed in the test case step result. The screenshot below shows how to access Cyara Prompt Analyzer (PA) on example:   Once you click the PA icon, a new Prompt Analyzer page will open. It has few important fields and information regarding the step which failed such as: "Expect to Hear" verbiage, "Major/Minor" confidence threshold, a player that allows to listen for a step recording, and Analyze button, and some other options. The screenshot below demonstrates the Prompt Analyzer window:       To troubleshoot the issue you need to listen the step recording which should match with the verbiage specified in the Expect To Hear (ETH) field. If you notice that some words are missing from the ETH, edit the ETH on the same page and click the Analyze button. When ...
Read more

Creating an SMS Test Case

Image
  An SMS Test Case can be used in conjunction with an Outbound Campaign to test messaging being sent by your organization to your customer's mobile. The customer mobile numbers that you can use in your Test Cases are provided through one of our carriers. Your site administrator can provide you with a list of available numbers. To create an SMS Test Case, perform the following steps: From the Cyara Sidebar, select  Build and then click the  New Test Case  menu item. Select the  Channel  from the drop-down list. Choose the  SMS  option. A screen as shown below is displayed: Enter a unique name for the Test Case in the  Name  field. Browse and select the  Folder Path  where the Test Case should be stored. Enter a description of the Test Case in the  Description  field. Enter the  Customer Mobile Number . A list of mobile numbers provisioned to your account will be provided to you upon request. Note that this field c...
Read more