MaksymBilenko / docker-oracle-12c

:whale: Docker image with Oracle Database 12c on board
Apache License 2.0
685 stars 288 forks source link

Unable to increase processes in oracle 12 c docker #51

Closed pavansinguluri closed 7 years ago

pavansinguluri commented 7 years ago

Am trying to increase processes for oracle 12 c.But i get the following exception SQL> show parameter processes;

NAME TYPE VALUE


aq_tm_processes integer 1 db_writer_processes integer 1 gcs_server_processes integer 0 global_txn_processes integer 1 job_queue_processes integer 1000 log_archive_max_processes integer 4 processes integer 300 SQL> alter system set processes=500 scope=spfile; alter system set processes=500 scope=spfile * ERROR at line 1: ORA-65040: operation not allowed from within a pluggable database

MaksymBilenko commented 7 years ago

try to shudown database firts and then set parameters and then startup;

MaksymBilenko commented 7 years ago
SQL> alter system set processes=500 scope=spfile;

System altered.

SQL> alter system set sessions=555 scope=spfile;

System altered.

SQL> alter system set transactions=610 scope=spfile;

System altered.
greeshmakr commented 3 years ago

@MaksymBilenko Hi, I am also getting the same error, when trying to set the processes in Oracle 18c (Pluggable Database). Tried after shutdown and startup too.

SQL> show con_name;

CON_NAME


XEPDB1 SQL> shutdown immediate; Pluggable Database closed. SQL> alter system set processes=500 scope=spfile; alter system set processes=500 scope=spfile * ERROR at line 1: ORA-65040: operation not allowed from within a pluggable database

SQL> startup; Pluggable Database opened.