ORACLE Database Details
connect to Putty->enter the hostname->select load
Login : <userid>
password: <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=<DBNAME>
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;
Login : <userid>
password: <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=<DBNAME>
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;
DB_NAME INSTANCE_NAME HOST_NAME OPEN_MODE DB_VERSION DATABASE_STATUS DATABASE_ROLE PROTECTION_LEVEL CONTROL LOGINS DB UP TIME
--------- ---------------- ---------- ---------- ----------------- ----------------- ---------------- -------------------- ------- ---------- --------------------
xxx xxx oracle.xxx READ WRITE 10.2.0.1.0 ACTIVE PRIMARY MAXIMUM PERFORMANCE CURRENT ALLOWED 09-SEP-2017 11:40:14
No comments:
Post a Comment