oracle學(xué)習(xí)總結(jié)(編輯修改稿)
2024-07-22 22:25 本頁面
【文章內(nèi)容簡介】 但oradim沒提供這個選項，于是啟動sqlplus。C:\sqlplus /nologSQL*Plus: Release Production on 星期三 4月 11 10:49:13 2007Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL connect /as sysdbaERROR:ORA12560: TNS:protocol adapter errorSQL connect sys/mydb as sysdbaERROR:ORA12560: TNS:protocol adapter errorSQL exitC:\set oracle_sid=mydbC:\sqlplus /nologSQL*Plus: Release Production on 星期三 4月 11 10:50:21 2007Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL conn sys/mydb as sysdbaConnected. SQL startup nomountORA01078: failure in processing system parametersLRM00109: could not open parameter file 39。D:\Oracle\product\\admin\mydb\pfile39。SQL startup nomount pfile=d:\oracle\product\\admin\mydb\pfile\ORA01081: cannot start alreadyrunning ORACLE shut it down firstSQL shutdownORA01507: database not mountedORACLE instance shut down.SQL startup nomount pfile=d:\oracle\product\\admin\mydb\pfile\ORACLE instance started.Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145750508 bytesDatabase Buffers 25165824 bytesRedo Buffers 262144 bytes》因為每次都要指定pfile不方便，可以創(chuàng)建一個C:\sqlplus /nologSQL*Plus: Release Production on 星期三 4月 11 11:02:57 2007Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL conn sys/mydb as sysdbaConnected to an idle instance.SQL create spfile from pfile。create spfile from pfile*ERROR at line 1:ORA01078: failure in processing system parametersLRM00113: error when processing file39。D:\Oracle\product\\admin\mydb\pfile39。LRM00109: could not open parameter file39。D:\Oracle\product\\admin\mydb\pfile39?！飞厦娴腻e誤原因是第二步造成的，其中IFILE=....\才行。SQL create spfile from pfile。File created.》再啟動，不用指定pfile了SQL startup nomountORACLE instance started.......SQL shutdown immediateORA01507: database not mountedORACLE instance shut down.》重新啟動機器后，orcl數(shù)據(jù)庫總是顯示為已啟動，mydb為未啟動狀態(tài)這種情況下orcl其實是一個空閑進程，數(shù)據(jù)庫nomount階段，mydb則沒啟動進程，所要連接到mydb會出現(xiàn)如下錯誤：SQL conn sys/mydb as sysdbaERROR:ORA12560: TNS:protocol adapter error可從服務(wù)管理器中啟動OracleServicemydb則可以連接了。
法律信息相關(guān)推薦
鄂ICP備17016276號-1