{"id":3206,"date":"2013-09-10T09:22:00","date_gmt":"2013-09-10T07:22:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/"},"modified":"2024-09-11T15:19:40","modified_gmt":"2024-09-11T13:19:40","slug":"oracle-database-12c-demarrage-automatique-des-pluggable-databases","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/","title":{"rendered":"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases"},"content":{"rendered":"<p><img decoding=\"async\" class=\"blog-image aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg\" alt=\"\" \/><\/p>\n<p>Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l&#8217;arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c.<\/p>\n<h3>Le contexte<\/h3>\n<p>Au pr\u00e9alable, il faut avoir install\u00e9 Grid Infrastructure et cr\u00e9\u00e9 une CDB (Container Database) avec une PDB. Nous allons utiliser le processus d&#8217;Oracle Restart pour g\u00e9rer l&#8217;arr\u00eat et le d\u00e9marrage de notre PDB.<\/p>\n<p>Pour cela, il nous faut:<\/p>\n<ul>\n<li>Un conteneur : TST12C<\/li>\n<li>Une PDB : PDB1<\/li>\n<li>Un Grid\u00a0 Infrastructure : +ASM<\/li>\n<\/ul>\n<p>Regardons le contenu de nos services c\u00f4t\u00e9 Grid Infrastructure apr\u00e8s installation:<br \/>\n<a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a> [+ASM] crsctl stat res -t<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">--------------------------------------------------------------------------------\nName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Target\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State details\n--------------------------------------------------------------------------------\nLocal Resources\n--------------------------------------------------------------------------------\nora.DATA.dg\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\nora.FRA.dg\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\nora.LISTENER.lsnr\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\nora.asm\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Started,STABLE\nora.ons\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n--------------------------------------------------------------------------------\nCluster Resources\n--------------------------------------------------------------------------------\nora.cssd\n\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\nora.diskmon\n\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\nora.evmd\n\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\nora.tst12c.db\n\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Open,STABLE\n--------------------------------------------------------------------------------<\/pre>\n<p>Nous disposons :<\/p>\n<ul>\n<li>De deux diskgroups ASM (DATA et FRA)<\/li>\n<li>D&#8217;un listener LISTENER.lsnr<\/li>\n<li>D&#8217;une base de donn\u00e9es tst12c.db<\/li>\n<\/ul>\n<h3>Point de v\u00e9rification:<\/h3>\n<p>Avant de commencer, v\u00e9rifions l&#8217;\u00e9tat de notre Pluggable par un SELECT:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\"><samp><\/samp>SQL&gt; select name, open_mode from v$pdbs;\n\u00a0\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE\n------------------------------\u00a0\u00a0\u00a0 ----------\nPDB$SEED \u00a0 \u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\nPDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/pre>\n<p>Cette pluggable PDB1 est bien pr\u00e9sente en mode MOUNTED, \u00e9tat normal pour une PDB non d\u00e9mar\u00e9e.<\/p>\n<p>Passons aux choses s\u00e9rieuses. Comme nous voulons g\u00e9rer nos PDBs avec SRVCTL, il nous faut cr\u00e9er un service et une entr\u00e9e dans le TNSNAMES.ora.<\/p>\n<p>Les commandes de SRVCTL d&#8217;Oracle s&#8217;enrichissent avec cette nouvelle version 12c. Vous pouvez les consulter \u00e0 la page suivante :<\/p>\n<p>http:\/\/docs.oracle.com\/cd\/E16655_01\/server.121\/e17636\/restart.htm#ADMIN5013<\/p>\n<p>V\u00e9rifions les ervices avant de commencer sur notre Grid Infrastructure. Actuellement il n&#8217;y a aucun service sur notre base de donn\u00e9es:<br \/>\n<a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a> [TST12C] srvctl status service -db TST12C -verbose<br \/>\nDatabase TST12C does not have services<\/p>\n<h3>Cr\u00e9ation du service<\/h3>\n<p>Syntaxe : srvctl add service -db &#8216;db_unique_name&#8217; -service &#8216;service_name&#8217; -pdb &#8216;Nom Pdb&#8217;<\/p>\n<p><a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a> [TST12C] srvctl add service -db TST12C -service -Mon_SRV -pdb pdb1<\/p>\n<p><a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a> [TST12C]<\/p>\n<p>V\u00e9rifions notre cr\u00e9ation et l&#8217;ensemble des services.<\/p>\n<p><samp class=\"mceVisualAid mceVisualGuides\"><a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a> [TST12C] srvctl status service -db TST12C -verbose<\/samp><samp><\/samp><samp>Service Mon_SRV is running<\/samp><\/p>\n<p><code><a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a>[+ASM] crsctl stat res -t<\/code><\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">--------------------------------------------------------------------------------\n Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Target\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State details\n --------------------------------------------------------------------------------\n Local Resources\n --------------------------------------------------------------------------------\n ora.DATA.dg\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.FRA.dg\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.LISTENER.lsnr\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.asm\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Started,STABLE\n ora.ons\n OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n --------------------------------------------------------------------------------\n Cluster Resources\n --------------------------------------------------------------------------------\n ora.cssd\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.diskmon\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.evmd\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.tst12c.db\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Open,STABLE\n ora.tst12c.mon_srv.svc\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n --------------------------------------------------------------------------------<\/pre>\n<p>Nous avons bien \u00e0 notre disposition le service ora.tst12c.mon_srv.svc, vous remarquerez que celui-ci est OFFLINE.<\/p>\n<h3>Cr\u00e9ation de l&#8217;Alias du TNSNAMES.ora<\/h3>\n<p>Afin que l&#8217;on puisse acc\u00e9der \u00e0 notre PDB, nous allons l&#8217;int\u00e9grer dans le TNSNAMES.ora une nouvelle entr\u00e9e comme suit.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">PDB1 =\n (DESCRIPTION =\n (ADDRESS_LIST =\n (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))\n )\n (CONNECT_DATA =\n (SERVICE_NAME = Mon_srv)\n )\n )<\/pre>\n<p>Comme pour une instance, il suffit d&#8217;utiliser le Service_name du service cr\u00e9\u00e9 pr\u00e9c\u00e9dement et de lui donner un alias. Ce service nous permettra de nous connecter \u00e0 cette PDB (connect <a href=\"mailto:sys@SRV_PDB1 as\">sys@SRV_PDB1 as<\/a> sysdba)<\/p>\n<p>V\u00e9rifions c\u00f4t\u00e9 LISTENER si nous voyons notre service.<\/p>\n<p><samp><a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a> [+ASM] lsnrctl status<\/samp><samp>Services Summary&#8230;<br \/>\nService &#8220;+ASM&#8221; has 1 instance(s).<br \/>\nInstance &#8220;+ASM&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;Mon_SRV&#8221; has 1 instance(s).<br \/>\nInstance &#8220;TST12C&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;TST12C&#8221; has 1 instance(s).<br \/>\nInstance &#8220;TST12C&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;TST12CXDB&#8221; has 1 instance(s).<br \/>\nInstance &#8220;TST12C&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nThe command completed successfully<\/samp><\/p>\n<p>Aucune trace du service.<br \/>\nEssayons de nous connecter \u00e0 notre PDB avec connect sys@SRV_PDB1 as sysdba.<br \/>\nQue se passe t-il ?<\/p>\n<p><samp>SQL&gt; connect <a href=\"mailto:sys@SRV_PDB1 as\">sys@SRV_PDB1 as<\/a> sysdba<\/samp><samp>Enter password:<\/samp><samp>ERROR:<\/samp><samp>ORA-12154:TNS:could not resolve the connect identifier specified<\/samp><\/p>\n<p>Warning: You are no longer connected to ORACLE.<br \/>\nAucune connexion. Ceci est tout \u00e0 fait normal puisque notre service ora.tst12c.mon_srv.srv et notre PDB ne sont toujours pas d\u00e9marr\u00e9s.<\/p>\n<h4>D\u00e9marrons le service :<\/h4>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@vmtest12c1:\/home\/oracle\/ [TST12C] srvctl start service -db TST12C -service \"Mon_SRV\" -verbose\noracle@vmtest12c1:\/home\/oracle\/ [TST12C]\noracle@vmtest12c1:\/home\/oracle\/ [TST12C] srvctl status service -db TST12C -verbose\nService Mon_SRV is running<\/pre>\n<p>Proc\u00e9dons aux v\u00e9rifications de nos ressources cluster (HAS), Listener et connexion \u00e0 notre PDB:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@vmtest12c1:\/home\/oracle\/[+ASM] crsctl stat res -t\n--------------------------------------------------------------------------------\n Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Target\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State details\n --------------------------------------------------------------------------------\n Local Resources\n --------------------------------------------------------------------------------\n ora.DATA.dg\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.FRA.dg\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.LISTENER.lsnr\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.asm\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Started,STABLE\n ora.ons\n OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n --------------------------------------------------------------------------------\n Cluster Resources\n --------------------------------------------------------------------------------\n ora.cssd\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.diskmon\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.evmd\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.tst12c.db\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Open,STABLE\n ora.tst12c.mon_srv.svc\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n --------------------------------------------------------------------------------<\/pre>\n<p>Notre service ora.tst12c.mon_srv.srv est bien ONLINE et STABLE, par-contre il nous affiche pas l&#8217;\u00e9tat &#8220;Open&#8221; de la PDB comme pour la base de donn\u00e9es.<\/p>\n<p><samp><code><a href=\"mailto:oracle@vmtest12c1:\/home\/oracle\/\">oracle@vmtest12c1:\/home\/oracle\/<\/a> [+ASM] lsnrctl status<\/code><\/samp><samp><\/samp><samp><\/samp><samp>Services Summary&#8230;<br \/>\nService &#8220;+ASM&#8221; has 1 instance(s).<br \/>\nInstance &#8220;+ASM&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;Mon_SRV&#8221; has 1 instance(s).<br \/>\nInstance &#8220;TST12C&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;TST12C&#8221; has 1 instance(s).<br \/>\nInstance &#8220;TST12C&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;TST12CXDB&#8221; has 1 instance(s).<br \/>\nInstance &#8220;TST12C&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nService &#8220;pdb1&#8221; has 1 instance(s).<br \/>\nInstance &#8220;TST12C&#8221;, status READY, has 1 handler(s) for this service&#8230;<br \/>\nThe command completed successfully<\/samp><samp><samp class=\"mceVisualAid mceVisualGuides\"><\/samp><\/samp><\/p>\n<p>Nous avons bien le service &#8220;Mon_SRV&#8221; instanci\u00e9.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; connect sys@SRV_PDB1 as sysdbaEnter password:Connected.\nSQL&gt; select name,open_mode, con_id from v$pdbs;\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE \u00a0 \u00a0 \u00a0\u00a0 CON_ID\n ---------------------------\u00a0\u00a0\u00a0 \u00a0\u00a0 -------------\u00a0\u00a0 ---------\n PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02\n PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ WRITE\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0\u00a03<\/pre>\n<p>&nbsp;<\/p>\n<p>La PDB est bien d\u00e9marr\u00e9 et nous pouvons int\u00e9rroger la base de donn\u00e9es<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select property_name, property_value from database_properties\n 2\u00a0 where property_name like 'DEFAULT_%TABLE%';\nPROPERTY_NAME\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0PROPERTY_VALUE\n ------------------------------\u00a0 --------------\n DEFAULT_TEMP_TABLESPACE\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0 TEMP\n DEFAULT_PERMANENT_TABLESPACE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 USERS<\/pre>\n<p>Arr\u00eatons le service :<\/p>\n<p>oracle@vmtest12c1:\/home\/oracle\/ [TST12C] srvctl stop service -db TST12C -service &#8220;Mon_SRV&#8221; -force -verbose<br \/>\noracle@vmtest12c1:\/home\/oracle\/ [TST12C]<\/p>\n<p>Notre service\u00a0 &#8220;Mon_SRV s&#8217;est arr\u00eat\u00e9 sans message.<\/p>\n<p>V\u00e9rifions les services.<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">--------------------------------------------------------------------------------\n Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Target\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 State details\n --------------------------------------------------------------------------------\n Local Resources\n --------------------------------------------------------------------------------\n ora.DATA.dg\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.FRA.dg\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.LISTENER.lsnr\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.asm\n ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Started,STABLE\n ora.ons\n OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n --------------------------------------------------------------------------------\n Cluster Resources\n --------------------------------------------------------------------------------\n ora.cssd\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.diskmon\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.evmd\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n ora.tst12c.db\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ONLINE\u00a0 ONLINE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Open,STABLE\n ora.tst12c.mon_srv.svc\n 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFFLINE OFFLINE\u00a0\u00a0\u00a0\u00a0\u00a0 vmtest12c1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STABLE\n --------------------------------------------------------------------------------<\/pre>\n<p>Le service ora.tst12c.mon_srv.svc est bien arr\u00eat\u00e9.<\/p>\n<p>V\u00e9rifions maintenant cot\u00e9 PDB.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select name,open_mode, con_id from v$pdbs;\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0 CON_ID\n ----------------------------\u00a0\u00a0 -----------\u00a0\u00a0\u00a0\u00a0 ------\n PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\n PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0READ WRITE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/pre>\n<p>Il y a certainement un probl\u00e8me. Relan\u00e7ons l&#8217;arr\u00eat de la PDB pour v\u00e9rifier. A priori l&#8217;arr\u00eat de notre PDB ne fonctionne pas avec SRVCTL, pour confimer testons encore une fois l&#8217;arret.<\/p>\n<p>oracle@vmtest12c1:\/home\/oracle\/ [TST12C] srvctl stop service -db TST12C -service &#8220;Mon_SRV&#8221; -force -verbosePRCR-1005 : Resource ora.tst12c.mon_srv.svc is already stopped<\/p>\n<p>SRVCTL nous informe bien qu&#8217;il est d\u00e9j\u00e0 arr\u00eat\u00e9, c&#8217;est exact mais ou en est l&#8217;\u00e9tat de notre PDB.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select name,open_mode, con_id from v$pdbs;\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0OPEN_MODE\u00a0\u00a0\u00a0\u00a0CON_ID\n --------------------------- ---------- \u00a0 ------\n PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\n PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0READ WRITE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/pre>\n<p><samp><br \/>\nD\u00e9cevant ! Notre PDB est toujours READ\/WRITE.<\/samp><\/p>\n<p>Nous allons tenter d&#8217;arr\u00eater cette PDB avec SQLPLUS.<\/p>\n<p><samp>Connected to:<\/samp><samp>Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 &#8211; 64bit Production<\/samp><samp>With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics<\/samp><samp>and Real Application Testing optionsSQL&gt; alter pluggable database pdb1 close;Pluggable database altered.<\/samp><samp>SQL&gt; alter pluggable database pdb1 close;<\/samp><samp>Pluggable database altered.<\/samp><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select name, open_mode, con_id from v$pdbs;\nNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0OPEN_MODE\u00a0\u00a0\u00a0\u00a0\u00a0 CON_ID\n ------------------------\u00a0\u00a0 ---------- \u00a0 \u00a0 ------\n PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\n PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0MOUNTED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\nSQL&gt; connect sys@SRV_PDB1 as sysdbaEnter password:ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect descriptor<\/pre>\n<p>&nbsp;<\/p>\n<p>Magnifique ! Op\u00e9ration r\u00e9alis\u00e9e avec succ\u00e8s mais sans SRVCTL.<br \/>\nPour r\u00e9sumer la commande SRVCTL Start fonctionne \u00e0 contrario de la commande SVRCTL Stop.<br \/>\nSi vous ne souhaitez pas utiliser Server Control pour g\u00e9rer vos PDBs, il est possible d&#8217;utiliser des Triggers.<\/p>\n<h4>Voici un exemple :<\/h4>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">CREATE TRIGGER Start_Pdb\n after startup on database\n begin\n execute immediate 'alter pluggable database all open';\n -- alter pluggable database pdb 'Nom Pdb' open\n end Start_Pdb;\n \/<code class=\"mceVisualAid mceVisualGuides\"><\/code><\/pre>\n<p><code class=\"mceVisualAid mceVisualGuides\"><span style=\"color: #ff0000;\"><span style=\"color: #000000;\"><br \/>\n<\/span><\/span><\/code><\/p>\n<h3>Conclusion<\/h3>\n<p>La technologie Grid Infrastucture qui embarque ASM et Oracle Restart am\u00e9liore la disponibilit\u00e9 de la base de donn\u00e9es.<\/p>\n<p>Oracle Restart int\u00e9gre les composants pour d\u00e9marrer et arr\u00e9ter les PDBs, il est juste dommageable que l&#8217;arr\u00eat de nos PDBs ne fonctionne pas.<\/p>\n<p>Si vous ne disposez pas de Grid Infrastructure, la gestion (D\u00e9marrage \/ Arr\u00eat) de vos PDBs se fera par triggers comme \u00e9voqu\u00e9 dans ce blog. Neanmoins, dbi services est en train de d\u00e9velopper une solution simple et efficace pour la gestion de vos PDBs bas\u00e9e sur l&#8217;outil DMK (<a href=\"http:\/\/dbi-services.com\/DMK\">Database Management Kit<\/a>) qui facilitera votre quotidien avec les PDBs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l&#8217;arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c. Le contexte Au pr\u00e9alable, il faut avoir install\u00e9 Grid Infrastructure et [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":2734,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[258,320,209,218,353],"type_dbi":[],"class_list":["post-3206","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-grid","tag-multitenant-database","tag-oracle-12c","tag-oracle-enterprise-manager-cloud-12c","tag-pluggable-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases - dbi Blog<\/title>\n<meta name=\"description\" content=\"Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l&#039;arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases\" \/>\n<meta property=\"og:description\" content=\"Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l&#039;arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-10T07:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-11T13:19:40+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"209\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases\",\"datePublished\":\"2013-09-10T07:22:00+00:00\",\"dateModified\":\"2024-09-11T13:19:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/\"},\"wordCount\":1162,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg\",\"keywords\":[\"Grid\",\"Multitenant database\",\"Oracle 12c\",\"Oracle Enterprise Manager Cloud 12c\",\"Pluggable Database\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/\",\"name\":\"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg\",\"datePublished\":\"2013-09-10T07:22:00+00:00\",\"dateModified\":\"2024-09-11T13:19:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l'arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg\",\"width\":200,\"height\":209},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases - dbi Blog","description":"Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l'arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases","og_description":"Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l'arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/","og_site_name":"dbi Blog","article_published_time":"2013-09-10T07:22:00+00:00","article_modified_time":"2024-09-11T13:19:40+00:00","og_image":[{"width":200,"height":209,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases","datePublished":"2013-09-10T07:22:00+00:00","dateModified":"2024-09-11T13:19:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/"},"wordCount":1162,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg","keywords":["Grid","Multitenant database","Oracle 12c","Oracle Enterprise Manager Cloud 12c","Pluggable Database"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/","name":"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg","datePublished":"2013-09-10T07:22:00+00:00","dateModified":"2024-09-11T13:19:40+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Dans ce blog post, nous allons nous int\u00e9resser \u00e0 la gestion des PDBs (Pluggable Database) dans Oracle 12c. Plus exactement, nous allons nous pencher sur l'arr\u00eat et le d\u00e9marrage automatiques des PDBs en utilisant le Server Control (srvctl) du Grid Infrastructure de la 12c.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_Oracle_12c_Plug.jpg","width":200,"height":209},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-12c-demarrage-automatique-des-pluggable-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 12c : d\u00e9marrage automatique des Pluggable Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3206","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3206"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3206\/revisions"}],"predecessor-version":[{"id":34739,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3206\/revisions\/34739"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2734"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3206"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}