Silahkan Melihat Tutorial di website kami dengan nyaman ENJOY YOUR LIFE ☕

ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together

Problem:
[oracle@PTUDServer3 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 8 17:48:32 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together
SQL> exit
Disconnected
Solution:
[oracle@PTUDServer3 dbs]$ pwd
/u01/app/oracle/product/12.1.0/db_1/dbs
[oracle@PTUDServer3 dbs]$ more initorcl.ora
orcl.__data_transfer_cache_size=0
orcl.__db_cache_size=1325400064
orcl.__java_pool_size=16777216
orcl.__large_pool_size=33554432
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=1073741824
orcl.__sga_target=2147483648
orcl.__shared_io_pool_size=100663296
orcl.__shared_pool_size=637534208
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='12.1.0.0.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/recovery_area/orcl/co
ntrol02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_flashback_retention_target=4320
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/recovery_area'
*.db_recovery_file_dest_size=80530636800
*.db_securefile='PERMITTED'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=20
*.lock_sga=FALSE
*.memory_target=3072m
*.open_cursors=800
*.pga_aggregate_target=1073741824
*.processes=800
*.query_rewrite_enabled='TRUE'
*.query_rewrite_integrity='TRUSTED'
*.remote_login_passwordfile='EXCLUSIVE'
*.session_cached_cursors=200
*.sessions=500
*.sga_target=2147483648
*.shared_pool_size=629145600
*.undo_tablespace='UNDOTBS1'

[oracle@PTUDServer3 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Tue Sep 8 17:49:48 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup pfile="$ORACLE_HOME/dbs/initorcl.ora"
ORACLE instance started.

Total System Global Area 3206836224 bytes
Fixed Size    2293496 bytes
Variable Size 2080375048 bytes
Database Buffers 1107296256 bytes
Redo Buffers   16871424 bytes
Database mounted.
Database opened.
SQL> exit





0 komentar:

Post a Comment

ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together