freepeople性欧美熟妇, 色戒完整版无删减158分钟hd, 无码精品国产vα在线观看DVD, 丰满少妇伦精品无码专区在线观看,艾栗栗与纹身男宾馆3p50分钟,国产AV片在线观看,黑人与美女高潮,18岁女RAPPERDISSSUBS,国产手机在机看影片

正文內(nèi)容

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則可以連接了。
點擊復(fù)制文檔內(nèi)容
法律信息相關(guān)推薦
文庫吧 www.dybbs8.com
備案圖片鄂ICP備17016276號-1