Oracle APPS DBA COMMAND :-

                                      Oracle APPS Command

OS version :-

[root@sonu ~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 5.4 (Tikanga)

Java Details:-

[root@sonu ~]# java -version

java version "1.6.0"
OpenJDK  Runtime Environment (build 1.6.0-b09)
OpenJDK Server VM (build 1.6.0-b09, mixed mode)
 
Perl Details :-

[root@sonu ~]# perl -v

This is perl, v5.8.8 built for i386-linux-thread-multi
Copyright 1987-2006, Larry Wall
Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using "man perl" or "perldoc perl".  If you have access to the
Internet, point your browser at http://www.perl.org/, the Perl Home Page.
 

Check kernel parameter :-
 

[root@sonu ~]# /sbin/sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 4294967295

fs.file-max = 6553600

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 1024 65500

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

Connect to SQL :-

[oracle@sonu scripts]$ sqlplus

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Jun 5 10:53:34 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: apps/apps

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select COMP_NAME,VERSION,STATUS from dba_registry; 

Mount Point :-

[root@sonu ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda1             222G  155G   56G  74% /

tmpfs                 995M   12K  995M   1% /dev/shm

Apps Version :-
  SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME

--------------------------------------------------

12.1.1

Size of DATABASE:-

[root@sonu ~]# du -sh /oracle/PROD/db/

50G     /oracle/PROD/db/

Size of Application:-

[root@sonu ~]# du -sh /oracle/PROD/apps/

28G     /oracle/PROD/apps/

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

PL/SQL Release 11.1.0.7.0 - Production

CORE    11.1.0.7.0      Production

TNS for Linux: Version 11.1.0.7.0 - Production

NLSRTL Version 11.1.0.7.0 – Production

[oracle@sonu scripts]$ cd /oracle/PROD/db/tech_st/11.1.0/

[oracle@sonu 11.1.0]$ . PROD_sonu.env

[oracle@sonu 11.1.0]$ sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jun 5 12:23:42 2012

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

Enter user-name: sys as sysdba

Enter password: sys
 

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Check  Database log mode  :-

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /oracle/PROD/db/tech_st/11.1.0/dbs/arch

Oldest online log sequence     3

Current log sequence           4

SQL> select instance_name, version, host_name, status, database_status, to_char(startup_time,'DD-MON-YYYY HH:MI:SS') strtd from v$instance;

INST_NAME   VERSION    HOST_NAME     STATUS      DB_STATUS        STRTD 

PROD             11.1.0.7.0     sonu.oracle.com      OPEN           ACTIVE              05-JUN-2012  10:42:03

SQL> select name,status from v$controlfile;

 SQL> select group#,member from v$logfile;

 SQL> select file_name,tablespace_name,bytes/1024/1024 "size" from dba_data_files order by tablespace_name;

SQL> show parameter

Location of Listener file:-

[oracle@sonu 11.1.0]$ cat /oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_sonu/listener.ora

[oracle@sonu 11.1.0]$ cat /oracle/PROD/db/tech_st/11.1.0/network/admin/PROD_sonu/tnsnames.ora