Microsoft Cloud Azure Deployment Oracle Error: Pmon (ospid:7504): Terminating the instance due to error 822

Source: Internet
Author: User



oracle11g Start Error, startup Nomount failed, background alert error log as follows:

[[email protected] dbs]$ more/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/alert_powerdes.logwed Feb 03 20:56:28 2016Starting ORACLE instance (normal) ... dispatchers = "(protocol=tcp) (SERVICE=POWERDESXDB)" AUD                  It_file_dest = "/oracle/app/oracle/admin/powerdes/adump" Audit_trail = "DB" db_name = "Powerdes" db_unique_name = "Pdunq" open_cursors = Diagnostic_dest = "/oracle/a Pp/oracle "Wed Feb 20:57:07 2016PMON started with pid=2, OS id=7504 Wed Feb 20:57:07 2016VKTM started with pid=3, OS id=7506 Vktm running at (100ms) precision Wed Feb 20:57:07 2016gen0 started with pid=4, OS id=7510 Wed Feb 03 20:57:07 2016DIAG started with pid=5, os id=7512 Wed Feb 20:57:07 2016DBRM started with pid=6, os id=7514 Wed Feb 03 20:57:07 20 16psp0 started with pid=7, os id=7516 Wed Feb 20:57:07 2016dia0 started with pid=8, os id=7518 Wed Feb 03 20:57:07 2016 Mman started with pid=9, OS id=7520 Wed Feb 20:57:07 2016dbw0 started with pid=10, OS id=7522 Wed Feb 20:57:07 2016LGWR started with pid=11, OS id= 7524 Wed Feb 20:57:07 2016CKPT started with pid=12, OS id=7526 Wed Feb 20:57:07 2016SMON started with pid=13, OS id= 7528 Wed Feb 20:57:07 2016RECO started with pid=14, OS id=7530 Wed Feb 20:57:07 2016MMON started with pid=15, OS id= 7532 starting up 1 dispatcher (s) for network address ' (Address= (Partial=yes) (protocol=tcp)) ' ... Wed Feb 20:57:07 2016MMNL started with pid=16, OS id=7534 starting up 1 shared server (s) ... Oracle_base from environment =/oracle/app/oraclepmon (ospid:7504): Terminating the instance due to error 822Instance ter  Minated by Pmon, PID = 7504[[email protected] dbs]$






This is a great possibility that the parameter file failed, directly find the original backup parameter file, and then start:

sql> startup pfile= '/oracle/pfile.01 ' nomountoracle instance started. Total System Global area 1453092864 bytesfixed size 2213416 bytesvariable size 855640536 bytesdatabase buffers 587202 560 Bytesredo Buffers 8036352 bytessql> sql> show parameter spfilename TYPE VALUE--------------------------- --------------------------------------------------spfile stringsql> create SPFile from pfile= '/oracle/pfile.01 '; File created. sql> sql> shutdown immediateora-01507:database not mountedoracle instance shut down. Sql> Startup Nomountoracle instance started. Total System Global area 1453092864 bytesfixed size 2213416 bytesvariable size 855640536 bytesdatabase buffers 587202  560 Bytesredo Buffers 8036352 bytessql> sql> sql> exitdisconnected from Oracle Database 11g Enterprise Edition  Release 11.2.0.1.0-64bit Productionwith The partitioning, OLAP, Data Mining and Real application testing Options[[email Protected] dbs]$


Microsoft Cloud Azure Deployment Oracle Error: Pmon (ospid:7504): Terminating the instance due to error 822

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.