Scribd Logo
Upload

Welcome to Scribd!

  • 6 views

    Database Actions Problem

    Uploaded by

    icapvacancy

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Database Actions Problem

    Uploaded by

    icapvacancy
    6 views2 pages

    Original Title

    DATABASE ACTIONS PROBLEM

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    6 views2 pages

    Database Actions Problem

    Uploaded by

    icapvacancy

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    5/30/24, 12:52 PM Document 2643799.

    1
    PowerView is Off Last Login: May 18, 2024 11:32 PM UZT Umair (Available) (1) Contact Us Help

    Dashboard Knowledge Service Requests Patches & Updates

    Give Feedback...
    Copyright (c) 2024, Oracle. All rights reserved. Oracle Confidential.

    Username Of PDB Admin is Always PDBADMIN When PDB Created With DBCA In 19.6 Version (Doc ID 2643799.1) To Bottom

    In this Document Was this document helpful?

    Goal Yes
    No
    Solution

    Document Details

    APPLIES TO: Type:


    HOWTO
    Status:
    PUBLISHED
    Last Major
    Oracle Database Configuration Assistant - Version 19.6.0.0.0 and later Update:
    Mar 13, 2020
    Information in this document applies to any platform. Last Update:
    Apr 18, 2023

    GOAL
    Related Products

    How to create desired PDB admin's username during PDB creation with DBCA ? Oracle Database Configuration
    Assistant
    When create new PDB with DBCA, the username of PDB admin is always PDBADMIN no matter what is choose.
    Example: Information Centers
    dbca -silent -createPluggableDatabase -sourceDB cdXXX -pdbName devXXX -createPDBFrom DEFAULT -pdbAdminUserName
    XXXX_ADMIN -pdbAdminPassword '******' -createUserTableSpace true Index of Oracle Database
    Information Centers
    [1568043.2]

    then "PDBADMIN" User gets created instead of "XXXX_ADMIN": インフォメーション・センタ


    ー: データベースおよび
    Enterprise Manager 日本語ド
    select username, created, con_id from cdb_users where (username like 'PDB%' or username like 'TEST%') and con_id in (select キュメント [1946305.2]
    pdb_id from DBA_PDBS where PDB_NAME='TEST');

    USERNAME CREATED CON_ID Document References


    ------------------------------------------------------------------------------- No References available for
    PDBADMIN 24-FEB-20 3 this document.

    Recently Viewed

    SOLUTION The database user for the


    connection pool named
    |apex|pu|, is not able to
    There is an option for this in DBCA itself as below: proxy to the schema named
    <schem_user>. [2810884.1]
    Intermittent 503 Service
    dbca -sourceDB <sourceDB> -pdbName <pdbName> -createPluggableDatabase Unavailable - The database
    -createNewPDBAdminUser -pdbAdminUserName <pdbAdminUserName> user for the connection pool
    named |apex|pu| is not
    -createUserTableSpace false -responseFile <rspFilePath> authorized to proxy to the
    schema named <schema>
    a. Example with Response Rile: [2770463.1]
    503 Service Unavailable -
    dbca -silent -createPluggableDatabase -sourceDB cdXXXX -pdbName devXXX -createNewPDBAdminUser -pdbAdminUserName ORA-01017 for the
    XXX_ADMIN -createUserTableSpace false -responseFile /home/oracle/dbca-create-cdb-example-seeded-AFD.erb.rsp Connection Pool Named
    |apex|| when ORDS is
    b. Example without Responsible File: installed In CDB [2846964.1]
    After ORDS 18 Installation
    dbca -silent -createPluggableDatabase -sourceDB cdXXXX -pdbName devXXX -createNewPDBAdminUser -pdbAdminUserName 503 Error Occurs - The
    XXX_ADMIN -pdbAdminPassword '******' -createUserTableSpace true database user for the
    connection pool named
    |apex|pu|, is not authorized
    to proxy to the schema
    named APEX_PUBLIC_USER
    [2485210.1]
    503-Service Unavailable. The
    Pool Named: Apex Is Not
    Correctly Configured: Locale
    Not Recognized with ORDS
    on Tomcat 7 [2076710.1]
    Show More

    Didn't find what you are looking for? Ask in Community...

    Related
    Products
    Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database Configuration Assistant > Database Assistant

    Keywords
    ADMIN; DBCA; PDB; RESPONSE; USERNAME

    https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=354043927245923&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=… 1/2
    5/30/24, 12:52 PM Document 2643799.1
    Back to Top
    Copyright (c) 2024, Oracle. All rights reserved. Legal Notices and Terms of Use Privacy Statement

    https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=354043927245923&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=… 2/2

    You might also like