- Oracle管理
修改为lock_sga报错,11g已经自动管理
时间：2014/11/7 21:16:55 作者：solgle 来源：www.solgle.com 查看：1391 评论：0内容摘要：修改Oracle参数后导致数据启动失败，如：设置lock_sga=true后重启数据库失败C:\Users\user>sqlplus sys/********@samp001_solgle as sysdbaSQL*Plus: Release 11.2.0.1.0 Product...修改Oracle参数后导致数据启动失败，如：设置lock_sga=true后重启数据库失败C:\Users\user>sqlplus sys/********@samp001_solgle as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 3 15:56:05 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management,OLAP,Data Mining and Real Application Testing optionsSQL> alter system set lock_sga=true scope=spfile sid='*';System altered.SQL>[grid@rac1 bin]$ ./srvctl stop database -d solgle[grid@rac1 bin]$ ./srvctl start database -d solglePRCR-1079 : Failed to start resource ora.solgle.dbCRS-5017: The resource action "ora.solgle.db start" encountered the following error:ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together. For details refer to "(:CLSN00107:)" in "/u01/app/grid/11.2.0/log/rac1/agent/crsd/oraagent_oracle/oraagent_oracle.log".CRS-5017: The resource action "ora.solgle.db start" encountered the following error:ORA-00847: MEMORY_TARGET/MEMORY_MAX_TARGET and LOCK_SGA cannot be set together. For details refer to "(:CLSN00107:)" in "/u01/app/grid/11.2.0/log/rac2/agent/crsd/oraagent_oracle/oraagent_oracle.log".CRS-2674: Start of 'ora.solgle.db' on 'rac1' failedCRS-2674: Start of 'ora.solgle.db' on 'rac2' failedCRS-2632: There are no more servers to try to place resource 'ora.solgle.db' on that would satisfy its placement policy[grid@rac1 bin]$---11g采用内存自动管理，明显与sga_lock冲突，其它参数修改错误类同ORA-12514: TNS:listener does not currently know of service requested in connect descriptorC:\Users\user>sqlplus sys/********@samp001_solgle as sysdba;SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 4 09:07:13 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-12514: TNS:listener does not currently know of service requested in connect descriptorEnter user-name:---连接服务器看服务状态[grid@rac1 bin]$ ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE rac1ONLINE ONLINE rac2ora.DATA2.dgONLINE ONLINE rac1ONLINE ONLINE rac2ora.LISTENER.lsnrONLINE ONLINE rac1ONLINE ONLINE rac2ora.asmONLINE ONLINE rac1 StartedONLINE ONLINE rac2 Startedora.gsdOFFLINE OFFLINE rac1OFFLINE OFFLINE rac2ora.net1.networkONLINE ONLINE rac1ONLINE ONLINE rac2ora.onsONLINE ONLINE rac1ONLINE ONLINE rac2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac1ora.cvu1 ONLINE ONLINE rac1ora.solgle.db1 ONLINE OFFLINE Instance Shutdown2 ONLINE OFFLINE Instance Shutdownora.oc4j1 ONLINE ONLINE rac1ora.rac1.vip1 ONLINE ONLINE rac1ora.rac2.vip1 ONLINE ONLINE rac2ora.scan1.vip1 ONLINE ONLINE rac1[grid@rac1 bin]$---数据库没有启动，监听不能识别该服务了[grid@rac1 bin]$ su - oraclePassword:[oracle@rac1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 4 07:37:17 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-12162: TNS:net service name is incorrectly specifiedEnter user-name:[oracle@rac1 ~]$[oracle@rac1 ~]$ export ORACLE_SID=solgle[oracle@rac1 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 4 07:39:18 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL>---创建pfileSQL> create pfile="hao123.ora" from spfile;create pfile="hao123.ora" from spfile*ERROR at line 1:ORA-02236: invalid file name[oracle@rac1 ~]$ cd /u02/app/product/11.2.0/dbname_1/dbs[oracle@rac1 dbs]$ lshc_solgle1.dat init.ora initsolgle1.ora orapwsolgle1 snapcf_solgle1.f[oracle@rac1 dbs]$ cat initsolgle1.oraSPFILE='+DATA1/solgle/spfilesolgle.ora'SQL> create pfile='/u02/app/product/11.2.0/dbname_1/dbs/hao123.ora' from spfile='+DATA1/solgle/spfilesolgle.ora';File created.SQL>---回到主机[oracle@rac1 ~]$ cd /u02/app/product/11.2.0/dbname_1/dbs/[oracle@rac1 dbs]$ lshao123.ora hc_solgle1.dat init.ora initsolgle1.ora orapwsolgle1 snapcf_solgle1.f[oracle@rac1 dbs]$ vi hao123.ora... ...solgle1.instance_number=1solgle2.instance_number=2######*.lock_sga=TRUE ---注释掉这行（或者同理修改）*.memory_target=1050673152... ...:wq!---回到sqlplusSQL> create spfile='+DATA1/solgle/spfilesolgle.ora' from pfile='/u02/app/product/11.2.0/dbname_1/dbs/hao123.ora';File created.SQL>----回到服务器黑屏下[oracle@rac1 dbs]$ su - gridPassword:[grid@rac1 ~]$ cd /u01/app/grid/11.2.0/bin/[grid@rac1 bin]$ ./srvctl start database -d solgle[grid@rac1 bin]$---数据库已经启动成功[grid@rac1 bin]$ ./crsctl stat res -t--------------------------------------------------------------------------------NAME TARGET STATE SERVER STATE_DETAILS--------------------------------------------------------------------------------Local Resources--------------------------------------------------------------------------------ora.DATA1.dgONLINE ONLINE rac1ONLINE ONLINE rac2ora.DATA2.dgONLINE ONLINE rac1ONLINE ONLINE rac2ora.LISTENER.lsnrONLINE ONLINE rac1ONLINE ONLINE rac2ora.asmONLINE ONLINE rac1 StartedONLINE ONLINE rac2 Startedora.gsdOFFLINE OFFLINE rac1OFFLINE OFFLINE rac2ora.net1.networkONLINE ONLINE rac1ONLINE ONLINE rac2ora.onsONLINE ONLINE rac1ONLINE ONLINE rac2--------------------------------------------------------------------------------Cluster Resources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1 ONLINE ONLINE rac1ora.cvu1 ONLINE ONLINE rac1ora.solgle.db1 ONLINE ONLINE rac1 Open2 ONLINE ONLINE rac2 Openora.oc4j1 ONLINE ONLINE rac1ora.rac1.vip1 ONLINE ONLINE rac1ora.rac2.vip1 ONLINE ONLINE rac2ora.scan1.vip1 ONLINE ONLINE rac1[grid@rac1 bin]$出处：solgle
网址：www.solgle.com
- 相关文章
- 相关评论
- 本类更新
- 本类排行
-
12-2sysaux表空间占用率很高是awr太多？
-
4-8dbca创建数据库时,No protocol specified
-
12-23检查rac服务时，发现ons服务offline
-
4-9解决rac服务ora.DATA1.dg及rac2数据库offline
-
2-1Interval按日期建立了分区,找到某个时间段对应的分区被释放空间
-
9-7Oracle flash_recovery_area满了的解决办法
-
7-8ORA-02303:无法使用类型或表的相关性来删除或取代一个类型
-
12-1asmcmd登陆问题小计
-
8-2[INS-30507] Empty ASM disk group
-
4-11sqlldr数据导入导出案例
-
Copyright © 2013-2028 solgle.com,All rights reserved.[solgle.com] 公安机关备案号:51010802000219
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1
Email:solgle@solgle.com; weixin:cd1008610000 ICP:蜀ICP备14011070号-1
