step by install oracle11gr2rac for as5u364bit v第一部分物理环境准备

3、服务器中识别ISCSI设ISCIS包的安在RHEL5x86_64系统中,并安装iSCSI启动器RedHatEnterpriseLinuxServerrelease5.3Kernel2.6.18-128.el5onanx86_64login:rootLastlogin:ThuOct1501:35:27from10.10.10.121[root@rac1~]#mount-tiso9660/dev/dvd/mntmount:blockdevice/dev/dvdiswrite-protected,mountingread-only[root@rac1~]#cd/mnt/Server/[root@rac1Server]#lsiscsi-initiator-utils*[root@rac1Server]#rpm-ivhiscsi-initiator-utils-6.2.0.868-0.18.el5.x86_64.rpmwarning:iscsi-initiator-utils-6.2.0.868-0.18.el5.x86_64.rpm:HeaderV3DSAsignature:NOKEY,keyID37017186 1:iscsi-initiator-utils###########################################[root@rac1服务器端ISCSI的配#echo"InitiatorName=`iscsi-iname`">/etc/iscsi/initiatorname.iscsi[root@rac1Server]#cat/etc/iscsi/initiatorname.iscsi /#Startupsettings#Torequestthattheiscsiinitdscriptsstartupasessionsetto"automatic".#node.startup=automatic##Tomanuallystartupthesessionsetto"manual".Thedefaultisnode.startup=#*************#CHAPSettings##ToenableCHAPauthenticationsetnode.session.auth.authmethod#toCHAP.ThedefaultisNone.node.session.auth.authmethod=#TosetaCHAPusernameandpasswordfor#authenticationbythe(s),mentthefollowinglines: node.session.auth.password=ffccd3d5f87增加iSCSI启动器服务到系统#chkconfigiscsi--level35将ｃｌｉｅｎｔ端到上，两个节点均要执#iscsiadm-mdiscovery-tst-p在RAC1[root@rac1~]#sfdisk-/dev/sda:/dev/sdb:[root@rac1~]#在RAC2[root@rac2~]#sfdisk-/dev/sda:/dev/sdb:[root@rac2~]#第二部分环境准基础包的查询和安mount-oloopRHEL_5.3x86_64DVD.iso/mntcd/mnt/Serverrpm-qa|grepbinutils-rpm-qa|grepcompat-libstdc++-33-3.2.3rpm-qa|grepelfutils-libelf-0.125rpm-qa|grepelfutils-libelf-devel-0.125rpm-qa|grepgcc-4.1.2rpm-qa|grepgcc-c++-4.1.2rpm-qa|grepglibc-2.5-24rpm-qa|grep rpm-qa|grepglibc-devel-2.5rpm-qa|grepglibc-headers-2.5rpm-qa|grepksh-20060214rpm-qa|greplibaio-rpm-qa|greplibaio-devel-0.3.106rpm-qa|greplibgcc-4.1.2rpm-qa|greplibstdc++-4.1.2rpm-qa|greplibstdc++-develrpm-qa|grepmake-3.81rpm-qa|grepsysstat-7.0.2rpm-qa|grepunixODBC-2.2.11rpm-qa|grepunixODBC-devel-rpm-ivhbinutils-rpm-ivhcompat-libstdc++-*rpm-ivhelfutils-libelf-*rpm-ivhelfutils-libelf-devel-*rpm-ivhgcc-*rpm-ivhgcc-c++-*rpm-ivhglibc-*rpm-ivh rpm-ivhglibc-devel-*rpm-ivhglibc-headers-*rpm-ivhksh-*rpm-ivhlibaio-*rpm-ivhlibaio-devel-*rpm-ivhlibgcc-*rpm-ivhlibstdc++-*rpm-ivhlibstdc++-*rpm-ivhmake-*rpm-ivhsysstat-*rpm-ivhunixODBC-*rpm-ivhunixODBC-devel- /usr/sbin/groupadd-g1400/usr/sbin/useradd-u1100-goinstall-Gdba,asmdba,asmadmin,asmoper/usr/sbin/useradd-u1101-goinstall-Gdba,asmdba,oper安 的建mkdir-pmkdir-p/u01/app/11.2.0/gridchown-Rgri nstall/u01mkdir-pchown-Roracle:oinstall/u01/app/oracleod-R775/u01chown-Roracle:oinstall/u01od-R775/u01/passwdgrid相关内核参数、配置文件的修vi#ORACLE nofilenofile nofilenofilevi#ORACLEfs.aio-max-nr=fs.file-max=kernel.shmall=kernel.shmmax=kernel.shmmni=kernel.sem=25032000100net.core.wmem_max=Oracle用户相关的参数[oracle@rac1~]$cat#Donotremovethefollowingline,orvariousprograms#thatrequirenetworkfunctionalitywillfail. localhost.local localhost6.local6localhost610.10.20.11rac1.local10.10.20.12rac2.localrac210.10.30.11rac1-priv.localrac1-10.10.30.12rac2-priv.localrac2-priv[oracle@rac2~]$cat#Donotremovethefollowingline,orvariousprograms#thatrequirenetworkfunctionalitywillfail. localhost.local localhost6.local6localhost610.10.20.11rac1.local10.10.20.12rac2.localrac210.10.30.11rac1-priv.localrac1-10.10.30.12rac2-priv.localrac2-priv10.10.20.111rac1-vip.localrac1-10.10.20.112rac2-vip.localrac2-vip10.10.20.201rac-cluster.localrac-cluster[oracle@rac1~]$[oracle@rac1~]$cat##Sourceglobaldefinitionsif[-f/etc/bashrc];.#UserspecificaliasesandfunctionsORACLE_HOSTNAME=rac1.local;exportORACLE_HOSTNAMEORACLE_BASE=/u01/app/oracle;exportORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;exportORACLE_HOMEORACLE_SID=oradb1;exportORACLE_SIDORACLE_TERM=xterm;exportORACLE_TERMPATH=/usr/sbin:$PATH;exportPATHPATH=$ORACLE_HOME/bin:$PATH;exportPATHexportORACLE_UNQNAME=oradbLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;exportLD_LIBRARY_PATHif[$USER="oracle"];if[$S="/bin/ksh"];thenulimit-p16384ulimit-n65536ulimit-u16384-n[oracle@rac1[oracle@rac2~]$cat##Sourceglobaldefinitionsif[-f/etc/bashrc];.#UserspecificaliasesandfunctionsORACLE_HOSTNAME=rac2.local;exportORACLE_HOSTNAMEORACLE_BASE=/u01/app/oracle;exportORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;exportORACLE_HOMEORACLE_SID=oradb2;exportORACLE_SIDORACLE_TERM=xterm;exportORACLE_TERMPATH=/usr/sbin:$PATH;exportPATHPATH=$ORACLE_HOME/bin:$PATH;exportPATHexportORACLE_UNQNAME=oradbLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;exportLD_LIBRARY_PATHif[$USER="oracle"];if[$S="/bin/ksh"];thenulimit-p16384ulimit-n65536ulimit-u16384-n[oracle@rac2Gird时间同步所需要的设NetworkTimeProtocolchkconfigntpdoff安装和配置自动管理(ASMLib注意OracleASMLib2.0 [root@rac1backup]#cdasm2.6.18-128.el5/[root@rac1asm2.6.18-128.el5]#ls安rpm-UvhConfigureASMLibusingthefollowing配#/etc/init.d/oracleasmconfigure-iConfiguringtheOracleASMlibrarydriver.Thiswillconfiguretheon-bootpropertiesoftheOracleASMlibrarydriver.Thefollowingquestionswilldeterminewhetherthedriverisloadedonbootandwhatpermissionsitwillhave.Thecurrentvalueswillbeshowninbrackets('[]').Hitting<ENTER>withouttyananswerwillkeepthatcurrentvalue.Ctrl-Cwillabort.Defaultusertoownthedriverinterface[]:oracleDefaultgrouptoownthedriverinterface[]:dbaStartOracleASMlibrarydriveronboot(y/n)[y]:ScanforOracleASMdisksonboot(y/n)[y]:WritingOracleASMlibrarydriverconfiguration:doneInitializingtheOracleASMLibdriver:[OK]ScanningthesystemforOracleASMLibdisks:[OK]做ASM在RAC1[root@rac1~]#sfdisk-/dev/sda:/dev/sdb:total:287520240在RAC2上[root@rac1~]#sfdisk-/dev/sda:/dev/sdb:total:287520240做ASM卷，注意：rac1rac2在RAC1节点/usr/sbin/oracleasmcreatediskVOL1CRS/usr/sbin/oracleasmcreatediskVOL2/usr/sbin/oracleasmcreatediskVOL3（如何删除标不再被ASM使用的磁盘也可以取消标/etc/init.d/oracleasmdeletedisk/etc/init.d/oracleasmdeletedisk/etc/init.d/oracleasmdeletediskVOL3RemovingASMdisk"VOL1":[OK]可以查询任意的操作系统磁盘，以了解它是否被ASM使用[root@dbsvrtmp]#/etc/init.d/oracleasmquerydisk/dev/sdb2Device"/dev/sdb2"ismarkedanASMdiskwiththelabel"VOL1"[root@dbsvrtmp]#/etc/init.d/oracleasmquerydisk/dev/sdb3Device"/dev/sdb3"ismarkedanASMdiskwiththelabel"VOL2"[root@dbsvrtmp]#/etc/init.d/oracleasmquerydisk/dev/sdb4Device"/dev/sdb4"ismarkedanASMdiskwiththelabel"VOL3"）在两个节点，执[root@rac1~]#/usr/sbin/oracleasmlistdisks[root@ra2~]#/usr/sbin/oracleasmlistdisks第三部分：Grid集群的安[oracle@rac1]$./runInstallerStartingOracleUniversalInstaller...Addnode2 setup setup,then执行细[root@rac1~]#Changingpermissionsof/u01/app/oraInventory.Addingread,writepermissionsf Removingread,write,executepermissionsforworld.Changinggroupnameof/u01/app/oraInventorytooinstall.Theexecutionofthescriptiscomplete.[root@rac1~]#RunningOracle11groot.shThefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracleORACLE_HOME=Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Copyingdbhometo/usr/local/bin...Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/bin...Creating/etc/oratabEntrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofroot.shscript.Nowproduct-specificrootactionswillbeperformed.2009-11-0917:33:57:Parsingthehostname2009-11-0917:33:57:Checkingforsuperuserprivileges2009-11-0917:33:57:UserhassuperuserprivilegesUsingconfigurationparameterfile:CreatingtracedirectoryLOCALADDCreatingOCRkeysforuser'root',privgrp'root'..Operationsuccessful.rootrootwalletcertrootcertexportpeerwalletprofilereaderwalletpawalletpeerwalletkeyspawalletkeyspeercertrequestpacertrequestpeercertpapeerrootcertprofilereaderrootcertTPparootcertTPpeerpacertTP ercertprofilereaderpacertTPprofilereaderpeercertTPpeerusercertpauserAddingdaemontoCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.ohasdisstartingCRS-2672:Attemptingtostart'ora.gipcd'on'rac1'CRS-2672:Attemptingtostart'ora.mdnsd'on'rac1'CRS-2676:Startof'ora.mdnsd'on'rac1'succeededCRS-2676:Startof'ora.gipcd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'rac1'CRS-2676:Startof'ora.gpnpd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'rac1'CRS-2676:Startof'ora.cssdmonitor'on'rac1'succeededCRS-2672:Attemptingtostart'ora.cssd'on'rac1'CRS-2672:Attemptingtostart'ora.diskmon'on'rac1'CRS-2676:Startof'ora.diskmon'on'rac1'succeededCRS-2676:Startof'ora.cssd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.ctssd'on'rac1'CRS-2676:Startof'ora.ctssd'on'rac1'succeededASMcreatedandstartedDiskGroupCRS_DG0createdclscfg:-installmodeSuccessfullyaccumulatednecessaryOCRkeys.CreatingOCRkeysforuser'root',privgrp'root'..Operationsuccessful.CRS-2672:Attemptingtostart'ora.crsd'on'rac1'CRS-2676:Startof'ora.crsd'on'rac1'succeededCRS-4256:UpdatingtheprofileSuccessfuladditionofvotingdisk07c5183bdf594f32bf6f3481e08cda15.Successfullyreplacedvotingdiskgroupwith+CRS_DG0.CRS-4256:UpdatingtheCRS-4266:Votingfile(s)successfully## FileUniversal FileNameDiskONLINE07c5183bdf594f32bf6f3481e08cda15(ORCL:VOL1CRS)Located1votingCRS-2673:Attemptingtostop'ora.crsd'on'rac1'CRS-2677:Stopof'ora.crsd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.asm'on'rac1'CRS-2677:Stopof'ora.asm'on'rac1'succeededCRS-2673:Attemptingtostop'ora.ctssd'on'rac1'CRS-2677:Stopof'ora.ctssd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.cssdmonitor'on'rac1'CRS-2677:Stopof'ora.cssdmonitor'on'rac1'succeededCRS-2673:Attemptingtostop'ora.cssd'on'rac1'CRS-2677:Stopof'ora.cssd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.gpnpd'on'rac1'CRS-2677:Stopof'ora.gpnpd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.gipcd'on'rac1'CRS-2677:Stopof'ora.gipcd'on'rac1'succeededCRS-2673:Attemptingtostop'ora.mdnsd'on'rac1'CRS-2677:Stopof'ora.mdnsd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.mdnsd'on'rac1'CRS-2676:Startof'ora.mdnsd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.gipcd'on'rac1'CRS-26CRS-2672:Attemptingtostart'ora.cssdmonitor'on'rac1'CRS-2676:Startof'ora.cssdmonitor'on'rac1'succeededCRS-2672:Attemptingtostart'ora.cssd'on'rac1'CRS-2672:Attemptingtostart'ora.diskmon'on'rac1'CRS-2676:Startof'ora.diskmon'on'rac1'succeededCRS-2676:Startof'ora.cssd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.ctssd'on'rac1'CRS-2676:Startof'ora.ctssd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.asm'on'rac1'CRS-2676:Startof'ora.asm'on'rac1'succeededCRS-2672:Attemptingtostart'ora.crsd'on'rac1'CRS-2676:Startof'ora.crsd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.evmd'on'rac1'CRS-2676:Startof'ora.evmd'on'rac1'succeededCRS-2672:Attemptingtostart'ora.asm'on'rac1'CRS-2676:Startof'ora.asm'on'rac1'succeededCRS-2672:Attemptingtostart'ora.CRS_DG0.dg'on'rac1'CRS-2676:Startof'ora.CRS_DG0.dg'on'rac1'succeededCRS-2672:Attemptingtostart'ora.registry.acfs'on'rac1'CRS-2676:Startof'ora.registry.acfs'on'rac1'succeeded 2009/11/09Preparingpackagesforinstallation...ConfigureOracleGridInfrastructureforaCluster...succeededUpdatinginventorypropertiesforclusterwareStartingOracleUniversalCheckingswapspace:mustbegreaterthan500MB.Actual4094MB Theinventorypointerislocatedat/etc/oraInst.locTheinventoryislocatedat/u01/app/oraInventory'UpdateNodeList'wassuccessful.[root@rac2~]#/u01/app/oraInventory/orainstRoot.shChangingpermissionsof/u01/app/oraInventory.Addingread,writepermissions Removingread,write,executepermissionsforChanginggroupnameof/u01/app/oraInventorytooinstall.Theexecutionofthescriptiscomplete.[root@rac2~]#/u01/app/11.2.0/grid/root.shRunningOracle11groot.shscript...Thefollowingenvironmentvariablesaresetas:ORACLE_OWNER=oracleORACLE_HOME=Enterthefullpathnameofthelocalbindirectory:[/usr/local/bin]:Copyingdbhometo/usr/local/bin...Copyingoraenvto/usr/local/bin...Copyingcoraenvto/usr/local/bin...Creating/etc/oratabEntrieswillbeaddedtothe/etc/oratabfileasneededbyDatabaseConfigurationAssistantwhenadatabaseiscreatedFinishedrunninggenericpartofroot.shscript.Nowproduct-specificrootactionswillbeperformed.2009-11-0917:39:10:Parsingthehostname2009-11-0917:39:10:Checkingforsuperuserprivileges2009-11-0917:39:10:UserhassuperuserprivilegesUsingconfigurationparameterfile:CreatingtracedirectoryLOCALADDCreatingOCRkeysforuser'root',privgrp'root'..Operationsuccessful.AddingdaemontoCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.ohasdisstartingonnoderac1,number1,andisterminatingCRS-2672:Attemptingtostart'ora.mdnsd'on'rac2'CRS-2676:Startof'ora.mdnsd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.gipcd'on'rac2'CRS-2676:Startof'ora.gipcd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.gpnpd'on'rac2'CRS-2676:Startof'ora.gpnpd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.cssdmonitor'on'rac2'CRS-2676:Startof'ora.cssdmonitor'on'rac2'succeededCRS-2672:Attemptingtostart'ora.cssd'on'rac2'CRS-2672:Attemptingtostart'ora.diskmon'on'rac2'CRS-2676:Startof'ora.diskmon'on'rac2'succeededCRS-2676:Startof'ora.cssd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.ctssd'on'rac2'CRS-2676:Startof'ora.ctssd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.drivers.acfs'on'rac2'CRS-2676:Startof'ora.drivers.acfs'on'rac2'succeededCRS-2672:Attemptingtostart'ora.asm'on'rac2'CRS-2676:Startof'ora.asm'on'rac2'succeededCRS-2672:Attemptingtostart'ora.crsd'on'rac2'CRS-2676:Startof'ora.crsd'on'rac2'succeededCRS-2672:Attemptingtostart'ora.evmd'on'rac2'CRS-2676:Startof'ora.evmd'on'rac2'succeeded 2009/11/09Preparingpackagesforinstallation...ConfigureOracleGridInfrastructureforaCluster...succeededUpdatinginventorypropertiesforclusterwareStartingOracleUniversalCheckingswapspace:mustbegreaterthan500MB.Actual4094MB Theinventorypointerislocatedat/etc/oraInst.locTheinventoryislocatedat/u01/app/oraInventory'UpdateNodeList'wassuccessful.[root@rac2第四部分安装数据库，创建实使用ASMCA创建ASMcd安装数据库，创建实在数据库，执行安装的后任[oracle@rac1~]$sqlplus/asSQL>@Oracle_home/rdbms/admin/utlrp.sql手动检查RAC的状态及相关命ChecktheRAC1.[oracle@rac2admin]$sqlplus/asSQL*Plus:Release11.2.0.1.0ProductiononWedNov1115:14:432009Copyright(c)1982,2009,Oracle.s ConnectedOracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProductionDataMiningandRealApplicationTestingSQL>SELECTinst_nameFROMSQL> rameter 2oracle@rac1dbs]$srvctlstatusasm-nrac1-ASMisrunningonASMisenabledonnode[oracle@rac1dbs]$srvctlstatusasm-nrac2-aASMisrunningonrac2ASMisenabledonnode[oracle@rac1dbs]$srvctlstatusdatabase-doradb-vInstanceoradb1isrunningonnoderac1Instanceoradb2isrunningonnoderac2[oracle@rac1dbs]$[oracle@rac2dbs]$srvctlstatusinstance-doradb-i"oradb1,oradb2"-vInstanceoradb1isrunningonnoderac1Instanceoradb2isrunningonnode[oracle@rac1dbs]$srvctlstatusdiskgroup-gCRSDG-nrac1,rac2-aDiskGroupCRSDGisrunningonrac1,rac2DiskGroupCRSDGisenabledonrac1,rac2[oracle@rac1dbs]$[oracle@rac2dbs]$srvctlstatusnodeappsVIPrac1-vipisenabledVIPrac1-vipisrunningonnode:rac1VIPrac2-vipisenabledVIPrac2-vipisrunningonnode:rac2NetworkisenabledNetworkisrunningonnode:rac1Networkisrunningonnode:rac2GSDisdisabledGSDisnotrunningonnode:GSDisnotrunningonnode:rac2ONSisenabledONSdaemonisrunningonnode:rac1ONSdaemonisrunningonnode:rac2eONSisenabledeONSdaemonisrunningonnode:rac1eONSdaemonisrunningonnode:rac26.EnableGSD[oracle@rac2dbs]$srvctlenablenodeapps-g-GSDisenabledsuccessfullyonnode(s):rac1,rac2[oracle@rac2dbs]$[oracle@rac2dbs]$srvctlstatusnodeappsVIPrac1-vipisenabledVIPrac1-vipisrunningonnode:rac1VIPrac2-vipisenabledVIPrac2-vipisrunningonnode:rac2NetworkisenabledNetworkisrunningonnode:rac1Networkisrunningonnode:rac2GSDisdisabledGSDisnotrunningonnode:rac1GSDisnotrunningonnode:rac2ONSisenabledONSdaemonisrunningonnode:rac1ONSdaemonisrunningonnode:rac2eONSisenabledeONSdaemonisrunningonnode:rac1eONSdaemonisrunningonnode:[oracle@rac2dbs]$srvctlenablenodeapps-g-vGSDisenabledsuccessfullyonnode(s):rac1,rac2StartGSD[oracle@rac2dbs]$srvctlstartPRKO-2421:Networkresourceisalreadystartedonnode(s):rac1,rac2PRKO-2420:VIPisalreadystartedonnode(s):rac1,rac2PRKO-2420:VIPisalreadystartedonnode(s):PRKO-2422:ONSisalreadystartedonnode(s):rac1,rac2PRKO-2423:eONSisalreadystartedonnode(s):rac1,rac2[oracle@rac2dbs]$srvctlstatusnodeappsVIPrac1-vipisenabledVIPrac1-vipisrunningonnode:rac1VIPrac2-vipisenabledVIPrac2-vipisrunningonnode:rac2NetworkisenabledNetworkisrunningonnode:rac1Networkisrunningonnode:rac2GSDisenabledGSDisrunningonnode:rac1GSDisrunningonnode:rac2ONSisenabledONSdaemonisrunningonnode:rac1ONSdaemonisrunningonnode:rac2eONSisenabledeONSdaemonisrunningonnode:rac1eONSdaemonisrunningonnode:rac2[oracle@rac2dbs]$ORA-01102:cannotmountdatabaseinEXCLUSIVEmode[oracle@rac1~]$srvctlstatusdatabase-doradb-vInstanceoradb1isrunningonnoderac1Instanceoradb2isnotrunningonnoderac2[oracle@rac1~]$[oracle@rac2dbs]$sqlplus/asSQL*Plus:Release11.2.0.1.0ProductiononThuNov1209:48:572009Copyright(c)1982,2009,Oracle.s Connectedtoanidleinstance.SQL>startupORA-01102:cannotmountdatabaseinEXCLUSIVEmodeSQL>sho rametercluster 2SQL>altersystemsetcluster_database=TRUEaltersystemsetcluster_database=TRUE*ERRORatlineORA-32000:writetoSPFILErequestedbutSPFILEisnotSql>createpfilefromspfile;SQL>shutdownimmediateDatabaseclosed.Databasedismounted.ORACLEinstanceshutdown.SQL>exitDisconnectedfromOracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProductionDataMiningandRealApplicationTestingoptions[ora