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
6
votes
2 answers

ORA-65096: invalid common user or role name

Hi I've tried to create a new user in Oracle 18c XE, but I get ORA-65096: invalid common user or role name error when writing create user student identified by "student"; I've tried to change the container to PDB by SQL> alter session set…
Cristina Moroti
  • 77
  • 1
  • 1
  • 8
5
votes
1 answer

How to Register Pluggable Database(PDB) with new created LISTENER

I am working with Oracle 19c in centos 7. After Oracle installation, i created new Container Database(CDB) with Plugguble Database(PDB) using DBCA. I am working with port number=1522 [oracle@ol8-19 ~]$ lsnrctl start LISTENER_TST LSNRCTL for Linux:…
K.D.Gayan
  • 143
  • 1
  • 1
  • 10
5
votes
1 answer

Is there any way to disable oracle Multitenant feature

We are using Oracle docker image for Oracle database 12.2. By default it seems the Multitenant feature is enabled. Is there any way it can be disabled? We have only one application to support and do not want to create pluggable database for…
explorer
  • 69
  • 4
3
votes
1 answer

Unlock the user in PDB database

Everytime I turn on my computer and try to connect to HR database, an error pops up stating is blocked, then I go to SQLPLUS and log in as SYSDBA, and do the following script: My question is, do I always have to do this? Is there any way to keep it…
user9892866
2
votes
2 answers

Goldengate error message Unable to add schematrandata

Following a tutorial to configure GoldenGate with Kafka, in sqlplus I created my GoldenGate user ggadmin and granted the privileges below: CREATE USER ggadmin IDENTIFIED BY ggadmin; GRANT CREATE SESSION, CONNECT, RESOURCE, ALTER SYSTEM TO…
cece
  • 21
  • 2
2
votes
0 answers

oracle 12c - PDB altered with errors

I have Oracle 12c installed. I have two schemas installed in the plaggable DB ORCLPDB. I restarted the machine where both oracle and my application exist. now when I'm trying to open the pluggable database ORCLPDB using the below query : alter…
user123
  • 387
  • 1
  • 4
  • 13
1
vote
1 answer

Migrating NON CDB to PDB with minimal downtime

I am doing a migrating from 19.11 non-CDB on a local file system to 19.11 Pluggable Database (PDB) on Automatic Storage Management (ASM) on same server. I tested: CREATE PDB WITH NOCOPY DATAPUMP CREATE EMPTY PDB and move data via db_link. None of…
user22476323
  • 11
  • 1
1
vote
0 answers

@?/rdbms/admin/utlrp.sql how to run utlrp in each PDB of oracle database using procedure

@?/rdbms/admin/utlrp.sql How to create procedure code to run the utlrp.sql in each pluggable database of oracle. I have created the below one but it has failed. please advise. I have created the below one but it has failed. it should run in all PDB…
Learner
  • 13
  • 4
1
vote
0 answers

ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only

I'm using oracle 19c. When i tried to open pluggable database as: alter pluggable database pdbname open; I got this error: ORA-01219: database or pluggable database not open: queries allowed on fixed tables or views only
Feras Tamesh
  • 21
  • 3
1
vote
1 answer

HR Data Base always locked?

I have added the HR data base to oracle 19c, but the thing is, every time I execute the sqldeveloper, it says the database is not open, so then I go to cmd and execute the following scripts, but is there any way to keep it always open? I don't want…
cesalomx
  • 25
  • 7
1
vote
1 answer

I do not visualize the changes I make in sqlplus in SQL Developer in an oracle 12c database, which I am raising with docker

Good afternoon, I am working with docker and an oracle 12c database, the official image found in the docker hub, the question is that I am testing creating a user from the SQL Plus, and when I am going to verify in the SQL developer, Note that the…
Cesar Justo
  • 707
  • 2
  • 11
  • 35
1
vote
2 answers

Is it possible to swap oracle 12c PDBs

We have 2 pluggable databases in the same cdb. Lets call them pdb1 and pdb2. These are in out test environment and you can think of thwm as separate uat environments. Each pdb has the defaul service (pdb1/pdb2) as well as 1 service i created…
George
  • 1,021
  • 15
  • 32
1
vote
2 answers

how to specify DBA role while connecting to Oracle DB from a spring boot application

I am creating a spring boot application which is connecting to an Oracle DB instance.My application is required to process SQL commands like CREATE PLUGGABLE DATABASE,ALTER PLUGGABLE DATABASE,ALTER SESSION,CREATE TABLESPACE,ALTER USER etc. My…
sdv
  • 21
  • 1
  • 3
0
votes
1 answer

Oracle Please look into PDB_PLUG_IN_VIOLATIONS view for more details

When creating a PDB in an Oracle 19.16 database, I get a warning in the logs: TEST_DB(4):WARNING: Pluggable Database TEST_DB with pdb id - 4 is TEST_DB(4): altered with errors or warnings. Please look into TEST_DB(4): …
Alex1__1
  • 17
  • 6
0
votes
0 answers

Cannot connect to pluggable database in Oracle XE Database

I have recently installed Oracle database 21c(XE) in my local and it was working fine. Since this morning, even though I can connect to XE database user, I cannot connect to the user in XEPDB1.It throws following error when connect through…
chk.buddi
  • 554
  • 1
  • 8
  • 29
1
2 3