Hi,

Greetings, thanks for reaching community. Please find the below inline response.

Once you set this parameter its set in the database. You dont have option to get it removed ( Workaround is below)

»set the following command to set to unset the parameter( This is default parameter value):-

    SQL>alter system set "_smu_debug_mode" = 0;

Although you have one option to get it removed from show parameter.

Solution:

Get temporary pfile created from that spfile;

Edit pfile and remove that _smu_debug_mode from pfile and startup database using the modified pfile

voila…

Example:

++++

SQL> create pfile='/tmp/a.ora' from spfile;

File created.

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0
[oracle@celvp**** ~]$ vi /tmp/a.ora
[oracle@celvp***** ~]$ cat /tmp/a.ora | grep smu
*._smu_debug_mode=0
[oracle@celvp**** ~]$ vi /tmp/a.ora
[oracle@celvp****** ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 22 16:19:01 2024
Version 19.23.0.0.0

Copyright (c) 1982, 2023, Oracle. All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.23.0.0.0

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup pfile='/tmp/a.ora';
ORACLE instance started.

Total System Global Area 1073740632 bytes
Fixed Size 9186136 bytes
Variable Size 675282944 bytes
Database Buffers 381681664 bytes
Redo Buffers 7589888 bytes
Database mounted.
Database opened.
SQL> show parameter smu
SQL> SELECT x.ksppinm "Parameter",
Y.ksppstvl "Session Value",
Z.ksppstvl "Instance Value"
FROM x$ksppi X,
x$ksppcv Y,
x$ksppsv Z
WHERE x.indx = Y.indx
AND x.indx = z.indx
AND x.ksppinm LIKE '/_%' escape '/'
and x.ksppinm like '%smu_debug%'
order by x.ksppinm ; 2 3 4 5 6 7 8 9 10 11

++++++

_smu_debug_mode
0
0

SQL> show parameter smu
SQL»»»»»»»» NOTHING SHOWING HERE.
SQL>

Now use this pfile and change this pfile to spfile using known method.

Regards,
Rahul Kumar

[Please Mark the Answers as accepted. If it helps or resolves your issue/queries.]

Hi,

basically no, it must be in open mode. why do you need that? you may open database in read only mode and then open it.