I have several Oracle 10.2.0.2 databases running in dedicated server mode, all configured with a positive SGA_TARGET parameter. For most, the SGA_TARGET_ADVICE view shows expected results. A few of the small DBs (SGA < 2G) give me a ORA-1476 error when I execute this view. Why?
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.