Init.ora

[esantos]

Quando eu altero o parametro process no init.ora eu tenho que restartar o oracle




*.processes=700

[gilbertoca]

E a resposta é ...

Selecionar tudo

gilberto@TI-DES05:~> source .oracleDB
gilberto@TI-DES05:~> export ORACLE_SID=meu
gilberto@TI-DES05:~> sqlplus / as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on Sex Set 29 10:26:49 2006

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

Connected to an idle instance.

idle> startup
ORACLE instance started.

Total System Global Area  536870912 bytes
Fixed Size                   779724 bytes
Variable Size             510401076 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
Database mounted.
Database opened.
idle> show parameter process

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                  integer     10
log_archive_max_processes            integer     2
processes                            integer     250
idle> alter system set processes=700 scope=both;
alter system set processes=700 scope=both
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


idle>

[esantos]

Muito obrigado pela resposta.

Agora está funcionando perfeitamente.

Abraço

Edenilson Santos