Oracle PDB - Cronologia

WikiSysop: /* Spostamento PDB */

2023-09-04T13:12:56Z

Spostamento PDB

← Versione meno recente		Versione delle 13:12, 4 set 2023
Riga 61:		Riga 61:
	==Spostamento PDB==		==Spostamento PDB==

	~~Procedur~~ per spostare con minimo fermo un PDB da un CDB ad un altro CDB su altro server, via DB link.		Procedura per spostare con minimo fermo un PDB da un CDB ad un altro CDB su altro server, via DB link.
			Va eseguita sul CDB di destinazione. Prima però serve creare un utente con i privilegi appropriati sul CDB sorgente.

	<pre>		<pre>
	-- se indietro di versione bisogna prima aver lanciato preupgrade.jar ed eseguito preupgrade_fixups.sql		-- se PDB sorgente indietro di versione bisogna prima aver lanciato preupgrade.jar ed eseguito preupgrade_fixups.sql
			-- e la open va eseguita con l'opzione upgrade.
			--
	-- sul CDB sorgente va create l'utente REMOTE_CLONE_USER con privilegi SYSOPER, CREATE SESSION e CREATE PLUGGABLE DATABASE		-- sul CDB sorgente va create l'utente REMOTE_CLONE_USER con privilegi SYSOPER, CREATE SESSION e CREATE PLUGGABLE DATABASE
	-- create user C##REMOTE_CLONE_USER identified by "password" container=all;		-- create user C##REMOTE_CLONE_USER identified by "password" container=all;
Riga 83:		Riga 86:
	show pdbs;		show pdbs;
	alter pluggable database PDB01 open;		alter pluggable database PDB01 open;
			alter pluggable database all save state instances=all;
	ALTER PLUGGABLE DATABASE ALL SAVE STATE INSTANCES=ALL;

	spool off		spool off

WikiSysop: /* Spostamento PDB */

2023-09-04T12:21:17Z

Spostamento PDB

← Versione meno recente		Versione delle 12:21, 4 set 2023
Riga 80:		Riga 80:

	-- spostamento database		-- spostamento database
	create pluggable database PDB01 from PDB01@~~CLONE_LINK_DAQ01D01~~ parallel 8 relocate availability max refresh mode every 30 minutes;		create pluggable database PDB01 from PDB01@CLONE_LINK_CDB01 parallel 8 relocate availability max refresh mode every 30 minutes;
	show pdbs;		show pdbs;
	alter pluggable database PDB01 open;		alter pluggable database PDB01 open;

WikiSysop: /* Spostamento PDB */

2023-09-04T12:19:33Z

Spostamento PDB

← Versione meno recente		Versione delle 12:19, 4 set 2023
Riga 60:		Riga 60:

	==Spostamento PDB==		==Spostamento PDB==

			Procedur per spostare con minimo fermo un PDB da un CDB ad un altro CDB su altro server, via DB link.

	<pre>		<pre>

	--

	--
	-- se indietro di versione bisogna prima aver lanciato preupgrade.jar ed eseguito preupgrade_fixups.sql		-- se indietro di versione bisogna prima aver lanciato preupgrade.jar ed eseguito preupgrade_fixups.sql
	-- sul CDB sorgente va create l'utente REMOTE_CLONE_USER con privilegi SYSOPER, CREATE SESSION e CREATE PLUGGABLE DATABASE		-- sul CDB sorgente va create l'utente REMOTE_CLONE_USER con privilegi SYSOPER, CREATE SESSION e CREATE PLUGGABLE DATABASE
Riga 77:		Riga 75:
	alter session set container=CDB$ROOT;		alter session set container=CDB$ROOT;
	create database link CLONE_LINK_CDB01 connect to C##REMOTE_CLONE_USER identified by "password" using '192.168.0.1:2483/CDB01';		create database link CLONE_LINK_CDB01 connect to C##REMOTE_CLONE_USER identified by "password" using '192.168.0.1:2483/CDB01';


	-- alter pluggable database PDB01 close;		-- alter pluggable database PDB01 close;
	-- drop pluggable database PDB01 including datafiles;		-- drop pluggable database PDB01 including datafiles;


	-- spostamento database		-- spostamento database
	create pluggable database PDB01 from PDB01@CLONE_LINK_DAQ01D01 parallel 8 relocate availability max refresh mode every 30 minutes;		create pluggable database PDB01 from PDB01@CLONE_LINK_DAQ01D01 parallel 8 relocate availability max refresh mode every 30 minutes;

	show pdbs;		show pdbs;
	alter pluggable database PDB01 open;		alter pluggable database PDB01 open;

	ALTER PLUGGABLE DATABASE ALL SAVE STATE INSTANCES=ALL;		ALTER PLUGGABLE DATABASE ALL SAVE STATE INSTANCES=ALL;


	spool off		spool off


	</pre>		</pre>

WikiSysop: /* Variabili di ambiente */

2023-09-04T12:17:03Z

Variabili di ambiente

← Versione meno recente		Versione delle 12:17, 4 set 2023
Riga 58:		Riga 58:
	sqlplus '/ as sysdba'		sqlplus '/ as sysdba'


			==Spostamento PDB==

			<pre>

			--

			--
			-- se indietro di versione bisogna prima aver lanciato preupgrade.jar ed eseguito preupgrade_fixups.sql
			-- sul CDB sorgente va create l'utente REMOTE_CLONE_USER con privilegi SYSOPER, CREATE SESSION e CREATE PLUGGABLE DATABASE
			-- create user C##REMOTE_CLONE_USER identified by "password" container=all;
			-- grant CREATE SESSION,CREATE PLUGGABLE DATABASE to C##REMOTE_CLONE_USER container=all;
			-- grant sysoper to C##REMOTE_CLONE_USER container=all;

			spool migrazione.log
			set timing on echo on feedback on linesize 200 pagesize 200 trim on trims on

			alter session set container=CDB$ROOT;
			create database link CLONE_LINK_CDB01 connect to C##REMOTE_CLONE_USER identified by "password" using '192.168.0.1:2483/CDB01';


			-- alter pluggable database PDB01 close;
			-- drop pluggable database PDB01 including datafiles;


			-- spostamento database
			create pluggable database PDB01 from PDB01@CLONE_LINK_DAQ01D01 parallel 8 relocate availability max refresh mode every 30 minutes;

			show pdbs;
			alter pluggable database PDB01 open;

			ALTER PLUGGABLE DATABASE ALL SAVE STATE INSTANCES=ALL;


			spool off


			</pre>

	==Listener e service names==		==Listener e service names==

WikiSysop: /* crea CDB con DBCA in modalità silente */

2022-07-14T16:14:39Z

crea CDB con DBCA in modalità silente

← Versione meno recente		Versione delle 16:14, 14 lug 2022
Riga 8:		Riga 8:
	CODESET=$3		CODESET=$3
	[ $# -ne 3 ] && exit 1		[ $# -ne 3 ] && exit 1

	dbca -silent -createDatabase \		dbca -silent -createDatabase \
	-databaseConfigType SINGLE \		-databaseConfigType SINGLE \

WikiSysop: /* Listener e service names */

2022-07-14T15:42:23Z

Listener e service names

← Versione meno recente		Versione delle 15:42, 14 lug 2022
Riga 70:		Riga 70:
	alter pluggable database PDB01 save state;		alter pluggable database PDB01 save state;
	SELECT name,network_name FROM dba_services ORDER BY name;		SELECT name,network_name FROM dba_services ORDER BY name;


	select name from V$SERVICES;		select name from V$SERVICES;
Riga 84:		Riga 83:
	===definire listener===		===definire listener===
	alter system set local_listener		alter system set local_listener

	==ORA-65144==		==ORA-65144==

WikiSysop: /* Definire i service names */

2022-07-14T15:41:05Z

Definire i service names

← Versione meno recente		Versione delle 15:41, 14 lug 2022
Riga 70:		Riga 70:
	alter pluggable database PDB01 save state;		alter pluggable database PDB01 save state;
	SELECT name,network_name FROM dba_services ORDER BY name;		SELECT name,network_name FROM dba_services ORDER BY name;


			select name from V$SERVICES;
			select name from V$ACTIVE_SERVICES;

	alter session set container=CDB$ROOT;		alter session set container=CDB$ROOT;

WikiSysop: /* Definire i service names */

2022-07-14T15:36:41Z

Definire i service names

← Versione meno recente		Versione delle 15:36, 14 lug 2022
Riga 70:		Riga 70:
	alter pluggable database PDB01 save state;		alter pluggable database PDB01 save state;
	SELECT name,network_name FROM dba_services ORDER BY name;		SELECT name,network_name FROM dba_services ORDER BY name;

	alter session set container=CDB$ROOT;		alter session set container=CDB$ROOT;
			col pdb for a10
			col name for a30
			col network_name for a30
			set pagesize 200 linesize 200 trim on trims on
	SELECT pdb,name,network_name FROM cdb_services ORDER BY name;		SELECT pdb,name,network_name FROM cdb_services ORDER BY name;

WikiSysop: /* Definire i service names */

2022-07-14T15:33:25Z

Definire i service names

← Versione meno recente		Versione delle 15:33, 14 lug 2022
Riga 63:		Riga 63:

	===Definire i service names===		===Definire i service names===
	alter session set container=PDB01		alter session set container=PDB01;
	exec dbms_service.stop_service(service_name=>'SERVICE01');		exec dbms_service.stop_service(service_name=>'SERVICE01');
	exec dbms_service.delete_service(service_name=>'SERVICE01');		exec dbms_service.delete_service(service_name=>'SERVICE01');
Riga 70:		Riga 70:
	alter pluggable database PDB01 save state;		alter pluggable database PDB01 save state;
	SELECT name,network_name FROM dba_services ORDER BY name;		SELECT name,network_name FROM dba_services ORDER BY name;
			alter session set container=CDB$ROOT;
	SELECT pdb,name,network_name FROM cdb_services ORDER BY name;		SELECT pdb,name,network_name FROM cdb_services ORDER BY name;

WikiSysop: /* Definire i service names */

2022-07-14T15:32:55Z

Definire i service names

← Versione meno recente		Versione delle 15:32, 14 lug 2022
Riga 64:		Riga 64:
	===Definire i service names===		===Definire i service names===
	alter session set container=PDB01		alter session set container=PDB01
	exec dbms_service.stop_service('SERVICE01');		exec dbms_service.stop_service(service_name=>'SERVICE01');
	exec dbms_service.delete_service('SERVICE01');		exec dbms_service.delete_service(service_name=>'SERVICE01');
	exec dbms_service.create_service('SERVICE01','SERVICE01');		exec dbms_service.create_service(service_name=>'SERVICE01',network_name=>'SERVICE01');
	exec dbms_service.start_service('SERVICE01');		exec dbms_service.start_service(service_name=>'SERVICE01');
	alter pluggable database save state;		alter pluggable database PDB01 save state;
	SELECT name,network_name FROM dba_services ORDER BY name;		SELECT name,network_name FROM dba_services ORDER BY name;
			SELECT pdb,name,network_name FROM cdb_services ORDER BY name;

	===definire listener===		===definire listener===