Apps DBA Daily tasks!!

Apps DBA Daily tasks

Apps DBA Daily tasks!!

eBusiness 11i/R12 – Daily Checks (for Apps. DBA) – Admin Node

Being Apps. DBA, one should check the subsequent on Daily Basis in order to make sure that everything is working fine. This post is relating to ADMIN NODE.

Listener Status
$ lsnrctl status PROD

File System Space Utilization
$ df -h

Operating System – eBusiness DB and Concurrent Processes$ ps -ef |grep pmon|grep -v grep
$ ps -ef |grep FNDLIBR|grep -v grep

eBusiness DB Instance
SQL> SELECT instance_name,host_name,TO_CHAR(startup_time,’DD-MON-YYY HH:MM:SS AM’) startedat FROM v$instance;

Invalid Objects
SQL> select owner,object_name,object_type from dba_objects where status ’INVALID’;

Inactive Users
SQL> select username, command, status, server, osuser, machine, terminal, program, module, action from v$session where status ’INACTIVE’;

Active Sessions
SQL> select inst_id,count(*) from gv$session group by inst_id;

Active Users Detail
SQL> select username, command, status, osuser, process, machine, terminal, program, module, action from v$session where status ’ACTIVE’;

Data Files Status:
SQL> select name, status from v$datafile;

Log Files Status
SQL> select * from v$log;

Archiving Errors
SQL> select error from v$archive_dest;

Tablespace Free Space
SQL> select tablespace_name,round (sum(bytes)/1024/1024) Free_Space_MB from dba_free_space group by (TABLESPACE_NAME);

Invalid Indexes
SQL> select index_name,table_name from dba_indexes where status =’INVALID’ and owner=’APPS’;

eBusiness 11i/R12 – Applications Listener Status
$ sh $COMMON_TOP/admin/scripts/PROD_oracle2/adalnctl.sh status

Checking on the status of Report Server
$ sh $ORACLE_HOME/admin/scripts/PROD_oracle2/adrepctl.sh status

Database Connectivity via Apps. user without Connect String
$ sqlplus -S -M “HTML ON TABLE ‘BORDER=”2″‘” “apps/****” @/oracle/appsprod/oui/venkat/appschk.sql > /oracle/appsprod/oui/venkat/output.html

 

Thanks

Srini