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