重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: ORA-32010: cannot find entry to delete in SPFILE [打印本页]

---

作者: jiawang    时间: 2018-5-3 16:20
标题: ORA-32010: cannot find entry to delete in SPFILE

[oracle@strong ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production onThu May 3 10:55:54 2018

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

Connected to:

Oracle Database 11g Enterprise Edition Release11.2.0.4.0 - Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

SQL>

SQL> ALTER SYSTEM RESET memory_targetSCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM RESETmemory_max_target SCOPE=SPFILE;

ALTER SYSTEM RESET memory_max_targetSCOPE=SPFILE

*

ERROR at line 1:

ORA-32010: cannot findentry to delete in SPFILE

SQL> show parameter memory_max_target

NAME                                 TYPE        VALUE

------------------------------------ -----------------------------------------

memory_max_target                    big integer 6016M

SQL> create spfile from  pfile;

File created.

                                                

[oracle@strongdbs]$ ll

总用量 24

-rw-rw----. 1oracle dba 1544 5月   3 11:12 hc_YADATA.dat

-rw-r--r--. 1oracle dba 2851 5月  15 2009 init.ora

-rw-r--r--. 1oracle dba  927 5月   3 11:11 initYADATA.ora

-rw-r-----. 1oracle dba   24 6月  29 2017 lkYADATA

-rw-r-----. 1oracle dba 1536 6月  29 2017 orapwYADATA

-rw-r-----. 1oracle dba 2560 5月   3 11:12 spfileYADATA.ora

[oracle@strongdbs]$ vi initYADATA.ora

删除*.memory_target=6294967295

登录/注册后可看大图