ORA-00838: Memory_target too small

ORA-00838: Specified value of MEMORY_TARGET is too 

small

Oracle Tips by Burleson

October 16, 2014

Question:  After increasing by "processes" parameter (processes 3000), I got the following ORA-00838 error at database startup time.  Note that I am on 12c and I have not set my sga_target or pga_aggregate_target parameter.  After re-setting processes=1000 the ORA-00838 error disappeared.  Why?

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least 3072M
ORA-01078: failure in processing system parameters

How do I correct the ORA-00838 error?

Answer:  The oerr utility  shows the cause and action for the ORA-02097:

ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least string

Cause: The specified value of MEMORY_TARGET was less than the sum of the specified values for SGA_TARGET and PGA_AGGREGATE_TARGET.

Action: Set MEMORY_TARGET to at least the recommended value.

In this case the increase of your processes parameter was the root cause of the ORA-00838 error.  As we my know the processes parameter determines the sessions parameter that this must, in turn, indicate to Oracle that additional RAM is required to support the extra sessions.
As a workaround, of course, you can increase your memory_target parameter value.

ora-12560: TNS Protocol adapter error Troubleshooting

ORA-12560 error 

Auto-start database

1. go to the command prompt. (as administrator)

Check all your instances running

C;> lsnrctl status

2. Set the Oracle system ID (SID) to

C:> set oracle_sid=ORCL.

3. Run the Net Start command (

C:>net start oracleserviceORCL).

This should resolve the ORA-12560 error in this situation

Reference

https://www.tekstream.com/resource-center/ora-12560-tns-protocol-adapter-error/

Tutorial for Starting Oracle Listener

https://apexapps.oracle.com/pls/apex/f?p=44785:24:1463842410715:PRODUCT:::P24_CONTENT_ID,P24_PREV_PAGE,P24_PROD_SECTION_GRP_ID:6284,141,116