Hi,
Sometimes You can get “ORA-29760: instance_number parameter not specified ” error.
Details of error are as follows.
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
Cause: An alter system command or an internal self tuning mechanism requested a write to the SPFILE but no SPFILE was used to startup the instance
Action: Create an SPFILE and re-start the instance using the SPFILE.
ALTER SYSTEM SET processes = 1000 SCOPE=SPFILE; ALTER SYSTEM SET processes = 1000 SCOPE=SPFILE * ERROR at line 1: ORA-32001: write to SPFILE requested but no SPFILE is in use
Firstly create a spfile from pfile or memory as follows.
SQL> create spfile from pfile; SQL> create spfile from memory;
Then Restart database, normally database will startup via spfile if it exists.
SQL> shutdown immediate; SQL> startup
Now try again.
SQL> ALTER SYSTEM SET processes = 1000 SCOPE=SPFILE; System altered.
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/