{"id":120,"date":"2009-05-03T22:05:00","date_gmt":"2009-05-03T20:05:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2009\/05\/03\/oracle-about\/"},"modified":"2010-08-24T22:40:20","modified_gmt":"2010-08-24T20:40:20","slug":"oracle-about","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2009\/05\/03\/oracle-about\/","title":{"rendered":"ORACLE ABOUT"},"content":{"rendered":"

running mode:<\/span><\/p>\n\n\n\n\n\n\n\n\n\n
STARTUP NOMOUNT<\/td>\nstartup instance and occupy memory
read pfile in order:
– spfile$ORACLE_SID.ora or
– spfile.ora or
– init$ORACLE_SID.ora<\/p>\n

(for winshit it is necessary run service which open ORACLE.EXE [instance_name] and only one process unlike many processes at -nix systems)<\/td>\n<\/tr>\n

STARTUP MOUNT<\/td>\nmount database to instance,
read controlfile,
allocating database structure<\/td>\n<\/tr>\n
STARTUP OPEN<\/td>\nopen database for all users<\/td>\n<\/tr>\n
STARTUP READ ONLY<\/td>\nopen database for all users but read only<\/td>\n<\/tr>\n
TARTUP FORCE<\/td>\nrestart database as SHUTDOWN ABORT and startup again<\/td>\n<\/tr>\n
STARTUP RESTRICT<\/td>\nopen database for users with priviele RESTRICTED SESSION, if you want to open for all put ALTER SYSTEM DISABLE RESTRICTED SESSION<\/td>\n<\/tr>\n
STARTUP UPGRADE<\/td>\nopen database for AS SYSDBA, prepare database to upgrade<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

shutdown mode:<\/span><\/p>\n\n\n\n\n\n\n
SHUTDOWN<\/td>\ndisallow new connections and wait for finish session for present users<\/td>\n<\/tr>\n
SHUTDOWN TRANSACTIONAL<\/td>\ndisallow new connections, disallow new transactions, when transactions was finished, all users are disconnected<\/td>\n<\/tr>\n
SHUTDOWN IMMEDIATE<\/td>\ndisallow new connections, all transactions which was not commit are rollback and users are disconnected<\/td>\n<\/tr>\n
SHUTDOWN ABORT<\/td>\ndisallow new connections, all transactions are interupted, not rollback, users are disconnected, during next startup database allow recovery<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

run order:<\/span>
spfile[db_sid].ora
spfile.ora
pfile[sb_sid].ora
pfile.ora<\/p>\n","protected":false},"excerpt":{"rendered":"

running mode: STARTUP NOMOUNT startup instance and occupy memoryread pfile in order:– spfile$ORACLE_SID.ora or– spfile.ora or– init$ORACLE_SID.ora (for winshit it is necessary run service which open ORACLE.EXE [instance_name] and only one process unlike many processes at -nix systems) STARTUP MOUNT mount database to instance,read controlfile,allocating database structure STARTUP OPEN open database for all users STARTUP […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[37],"class_list":["post-120","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-about"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/120\/revisions\/191"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}