error:unable to get logical block size for spfile
朋友遇到了這個問題,發來看到後,第一反應是spfile出了問題,可能是被人為修改損壞或檔案損壞;
排除人為修改導致檔案損壞或其它原因的檔案損壞後,此問題ORACLE網站上有一個解決方法:
Below is their response to my SR:
-------------------------------------------------------------------------------------
Ok, after reviewing everything there seems to be no problem to fix. All configurations are correct. We believe these errors are benign and can be ignored.
OBSERVATIONS
===============
- The ASM Instance is Online.
- The Diskgroup: +XXXXXX_SYSTEM is mounted and has both physical and logical sector size of 512 bytes.
- No error messages in ASM Alert log.
Considering the above facts, the message "ERROR: Unable to get logical block size for spfile" looks benign and can be ignored.
However, to avoid getting these messages, as a workaround, you can try creating pfile from the spfile '+XXXXXX_SYSTEM/XXXXXX/spfileXXXXXX.ora' and then again try creating spfile in diskgroup +XXXXXX_SYSTEM using this pfile.
即在確認無異常卻仍有此報錯時,可以忽略,或者通過重建spfile來嘗試解決此報錯;
相關文章
- ORA-27046: file size is not a multiple of logical block sizeBloC
- [GuzzleHttp\Exception\RequestException] cURL error 60: SSL certificate problem: unable to get localHTTPExceptionError
- Oracle Log Block SizeOracleBloC
- MySQL 5.7.17 安裝報錯SSL error: Unable to get private key fromMySqlError
- unable to get oracle owner forOracle
- DB_BLOCK_SIZE and DB_CACHE_SIZE in OracleBloCOracle
- unable to get file lock, will retry ...
- oracle的塊 db_block_sizeOracleBloC
- DB_BLOCK_SIZE Initialization Parameter (92)BloC
- db block get和consistent read getBloC
- Initianization Parameter (1) : DB_BLOCK_SIZEBloC
- Consistent Gets(就是logical read)+ DB Block Gets = 所謂的Logical ReadsBloC
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11Error
- ERROR FIX:- rpmdb: unable to join the environmentError
- Oracle10g 五種不同的block sizeOracleBloC
- git SSL certificate problem: unable to get local issuer certificateGit
- mysql之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11MySqlError
- pip install scrapy報錯:error: UnableError
- Fatal error in launcher: Unable to create process using '"'Error
- 【BBED】使用bbed解決 the amount of space used is not equal to block sizeBloC
- 【故障處理】告警日誌報“ORA-01565 Unable To open Spfile”
- nodejs gm ImageMagick Error unable to read fontNodeJSError
- goldengate extract abended unable to queue I/O, I/O beyond file sizeGo
- Meaning of Block size in tcode R3AC1BloC
- 【Linux】bad geometry: block count 11796480 exceeds size of deviceLinuxBloCdev
- oracle block_size 為非標準塊的時候OracleBloC
- ORA-01114: IO error writing block to file (block #)ErrorBloC
- android studio Error:Unable to start the daemon process【轉】AndroidError
- (Error -1170 @ 0x0) Unable to access the DAP)Error
- Oracle Database on NFS : unable to lock file - already in use" ErrorOracleDatabaseNFSError
- Oracle OCP 1Z0-053 Q632(Standard Block Size )OracleBloC
- GIT clone報錯: SSL certificate problem: unable to get local issuer certificateGit
- weblogic - <BEA-141281> <unable to get file lock, will retry ...>Web
- 沒有備份的情況下如何處理logical & physical corrupt blockBloC
- 9i建立非標準BLOCK_SIZE資料庫(二)BloC資料庫
- 9i建立非標準BLOCK_SIZE資料庫(一)BloC資料庫
- 【rac故障】root.sh報錯Unable to get VIP info for new node
- ORA-30926: unable to get a stable set of rows in the source tables