APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 39,236 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    February 2018
    M T W T F S S
    « Dec    
  • Archives

  • Authors

Oracle Advanced Support Gateway Security – OASG

Posted by appsinfo on August 27, 2014

Oracle Advanced Support Gateway Security – OASG

As part of any implementation project and using oracle engineered systems as part of infrastructure, we should nail down the firewall ports as part of security. This requires extensive pre-planning, architecture, instance strategy based on scope of project.


The Oracle Advanced Support Gateway is an important part of the Oracle delivery architecture for Oracle Connected Services and its placement must be carefully considered in order for Oracle to deliver Oracle Connected Services.

More information can be found on:



Posted in Infrastructure, Oracle ExaData & ExaLogic | Tagged: , | Leave a Comment »

Web Cache for WebLogic Server

Posted by panthan on August 27, 2014

The WebLogic Server 11g comes with a built-in Web server which is adequate for displaying its own Web pages and could be used for applications hosted on the WebLogic servers. You could use a more industrial-strength Web server such as Oracle HTTP Server (OHS) from the Web Tier, but you don’t have to. In this tutorial you are going to use the built-in Web server and front-end it with the Web Tier Web Cache to speed up Web pages. The application that will be cached is the Administration console, normally found on port 7001. That port will continue to work uncached, but users of the application will be instructed to use a different URL (same host, but port 7785) for future traffic so that it will be cached. So to access the uncached Administration Console, you would use

http://yourhost:7001/console; and to access the cached Administration Console you would use http://yourhost:7785/console.

In this tutorial, you would learn how to:

  • Configure the Web Cache using the Enterprise Manager for caching some (and optionally all) of the traffic headed to the WLS application server
  • Report and monitor the actual benefits of this caching
  • Use the Web Caching independently of the Oracle HTTP Server (OHS)

For more information refer to below link to Oracle tutorial:


Posted in Oracle EBS 12.2, Uncategorized | Tagged: | Leave a Comment »

Oracle E-Business Suite Release 12.2

Posted by panthan on August 27, 2014

Just like the need of Multi Node architecture for high availability Oracle introduced a new file system called Edition Based File System in R12.2, which enables the high availability while the patches are being applied. For our imagination, basically it is divided into two. They are Run and Patch Edition. Conceptually there is a third one – Non Edition. Naming wise, they are referred as fs1,f2 and ne_fs. The file system fs1 and fs2 can switch their roles between patch and run based on the patching cycle. The file system ne_fs contains the data required by both, which will never be changed by run and patch file system life cycles.


Posted in Oracle EBS 12.2 | Tagged: | Leave a Comment »

Database Password File: ORAPWD

Posted by appsinfo on April 2, 2013

Create PASSWORD File

1) SQL> select * from v$pwfile_users;

no rows selected

2) orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=<sys_password> entries=10
3) Now grant sysdba privilege to the users that you need. Check V$PWFILE_USERS about the entry.


 SQL> select * from v$PWFILE_USERS;

USERNAME                       SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS                            TRUE  TRUE  FALSE
SYSTEM                         TRUE  FALSE FALSE
RMANUSER                       TRUE  FALSE FALSE

 SQL> select decode(count(*), 1, ‘spfile’, ‘pfile’ ) from v$spparameter where rownum=1  and isspecified=’TRUE’;


Posted in Security | Tagged: | Leave a Comment »

Recover Database using RMAN

Posted by appsinfo on November 22, 2012

 Oracle Database full Restore using RMAN

Scenario #: Let’s say your database is crashed due to some reason and you are not able to access the database or all data files were deleted or OS file system was restored due to crash or you attempted cloning and the clone failed and would like to restore from previous/last valid available full backup.

 Ideal Pre-Requisite: 

  • Valid full database backup available – controlfiles, datafiles, archivelogs
  • All OS file system and mounts points have been restored (LINUX or UNIX) 

Steps to Restore 

  • Create a directory on linux/unix machine  “mkdir restore” /U01/DEV/rman_backup/restore 
  • Locate the control file; we usually backup the control file in the same location along with data backup. 
  • Restore the control file

                 Connect to the database in nomount 

                $ sqlplus / as sysdba

                SQL> shutdown immediate OR shutdown abort

                SQL> startup nomount

                SQL> show parameter control_files

                SQL> exit

                $ rman target /


                Connected to target database <SID> (not mounted)

                RMAN> restore controlfile from ‘/U01/DEV/rman_backup/controlfile_name.ctlbkup’; 

  • Restore the database

                                 RMAN> alter database mount;

                                RMAN> restore database;

                                RMAN> recover database;

                                RMAN> alter database open resetlogs;

Posted in Backup and Recovery | Tagged: | Leave a Comment »