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

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...