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來嘗試解決此報錯;
相關文章
- [GuzzleHttp\Exception\RequestException] cURL error 60: SSL certificate problem: unable to get localHTTPExceptionError
- ORA-27121: unable to determine size of shared memory segment
- Meaning of Block size in tcode R3AC1BloC
- 2.6.5.1 DB_BLOCK_SIZE 初始化引數BloC
- nodejs gm ImageMagick Error unable to read fontNodeJSError
- pip install scrapy報錯:error: UnableError
- Fatal error in launcher: Unable to create process using '"'Error
- android studio Error:Unable to start the daemon process【轉】AndroidError
- git SSL certificate problem: unable to get local issuer certificateGit
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- mgr引數之-group_replication_gtid_assignment_block_size小結BloC
- [ERROR] InnoDB: ibdata1 different size (rounded down to MB)Error
- GIT clone報錯: SSL certificate problem: unable to get local issuer certificateGit
- rabbitMq的status報錯Error: unable to perform an operation on node ‘rabbit……MQErrorORM
- linuxmint apt-get install error:Depends...?Linuxapt-getError
- 【rac故障】root.sh報錯Unable to get VIP info for new node
- Android Bugs—— Error:In declare-styleable FontFamilyFont, unable to find attribute android:fontAndroidError
- 終端報錯"xcrun: error: unable to find utility “xcodebuild”, not a developer tool orErrorXCodeUIDeveloper
- local.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Allowed memory size of 134217728ErrorException
- windows 環境下使用 Node.js 遇到 unable to get local issuer certificateWindowsNode.js
- Unable to execute SonarScanner analysis: Fail to get bootstrap index from server: Host is unreachable(Host unreachable)AIbootIndexServer
- 【ubuntu】解決Unable to determine the device handle for GPU 0000:02:00.0: Unknown ErrorUbuntudevGPUError
- Error:java.lang.RuntimeException: com.android.builder.dexing.DexArchiveMergerException: Unable to meErrorJavaExceptionAndroidUIHive
- error:14090086:SSL routines:ssl3_get_server_certificateErrorServer
- 帝國CMSr的Fatal error:Allowed memory size of的解決辦法Error
- flutter Error: unable to locate asset entry in pubspec.yaml: "assets/fonts/Lato-Regular.ttf"FlutterErrorYAML
- How to Optimize PostgreSQL Logical ReplicationSQL
- 1.1 Logical Structure of Database ClusterStructDatabase
- Linux 建立LVM(Logical Volume)LinuxLVM
- 帝國CMS更新時提示Fatal error: Allowed memory size of的解決方法Error
- 帝國cms網站Fatal error: Allowed memory size of … bytes exhausted怎麼辦?網站Error
- Kettle: pentaho-server-ce-9.4 : ERROR [SchemaUpdate] could not get database metadataServerErrorDatabase
- Android error “Could not get BatchedBridge, make sure your bundle is packaged properly” on start ofAndroidErrorBATPackage
- 2.4.8 Step 7: 建立spfile
- ASM下遷移spfileASM
- [重慶思莊每日技術分享]-PSU實施異常unable to get oracle owner forOracle
- file_get_content s()獲取https出現這個錯誤Unable to find the wrapperHTTPAPP
- docker image rm發生錯誤 Error response from daemon: conflict: unable to remove repository referenceDockerErrorREM
- Oracle DG建立Logical Standby DatabaseOracleDatabase