command for Oracle and DB2 startup

Start/Stop instance command

Oracle DB - 1 instance = 1 database
startup (nomount, mount, open) Simple 'startup' is same as 'startup open'
shutdown (normal, immediate, abort) normally we use shutdown immediate for normal db shutdown

DB2 - 1 instance = Muti database
db2starup (start instance)
db2stop (stop instance)
base on the user name for each instance

Mysql - 1 instance = Muti database
instance contain one database storing login/tablespace/table info


Connect to Database

Oracle DB - in account 'oracle'
sqlplus / as sysdba

DB2 - in account 'db2inst1'
db2 connect to dbname

Exit from Database

Oracle DB
sql > exit

DB2
db2 terminate