Exadata General (MOSC)

MOSC Banner

how can fix the issue of spfile as it is empty ?

in my oracle 19c in exadata syatem with one RAC database , the spfile is appered inside the disk group when we made show parameter spfile but when try to create pfile form it just show only the inormation of sga_max_size,.sga_target .and here are the deatils .

SQL> show parameter pfile

NAME TYPE VALUE

spfile string +DATAC1/SABACDB/PARAMETERFILE/
spfile.1940.1207452793

create pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/test20250930_sbacdb.ora' from spfile='+DATAC1/SABACDB/PARAMETERFILE/spfile.1940.1207452793' ;

File created.

sabadbadm01.sabafon.com.ye:/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs $more test20250930_sbacdb.ora
*.sga_max_size=107374182400

Tagged:

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