Friday, July 12, 2019

Canvas Types in Oracle Forms 11g

 Oracle Forms provides four types of canvases, all of which can be displayed in the same window at runtime. A canvas' type defines how Oracle Forms will display it in the window to which it is assigned. When you create a canvas, you specify its type by setting the Canvas Type property. The four canvas types are: 
  • Content 
  • Stacked 
  • Tab 
  • Toolbar

Content Canvas :
The most common canvas type is the content canvas (the default type). A content canvas is the "base" view that occupies the entire content pane of the window in which it is displayed. You must define at least one content canvas for each window you create.
Stacked Canvas:
A stacked canvas is displayed atop-or stacked on-the content canvas assigned to the current window. Stacked canvases obscure some part of the underlying content canvas, and often are shown and hidden programmatically. You can display more than one stacked canvas in a window at the same time.
Tab Canvas:
A tab canvas-made up of one or more tab pages-allows you to group and display a large amount of related information on a single dynamic Oracle Forms canvas object. Like stacked canvases, tab canvases are displayed on top of a content canvas, partly obscuring it. Tab pages (that collectively comprise the tab canvas) each display a subset of the information displayed on the entire tab canvas.
Toolbar Canvas:

A toolbar canvas often is used to create toolbars for individual windows. You can create two types of toolbar canvases: horizontal or vertical. Horizontal toolbar canvases are displayed at the top of a window, just under its menu bar, while vertical toolbars are displayed along the far left edge of a window.

More details can be found at:
https://www.oracle.com/technetwork/developer-tools/forms/documentation/index.html

Thursday, July 11, 2019

How can we find the location of TNS file?

go to command prompt and type below and press enter

tnsping <dbname>

ORA-01403: no data found

ORA-01403: no data found will commonly occur in below scenarios:

  • Implicit cursors without proper error handling: example below:


DECLARE
   v_empno   NUMBER (9);
BEGIN
   SELECT empno
     INTO v_empno
     FROM emp
    WHERE ename LIKE 'Z%';
END;
Error at line 2
ORA-01403: no data found
ORA-06512: at line 4

The most common oracle errors ( oracle 11g)

ORA-00000 to ORA-00851:

ORA-00000: normal, successful completion
ORA-00001: unique constraint (string.string) violated
ORA-00017: session requested to set trace event
ORA-00018: maximum number of sessions exceeded
ORA-00019: maximum number of session licenses exceeded
ORA-00020: maximum number of processes (string) exceeded
ORA-00021: session attached to some other process; cannot switch session
ORA-00022: invalid session ID; access denied
ORA-00023: session references process private memory; cannot detach session
ORA-00024: logins from more than one process not allowed in single-process mode
ORA-00025: failed to allocate string
ORA-00026: missing or invalid session ID
ORA-00027: cannot kill current session
ORA-00028: your session has been killed
ORA-00029: session is not a user session
ORA-00030: User session ID does not exist.
ORA-00031: session marked for kill
ORA-00032: invalid session migration password
ORA-00033: current session has empty migration password
ORA-00034: cannot string in current PL/SQL session
ORA-00036: maximum number of recursive SQL levels (string) exceeded
ORA-00037: cannot switch to a session belonging to a different server group
ORA-00038: Cannot create session: server group belongs to another user
ORA-00039: error during periodic action
ORA-00040: active time limit exceeded - call aborted
ORA-00041: active time limit exceeded - session terminated
ORA-00042: Unknown Service name string
ORA-00043: remote operation failed
ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC
ORA-00050: operating system error occurred while obtaining an enqueue
ORA-00051: timeout occurred while waiting for a resource
ORA-00052: maximum number of enqueue resources (string) exceeded
ORA-00053: maximum number of enqueues exceeded
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-00055: maximum number of DML locks exceeded
ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode
ORA-00057: maximum number of temporary table locks exceeded
ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)
ORA-00059: maximum number of DB_FILES exceeded
ORA-00060: deadlock detected while waiting for resource
ORA-00061: another instance has a different DML_LOCKS setting
ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0
ORA-00063: maximum number of log files exceeded string
ORA-00064: object is too large to allocate on this O/S (string,string,string)
ORA-00065: initialization of FIXED_DATE failed
ORA-00066: SID string contains an illegal character
ORA-00067: invalid value string for parameter string; must be at least string
ORA-00068: invalid value string for parameter string, must be between string and string
ORA-00069: cannot acquire lock -- table locks disabled for string
ORA-00070: command string is not valid
ORA-00071: process number must be between 1 and string
ORA-00072: process "string" is not active
ORA-00073: command string takes between string and string argument(s)
ORA-00074: no process has been specified
ORA-00075: process "string" not found in this instance
ORA-00076: dump string not found
ORA-00077: dump string is not valid
ORA-00078: cannot dump variables by name
ORA-00079: variable string not found
ORA-00080: invalid global area specified by level string
ORA-00081: address range [string, string) is not readable
ORA-00082: memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
ORA-00083: warning: possibly corrupt SGA mapped
ORA-00084: global area must be PGA, SGA, or UGA
ORA-00085: current call does not exist
ORA-00086: user call does not exist
ORA-00087: command cannot be executed on remote instance
ORA-00088: command cannot be executed by shared server
ORA-00089: invalid instance number in ORADEBUG command
ORA-00090: failed to allocate memory for cluster database ORADEBUG command
ORA-00091: LARGE_POOL_SIZE must be at least string
ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
ORA-00093: string must be between string and string
ORA-00094: string requires an integer value
ORA-00096: invalid value string for parameter string, must be from among string
ORA-00097: use of Oracle SQL feature not in SQL92 string Level
ORA-00098: creating or mounting the database requires a parameter file
ORA-00099: warning: no parameter file was specified
ORA-00100: no data found
ORA-00101: invalid specification for system parameter DISPATCHERS
ORA-00102: network protocol string cannot be used by dispatchers
ORA-00103: invalid network protocol; reserved for use by dispatchers
ORA-00104: deadlock detected; all public servers blocked waiting for resources
ORA-00105: too many dispatcher configurations
ORA-00106: cannot startup/shutdown database when connected to a dispatcher
ORA-00107: failed to connect to ORACLE listener process
ORA-00108: failed to set up dispatcher to accept connection asynchronously
ORA-00109: invalid value for attribute string: string
ORA-00110: invalid value string for attribute string, must be between string and string
ORA-00111: invalid attribute string
ORA-00112: value of string is null
ORA-00113: protocol name string is too long
ORA-00114: missing value for system parameter SERVICE_NAMES
ORA-00115: connection refused; dispatcher connection table is full
ORA-00116: SERVICE_NAMES name is too long
ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified
ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
ORA-00119: invalid specification for system parameter string
ORA-00122: cannot initialize network configuration
ORA-00123: idle public server terminating
ORA-00125: connection refused; invalid presentation
ORA-00126: connection refused; invalid duplicity
ORA-00127: dispatcher string does not exist
ORA-00128: this command requires a dispatcher name
ORA-00129: listener address validation failed 'string'
ORA-00130: invalid listener address 'string'
ORA-00131: network protocol does not support registration 'string'
ORA-00132: syntax error or unresolved network name 'string'
ORA-00133: value of string is too long
ORA-00134: invalid DISPATCHERS specification #string
ORA-00150: duplicate transaction ID
ORA-00151: invalid transaction ID
ORA-00152: current session does not match requested session
ORA-00153: internal error in XA library
ORA-00154: protocol error in transaction monitor
ORA-00155: cannot perform work outside of global transaction
ORA-00160: global transaction length string is greater than maximum (string)
ORA-00161: transaction branch length string is illegal (maximum allowed string)
ORA-00162: external dbid length string is greater than maximum (string)
ORA-00163: internal database name length string is greater than maximum (string)
ORA-00164: distributed autonomous transaction disallowed within migratable distributed transaction
ORA-00165: migratable distributed autonomous transaction with remote operation is not allowed
ORA-00166: remote/local nesting level is too deep
ORA-00200: control file could not be created
ORA-00201: control file version string incompatible with ORACLE version string
ORA-00202: control file: 'string'
ORA-00203: using the wrong control files
ORA-00204: error in reading (block string, # blocks string) of control file
ORA-00205: error in identifying control file, check alert log for more info
ORA-00206: error in writing (block string, # blocks string) of control file
ORA-00207: control files are not for the same database
ORA-00208: number of control file names exceeds limit of string
ORA-00209: control file blocksize mismatch, check alert log for more info
ORA-00210: cannot open the specified control file
ORA-00211: control file does not match previous control files
ORA-00212: block size string below minimum required size of string bytes
ORA-00213: cannot reuse control file; old file size string, string required
ORA-00214: control file 'string' version string inconsistent with file 'string' version string
ORA-00215: must be at least one control file
ORA-00216: control file could not be resized for migration from 8.0.2
ORA-00217: control file could not be resized for new record types
ORA-00218: block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
ORA-00219: required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)
ORA-00220: control file not mounted by first instance, check alert log for more info
ORA-00221: error on write to control file
ORA-00222: operation would reuse name of a currently mounted control file
ORA-00223: convert file is invalid or incorrect version
ORA-00224: control file resize attempted with illegal record type (string)
ORA-00225: expected size string of control file differs from actual size string
ORA-00226: operation disallowed while alternate control file open
ORA-00227: corrupt block detected in control file: (block string, # blocks string)
ORA-00228: length of alternate control file name exceeds maximum of string
ORA-00229: operation disallowed: already hold snapshot control file enqueue
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
ORA-00231: snapshot control file has not been named
ORA-00232: snapshot control file is nonexistent, corrupt, or unreadable
ORA-00233: copy control file is corrupt or unreadable
ORA-00234: error in identifying or opening snapshot or copy control file
ORA-00235: control file read without a lock inconsistent due to concurrent update
ORA-00236: snapshot operation disallowed: mounted control file is a backup
ORA-00237: snapshot operation disallowed: control file newly created
ORA-00238: operation would reuse a filename that is part of the database
ORA-00239: timeout waiting for control file enqueue: held by 'string' for more than string seconds
ORA-00240: control file enqueue held for more than string seconds
ORA-00250: archiver not started
ORA-00251: LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string
ORA-00252: log string of thread string is empty, cannot archive
ORA-00253: character limit string exceeded by archive destination string string
ORA-00254: error in archive control string 'string'
ORA-00255: error archiving log string of thread string, sequence # string
ORA-00256: cannot translate archive destination string string
ORA-00257: archiver error. Connect internal only, until freed.
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
ORA-00259: log string of open instance string (thread string) is the current log, cannot archive
ORA-00260: cannot find online log sequence string for thread string
ORA-00261: log string of thread string is being archived or modified
ORA-00262: current log string of closed thread string cannot switch
ORA-00263: there are no logs that need archiving for thread string
ORA-00264: no recovery required
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
ORA-00266: name of archived log file needed
ORA-00267: name of archived log file not needed
ORA-00268: specified log file does not exist 'string'
ORA-00269: specified log file is part of thread string not string
ORA-00270: error creating archive log string
ORA-00271: there are no logs that need archiving
ORA-00272: error writing archive log string
ORA-00273: media recovery of direct load data that was not logged
ORA-00274: illegal recovery option string
ORA-00275: media recovery has already been started
ORA-00276: CHANGE keyword specified but no change number given
ORA-00277: illegal option to the UNTIL recovery flag string
ORA-00278: log file 'string' no longer needed for this recovery
ORA-00279: change string generated at string needed for thread string
ORA-00280: change string for thread string is in sequence #string
ORA-00281: media recovery may not be performed using dispatcher
ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER
ORA-00283: recovery session canceled due to errors
ORA-00284: recovery session still in progress
ORA-00285: TIME not given as a string constant
ORA-00286: no members available, or no member contains valid data
ORA-00287: specified change number string not found in thread string
ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE
ORA-00289: suggestion : string
ORA-00290: operating system archival error occurred. See error below
ORA-00291: numeric value required for PARALLEL option
ORA-00292: parallel recovery feature not installed
ORA-00293: control file out of sync with redo log
ORA-00294: invalid archivelog format specifier 'string'
ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string
ORA-00296: maximum number of files (string) exceeded for RECOVER DATAFILE LIST
ORA-00297: must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START
ORA-00298: Missing or invalid attribute value
ORA-00299: must use file-level media recovery on data file string
ORA-00300: illegal redo log block size string specified - exceeds limit of string
ORA-00301: error in adding log file 'string' - file cannot be created
ORA-00302: limit of string logs exceeded
ORA-00303: cannot process Parallel Redo
ORA-00304: requested INSTANCE_NUMBER is busy
ORA-00305: log string of thread string inconsistent; belongs to another database
ORA-00306: limit of string instances in this database
ORA-00307: requested INSTANCE_NUMBER out of range, maximum is string
ORA-00308: cannot open archived log 'string'
ORA-00309: log belongs to wrong database
ORA-00310: archived log contains sequence string; sequence string required
ORA-00311: cannot read header from archived log
ORA-00312: online log string thread string: 'string'
ORA-00313: open failed for members of log group string of thread string
ORA-00314: log string of thread string, expected sequence# string doesn't match string
ORA-00315: log string of thread string, wrong thread # string in header
ORA-00316: log string of thread string, type string in header is not log file
ORA-00317: file type string in header is not log file
ORA-00318: log string of thread string, expected file size string doesn't match string
ORA-00319: log string of thread string has incorrect log reset status
ORA-00320: cannot read file header from log string of thread string
ORA-00321: log string of thread string, cannot update log file header
ORA-00322: log string of thread string is not current copy
ORA-00323: Current log of thread string not useable and all others need archiving
ORA-00324: log file 'string' translated name 'string' too long, string characters exceeds string limit
ORA-00325: archived log for thread string, wrong thread # string in header
ORA-00326: log begins at change string, need earlier change string
ORA-00327: log string of thread string, physical size string less than needed string
ORA-00328: archived log ends at change string, need later change string
ORA-00329: archived log begins at change string, need change string
ORA-00330: archived log ends at change string, need change string
ORA-00331: log version string incompatible with ORACLE version string
ORA-00332: archived log is too small - may be incompletely archived
ORA-00333: redo log read error block string count string
ORA-00334: archived log: 'string'
ORA-00335: online log string: No log with this number, log does not exist
ORA-00336: log file size string blocks is less than minimum string blocks
ORA-00337: log file 'string' does not exist and no size specified
ORA-00338: log string of thread string is more recent than control file
ORA-00339: archived log does not contain any redo
ORA-00340: IO error processing online log string of thread string
ORA-00341: log string of thread string, wrong log # string in header
ORA-00342: archived log does not have expected resetlogs SCN string
ORA-00344: unable to re-create online log 'string'
ORA-00345: redo log write error block string count string
ORA-00346: log member marked as STALE and closed
ORA-00347: log string of thread string, expected block size string doesn't match string
ORA-00348: single-process redo failure. Must abort instance
ORA-00349: failure obtaining block size for 'string'
ORA-00350: log string of instance string (thread string) needs to be archived
ORA-00351: recover-to time invalid
ORA-00352: all logs for thread string need to be archived - cannot enable
ORA-00353: log corruption near block string change string time string
ORA-00354: corrupt redo log block header
ORA-00355: change numbers out of order
ORA-00356: inconsistent lengths in change description
ORA-00357: too many members specified for log file, the maximum is string
ORA-00358: Too many file members specified, the maximum is string
ORA-00359: logfile group string does not exist
ORA-00360: not a logfile member: string
ORA-00361: cannot remove last log member string for group string
ORA-00362: member is required to form a valid logfile in group string
ORA-00363: log is not the archived version
ORA-00364: cannot write header to new log member
ORA-00365: the specified log is not the correct next log
ORA-00366: log string of thread string, checksum error in the file header
ORA-00367: checksum error in log file header
ORA-00368: checksum error in redo log block
ORA-00369: Current log of thread string not useable and other log being cleared
ORA-00370: potential deadlock during kcbchange operation
ORA-00371: not enough shared pool memory, should be atleast string bytes
ORA-00372: file string cannot be modified at this time
ORA-00373: online log version string incompatible with ORACLE version string
ORA-00374: parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
ORA-00376: file string cannot be read at this time
ORA-00377: Frequent backups of file string causing write operation to stall
ORA-00378: buffer pools cannot be created as specified
ORA-00379: no free buffers available in buffer pool string for block size stringK
ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size
ORA-00381: cannot use both new and old parameters for buffer cache size specification
ORA-00382: string not a valid block size, valid range [string..string]
ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero
ORA-00384: Insufficient memory to grow cache
ORA-00385: cannot enable Very Large Memory with new buffer cache parameters
ORA-00386: use_indirect_data_buffers not supported
ORA-00390: log string of thread string is being cleared, cannot become current log
ORA-00391: All threads must switch to new log format at the same time
ORA-00392: log string of thread string is being cleared, operation not allowed
ORA-00393: log string of thread string is needed for recovery of offline datafiles
ORA-00394: online log reused while attempting to archive it
ORA-00395: online logs for the clone database must be renamed
ORA-00396: error string required fallback to single-pass recovery
ORA-00397: instance recovery process terminated with error
ORA-00398: abort thread recovery due to reconfiguration
ORA-00399: corrupt change description in redo log
ORA-00400: invalid release value string for parameter string
ORA-00401: the value for parameter string is not supported by this release
ORA-00402: database changes by release string cannot be used by release string
ORA-00403: string (string) is not the same as other instances (string)
ORA-00404: Convert file not found: 'string'
ORA-00405: compatibility type "string"
ORA-00406: COMPATIBLE parameter needs to be string or greater
ORA-00407: rolling upgrade from release string.string to string.string is not allowed
ORA-00408: parameter string is set to TRUE
ORA-00409: COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
ORA-00437: ORACLE feature is not licensed. Contact Oracle Corp. for assistance
ORA-00438: string Option not installed
ORA-00439: feature not enabled: string
ORA-00443: background process "string" did not start
ORA-00444: background process "string" failed while starting
ORA-00445: background process "string" did not start after string seconds
ORA-00446: background process started when not expected
ORA-00447: fatal error in background process
ORA-00448: normal completion of background process
ORA-00449: background process 'string' unexpectedly terminated with error string
ORA-00450: background process 'string' did not start
ORA-00451: foreground process died unexpectedly
ORA-00452: foreground process unexpectedly terminated with error string
ORA-00453: backgroud process 'string' is dead
ORA-00469: CKPT process terminated with error
ORA-00470: LGWR process terminated with error
ORA-00471: DBWR process terminated with error
ORA-00472: PMON process terminated with error
ORA-00473: ARCH process terminated with error
ORA-00474: SMON process terminated with error
ORA-00475: TRWR process terminated with error
ORA-00476: RECO process terminated with error
ORA-00477: SNP* process terminated with error
ORA-00478: SMON process terminated due to error string
ORA-00479: RVWR process terminated with error string
ORA-00480: LCK* process terminated with error
ORA-00481: LMON process terminated with error
ORA-00482: LMD* process terminated with error
ORA-00483: During shutdown a process abnormally terminated
ORA-00484: LMS* process terminated with error
ORA-00485: DIAG process terminated with error string
ORA-00486: ASMB process terminated with error
ORA-00487: CTWR process terminated with error
ORA-00488: RBAL process terminated with error
ORA-00489: ARB* process terminated with error
ORA-00490: PSP process terminated with error
ORA-00491: RMS0 process terminated with error
ORA-00492: GTX* process terminated with error
ORA-00493: GMON process terminated with error
ORA-00494: enqueuestring held for too longstring by 'string'
ORA-00566: cannot request processor group - NUMA not enabled
ORA-00567: Requested processor group string is too large (maximum string)
ORA-00568: Maximum number of interrupt handlers exceeded
ORA-00569: Failed to acquire global enqueue.
ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string], [string], [string], [string], [string]
ORA-00601: cleanup lock conflict
ORA-00602: internal programming exception
ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level string
ORA-00606: Internal error code
ORA-00607: Internal error occurred while making a change to a data block
ORA-00608: testing error [string] [string] [string] [string] [string]
ORA-00609: could not attach to incoming connection
ORA-00610: Internal error code
ORA-00700: soft internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
ORA-00701: object necessary for warmstarting database cannot be altered
ORA-00702: bootstrap verison 'string' inconsistent with version 'string'
ORA-00703: maximum number of row cache instance locks exceeded
ORA-00704: bootstrap process failure
ORA-00705: inconsistent state during start up; shut down the instance, then restart it
ORA-00706: error changing format of file 'string'
ORA-00710: new tablespace name is the same as the old tablespace name
ORA-00711: new tablespace name is invalid
ORA-00712: cannot rename system tablespace
ORA-00720: ALTER DATABASE RESET COMPATIBILITY command has been de-supported
ORA-00721: changes by release string cannot be used by release string
ORA-00722: Feature "string"
ORA-00723: Initialization parameter COMPATIBLE must be explicitly set
ORA-00724: ALTER DATABASE CONVERT command has been de-supported
ORA-00725: Desupported ALTER DATABASE SET STANDBY clause specified: string
ORA-00740: datafile size of (string) blocks exceeds maximum file size
ORA-00741: logfile size of (string) blocks exceeds maximum logfile size
ORA-00750: database has been previously mounted and dismounted
ORA-00751: could not obtain resilvering status for file
ORA-00752: recovery detected a lost write of a data block
ORA-00820: Specified value of sga_max_size is too small, needs to be at least stringM
ORA-00821: Specified value of sga_target stringM is too small, needs to be at least stringM
ORA-00822: MMAN process terminated with error
ORA-00823: Specified value of sga_target greater than sga_max_size
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings
ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set
ORA-00826: cannot set SGA_TARGET or MEMORY_TARGET for an ASM instance
ORA-00827: could not shrink sga_target to specified value
ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings
ORA-00830: cannot set statistics_level to BASIC with auto-tune SGA enabled
ORA-00832: no streams pool created and cannot automatically create one
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
ORA-00838: Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-00839: SGA_TARGET cannot be modified to the specified value
ORA-00840: PGA_AGGREGATE_TARGET cannot be modified to the specified value
ORA-00841: MEMORY_TARGET not supported on this system
ORA-00842: DB_BLOCK_BUFFERS cannot be set with SGA_TARGET or MEMORY_TARGET
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00844: Parameter not taking MEMORY_TARGET into account
ORA-00845: MEMORY_TARGET not supported on this system
ORA-00846: could not shrink MEMORY_TARGET to specified value
ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET
ORA-00849: SGA_TARGET string cannot be set to more than MEMORY_MAX_TARGET string.
ORA-00850: PGA_AGGREGATE_TARGET string cannot be set to more than MEMORY_MAX_TARGET string.
ORA-00851: SGA_MAX_SIZE string cannot be set to more than MEMORY_TARGET string.

Here's the detailed level of errors: