Stack Overflow
Stack Overflow

Questions tagged [pluggable-database]

A pluggable database (PDB) is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB.

PDBs can be plugged into to CDBs. A CDB can contain multiple PDBs. Each PDB appears on the network as a separate database.

31 questions
0
votes
1 answer

Connecting to an Oracle Pluggable Database using connection string in .NET Core Application

How can we connect to a pluggable database via connection string in my application? Pluggable database is created via docker. How do I specify that I want to connect to a pluggable database and not to cdb? Because am getting lot of metadata tables…
eliza_chris
  • 21
  • 6
0
votes
0 answers

Can't connect to my pluggable databases, but can connect to my ROOT DB and move through the pdbs

It's the first time I'm setting up a Oracle database, I'm using Oracle Linux and Oracle 18.3 Everything went fine until this issue that I can't solve. I can connect through my Client side SQL Developer on the root ORCL, but not on my PDBs ORCLPDB…
Zilkar Baranow
  • 1
0
votes
1 answer

Can Oracle 21c PDBs reside on a NAS or external USB drive?

Is it possible to have an Oracle 21c program and container database (CDB) running on a server and have it run pluggable databases (PDBs) whose data files are on a NAS, external USB or other source that's accessible from the server? I'd like to build…
Michael C
  • 53
  • 6
0
votes
0 answers

I can't unplug PDB in oracle 19c

I am trying to unplug by PDB but it is showing the error that I have shown in the image. When I searched in google, this error occurs when we try to plug an unplugged PDB. But what I am trying to do here is unplug this testDB pdb. What Might Be it's…
Manish Lama
  • 1
  • 2
0
votes
1 answer

How to create user profile in pluggable oracle db

This is my query : CREATE PROFILE user_prof LIMIT password_life_time unlimited; I am getting ORA-65040: operation not allowed from within a pluggable database. How to resolve this? I create a user with name pp CREATE USER pp IDENTIFIED BY…
Nitin Singhal
  • 215
  • 2
  • 11
0
votes
1 answer

How to switch to the only PDB in Oracle 12+?

Using Oracle's vagrant boxes, you can easily add scripts that are run post installation by putting them in the userscripts directory. I want to create my standard users, which is easy (CREATE USER etc...). However, those user needs to be created in…
wolφi
  • 8,091
  • 2
  • 35
  • 64
0
votes
1 answer

What's the difference between v$pdbs and dba_pdbs in Oracle?

I'm new to pluggable databases and am puzzled by the dictionary views DBA_PDBS and V$PDBS. What's the differnence? The documentation is not helpful, either: V$PDBS displays information about PDBs associated with the current instance. 1 SELECT *…
wolφi
  • 8,091
  • 2
  • 35
  • 64
0
votes
2 answers

How to clone a pluggable database in Oracle

I'm new to Oracle's pluggable databases (we still use Oracle 11.2 at work). For a test of partitions and subpartitions, I'll need to create a couple of dozen tablespaces. I thought, I'd quickly clone my current database, do the tests, and drop the…
wolφi
  • 8,091
  • 2
  • 35
  • 64
0
votes
1 answer

ORA-65169: error encountered while attempting to copy file

Hi im trying to create clone_link between two ora19 databases due to cloning PDB databases both DBs have created user like: CREATE USER c##remote_clone_user IDENTIFIED BY remote_clone_user CONTAINER=ALL; GRANT CREATE SESSION, CREATE PLUGGABLE…
Viktorbs
  • 1
  • 1
  • 2
0
votes
0 answers

Oracle 12c pluggable database won't start

After running some scripts to install/uninstall Oracle Application Express (APEX), now my pluggable database won't start. I get the (uninformative) error: ORA-00604: error occurred at recursive SQL level 1 ORA-01405: fetched column value is NULL I…
Howard007
  • 124
  • 7
0
votes
1 answer

How to import datapump export file from XE 11g to XE 18c

I have datapump single schema export generated on 11g XE. I want to import it to 18c XE. I'm using command line impdp. At first, I was getting message: UDI-01017: operation generated ORACLE error 1017 ORA-01017: invalid username/password; logon…
some1
  • 21
  • 5
0
votes
0 answers

Connected to Pluggable Database - Cannot See Any Tables - SQL*PLUS

I am using sqlplus to connect to a pluggable database that is running on my localhost. However, when I connect I cannot see any of the tables from the major schemas. Does anyone know how to trouble shoot this type of problem? When I connect using…
user3808269
  • 1,321
  • 3
  • 21
  • 40
0
votes
3 answers

Cannot connect to oracle pluggable database

Iinstalled oracle in my Windows 10 64 bit pc and I started doing verification steps mentioned in the tutorial which's given in the oracle website which can be found in the link…
ChathurawinD
  • 756
  • 1
  • 13
  • 35
0
votes
2 answers

Oracle 12c default pluggable DB in sqlplus

I have a pluggable database in Oracle 12c named PDBORCL. After a server restart something changed in how to connect to it. I created a user in that pluggable DB, for the example the user is PETER and the password is also PETER. Before the restart I…
user7792598
  • 177
  • 1
  • 6
  • 17
-1
votes
1 answer

Unable to connect to pdb from sql developer while cdb is getting connected Oracle 19c

I have recently installed Oracle 19c enterprise edition on Virtual box with host as windows 10 while guest machine in Linux Oracle. I am able to connect to CDB database both from sqlplus(Installed on Virtualbox i.e. guest machine) and SQLDeveloper…
Atif
  • 2,011
  • 9
  • 23
1
2
3