RE: PDBs and oracle parameter

From: Amihay Gonen <Amihay.Gonen_at_software.dell.com>
Date: Mon, 23 Sep 2013 12:07:03 +0000
Message-ID: <92855FF6D7087A47A1DFFAF535C41363535CDC_at_UKBMBXW01.prod.quest.corp>

I think the documentation in this case is misleading, when trying to do the operation I got :

SQL> alter session set container=pdb1;

SQL> alter system set log_archive_dest='/tmp' container=current; alter system set log_archive_dest='/tmp' container=current *
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Amihay Gonen Sent: Monday, September 23, 2013 2:56 PM To: oracle-l_at_freelists.org
Subject: PDBs and oracle parameter

I've just going over the parameters which can be changed at PDB level (select * From parameter where ispdb_modifiable='TRUE';)

ISPDB_MODIFIABLE VARCHAR2(5) Indicates whether the parameter can be modified inside a PDB (TRUE) or not (FALSE). In a non-CDB, the value of this column is NULL.

I wonder if this field means the every PDB can have different value, or I can change it from PDB but it affects the complete instance.

For example "log_archive_dest_1" is part of the list , but it don't make sense to different values (since the redo files are part of the instance level ) ?

Regards,
Amihay Gonen
Oracle Domain Export

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 23 2013 - 14:07:03 CEST