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

make: perl: Command not found make: *** [ins_rdbms.mk:573: javavm_refresh] Error 127 '

 Error:  Patching component oracle.javavm.client, 19.0.0.0.0... Make failed to invoke "/usr/bin/make -f ins_rdbms.mk javavm_refresh ORA...