-
Open a Command Prompt as administrator.
-
Set oracle_home=C:\oracle\19c_Sta\db
-
Set oracle_sid=CDB
-
sqlplus /nolog
-
conn sys/<sys_password> as sysdba
-
create pfile from spfile;
-
edit <oracle_home>\database\init<SID>.ora
Change these parameters:
Processes = 600
Open_cursors = 1300
Compatible = 19.7.0
Add this parameter:
*.Sessions = 1000
-
Save the file.
-
Shutdown immediate.
The PDB instance will shutdown automatically if you shut down the CDB instance.
-
conn sys/<sys_password>@<SID of CDB> as sysdba.
-
create spfile from pfile;
-
startup