????????
??????о??sysdba??sysoper??????????????????????????
????????????????????????????????????????????????????????????????????????
???????????????????У??????????????????????????????????????
??????oracle????￡? ??????????? lsnrctl start ??????????lsnrctl stop
?????????????????lsnrctl status
????startup ??????
????STARTUP options | upgrade_options
????options???[FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname]
????| [ OPEN [open_options] [dbname] ] | NOMOUNT ]??
????NOMOUNT??MOUNT??OPEN?startup????????Σ???????????????????????У?open_options???READ {ONLY
????| WRITE [RECOVER]} | RECOVER??
????upgrade_options???[PFILE=filename] {UPGRADE | DOWNGRADE} [QUIET]
???????????
???????????????裺
????1???????????????????????????????????????????????????????????????????г?????????????????????? startup nomount
????2??????????????????????????????л?????????????????????λ?ú?????????????????????????????????????????????????????????startup mount
????3???????????????????д??????????????????????????????????????????????г????κ??????????????????????????????????????????????????????????????????startup open
????????????????У????????????????????????????????????????????????????????Щ?????????????????????????????
??????????????? startup nomount
??????NOMOUNT????????
????????????????????????????:???????????????????????init.ora????????instance???????SGA????????????????????init.ora?????
????startup mount dbname
??????MOUNT?????????????δ???dbname???????????????DB_NAME??????????????
???????????????????????????:
?????????????鵵??
????????????????
???????????????????????
?????????λ?????????????????????
???????“nomount”???????????????????????????????????????λ???????????????????????????????У???顣
????startup open dbname
?????????“nomount”??
??????????“mount”??
???????????Redo log??????????????????????
??????????????????????е??????
????startup
???????????????(SPFILE)??????????????????????????????
????????????????????
????startup nomount
????alter database mount
????alter database open
????STARTUP??????????????????????
????1??Start and instance(NOMOUNT)??
????2??Mount the database(MOUNT)??
????3??Open the database(OPEN)
????startup restrict
?????????????
????????????????????????RESTRICTED SESSION?????????????????? ???????????????????????????: ??
????ERROR: ??
????ORA-01035: ORACLE ???????? RESTRICTED SESSION ??????????
???????????????ALTER SYSTEM???????????disable??????restricted???????????????
????startup pfile=?????????
?????????????????????????? ????????????????????????е?????????????
????????????????е?????????????δ???PFILE??????￡?startup????????????е????????