Database Administration (MOSC)

MOSC Banner

How can I remove (reset) pdb parameters from its spfile

edited Jul 29, 2020 5:05AM in Database Administration (MOSC) 3 commentsAnswered

Hi

Oracle Linux 7

Oracle 19.6 RAC (2-node)

I would like to remove these 2 parameter, that have SID='*'.

SQL> select db_uniq_name, pdb_uid, name, value$, sid from pdb_spfile$ where name like 'undo%' order by pdb_uid;DB_UNIQ_NA    PDB_UID NAME            VALUE$          SID---------- ---------- --------------- --------------- --------------------------------------------------------------------------------*          1547780192 undo_tablespace 'UNDOTBS2'      cdb2*          1547780192 undo_tablespace 'UNDOTBS1'      cdb1*          1547780192 undo_tablespace ''                        **          1565462022 undo_tablespace 'UNDOTBS1'      cdb1*          1565462022 undo_tablespace ''                        **          1565462022 undo_tablespace 'UNDOTBS2'      cdb2*          1746351333 undo_tablespace 'UNDOTBS2'      cdb2*          1746351333 undo_tablespace 'UNDOTBS1'      cdb1

8 rows selected.

I have tried:

SQL> alter system reset undo_tablespace container=current sid='*' scope=spfile;alter system reset undo_tablespace container=current sid='*' scope=spfile                                   *ERROR at line 1:ORA-00933: SQL command not properly ended

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center