Saturday, 15 June 2019

WARNING OGG-02045 DB does not have streams_pool_size initialization parameter.


WARNING:

2019-06-15 06:40:03  WARNING OGG-02045  Database does not have streams_pool_size initialization
 parameter configured.

Solution :

set streams_pool_size:

SQL> show parameter streams_pool_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 0

---set paramter as per the system: 

SQL> alter system set streams_pool_size=1G scope=spfile;   

System altered.


No comments:

Post a Comment

Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed

  Error:   [MY-010069] [Server] Failed to set up SSL because of the following SSL library error: SSL_CTX_set_default_verify_paths failed  [M...