Skip to main content

START UP MODS & SHUT UP MODS

The start up mods and shut up mods should be fired on Sql

SQL means ‘structure query language’

To connect to sql we should fire environmental variables commands

 

DB name :   EXPORT ORACLE_SID = db home name

Homepath:  

EXPORT ORACLE_HOME= /ORACLE-12C/APP/PRODUCT/12C/DBHOME

Path:  EXPORT_PATH = $ORACLE_HOME/BiN:$Path

To fix environmental variables command    

Env |grep ora

 

Start up mods

 

Start up no mount       no mount mode       alter data base no mount

Start up mount                   mount mode       alter data base mount

Start up                                    Open mode      alter data base open

 

Shut up mods

 

Shut immediately

Shut up

 

Shut immediately will be used to down the data base

It will be used at the time of any software update/ testing/ development the program.

(It should be used with permission other wise the transactions stops)

 

P-file: parameter file

Audit files = data/audit

db name =

Control type file = /oracle/app/control/control 01.ctl

                              = /oracle/app/control/control 02.ctl

Diagnostic_dest = /oracle/app/diag

Undo tablespace = UNDOTBS

SGA  = TARGET = 4G;

Java-pool-size = 2G;

SID : system identifier

GUI : graphical user interface method

Comments

Post a Comment

Popular posts from this blog

Oracle database single instance architecture

Oracle database single instance architecture  Maine database runs on a single machine we referred to this architecture as the Oracle database single instance architecture this setup involves having one Oracle database instance running on the mission serving its clients   The term Oracle database instance simply refers to the combination of memory structure and database process that collectively represent the database service.  However this Architectire has a significant availability risk.  If anything goes wrong with the mission that database becomes UN available.
Post a Comment
Read more

Table spaces

 Tablespace consists of one or more data files.  A data file belongs to only one tablespace. Segments, Extents, and Blocks • Segments exist within a tablespace • Segments are made up of a collection of extents • An extents is a collection of logically contiguous data blocks - Cannot span multiple data files • Data blocks are mapped to disk blocks SYSTEM and SYSAUX Tablespaces • The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. • They are created at the time of database creation. • They must be online. • The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). • The auxiliary SYSAUX tablespace is used for additional database components.
Post a Comment
Read more