Oracle PDB: differenze tra le versioni

Da Emigar.
Jump to navigation Jump to search
Riga 13: Riga 13:
export ORACLE_SID ORACLE_PDB_SID
export ORACLE_SID ORACLE_PDB_SID
sqlplus '/ as sysdba'
sqlplus '/ as sysdba'


==References==
https://mikedietrichde.com/2020/07/13/pitfalls-connect-to-a-pdb-directly-with-oracle_pdb_sid/


[[Categoria:Oracle]]
[[Categoria:Oracle]]

Versione delle 15:03, 8 ott 2020

PDB

Da sql:

show pdbs;
show con_name;
alter session set container=PDB1;


Variabili di ambiente

ORACLE_SID=CDB1
ORACLE_PDB_SID=PDB1
export ORACLE_SID ORACLE_PDB_SID
sqlplus '/ as sysdba'


References

https://mikedietrichde.com/2020/07/13/pitfalls-connect-to-a-pdb-directly-with-oracle_pdb_sid/