ORACLE Database Details

Oracle

connect to Putty->enter the hostname->select load

Login :
password:

ps -ef | grep pmon
ps -ef | grep tns
ps -ef | grep d.bin

Set the environment for the database:

uname
cat /etc/oratab OR cat /var/opt/oracle/oratab
export ORACLE_SID=
export ORACLE_HOME=/usr/app/oracle/product/10.2.0/
export PATH=$ORACLE_HOME/bin:$PATH

Database Details:

sqlplus “/as sysdba”

set pages 50000 lines 32767

col OPEN_MODE for a10
col HOST_NAME for a10
select NAME DB_NAME, INSTANCE_NAME, HOST_NAME, OPEN_MODE, version DB_VERSION,DATABASE_STATUS,DATABASE_ROLE, PROTECTION_LEVEL, CONTROLFILE_TYPE, LOGINS, to_char(STARTUP_TIME,’DD-MON-YYYY HH24:MI:SS’) “DB UP TIME” from v$database,gv$instance;