How to find Installed Modules in Oracle E-Business Suite R12 …..

First Method :- 1.. Login Oracle E-Business Suite as SYSADMIN user. 1.2.. Click on System Administrator responsibility and OAM Setup tab. 1.3.. Once you have clicked on OAM setup, click on Site Map 1.4..  Now click on Licensed Products under the tab Reports 1.5 Your screen will appear like given below with summary for licensed, … Continue reading How to find Installed Modules in Oracle E-Business Suite R12 …..

Advertisements

Recovery of Non-system Datafile without backup using rman in 11gR2

Assumption :- For tablespace RECOVERY one datafile is backedup using rman and other datafile is not backedup. 1.. Create tablespace called RECOVERY with one datafile recovery01.dbf 2.. Take full backup of Database using rman Now again add a new datafile as recovery02.dbf to RECOVERY Tablespace that you have created. 3.. For testing purpose create a … Continue reading Recovery of Non-system Datafile without backup using rman in 11gR2

Ways to find report or package file version in Oracle E-Business Suite….

1.. ADIDENT Utility :-  ADIDENT Utility in ORACLE application is used to find version of any file. Syntax: - adident Header <file_name> 2.. STRINGS Utility Strings is a UNIX based utility which is used to print the strings of printable characters in files and can be used to extract header information from the string content … Continue reading Ways to find report or package file version in Oracle E-Business Suite….

Ways to find Out DBID of Oracle Database in 11gR2

DBID stands for database identifier which is a unique identifier for each oracle database running in your server. DBID information is found in control files as well as datafile header. If the database is up and running then DBID can be found from v$database or while connecting to rman target / 1.. If Oracle Database … Continue reading Ways to find Out DBID of Oracle Database in 11gR2

Restore and Recovery of Redo log files complete loss in 11gR2

1.. Check name , open mode and log mode of database 2..  Check online redo log file group, redo log file name and size 3..  To simulate go to redo log location and delete redo log file 4..  Check Archive log is enabled or not 5.. Alter switch syntax will hang Error in Alert log … Continue reading Restore and Recovery of Redo log files complete loss in 11gR2

Pluggable Database Rename in Oracle Container Database 12cR1

1.. Connect to root container as sysdba then show pdbs 2.. First shutdown pluggable database and then open in restricted mode for e.g NONPDB4 3.. Now connect to Pluggable database NONPDB4 that you want to change the name. 4.. execute alter pluggable database rename global_name to DEMO; Note :- There will be change in name … Continue reading Pluggable Database Rename in Oracle Container Database 12cR1

Cloning PDB within same Oracle Container Based Database 12cR1….

1.. Create a new directory like clone to clone PDBs from existing PDBs mkdir -p /u001/oracle/oradata/CDB2/clone 2.. Now connect with sysdba user and verify Container Database you want to connect and status of PDBs that you want to clone . PDB that you want to clone should be closed and in read only mode. 3..  … Continue reading Cloning PDB within same Oracle Container Based Database 12cR1….

Unplug and plug non-container database into Container base database (CDB) in 12cR1

Assumption :- Same version 12cR1 (12.1.0.2.0) of Oracle Database is installed one as NONCDB and other one as CDB(PDB) top of same operating system version and flavor. 1.. Source the environment for non container base NONCDB  database and login as sys as sysdba 2.. Shutdown the database and start in mount mode 3.. Now open … Continue reading Unplug and plug non-container database into Container base database (CDB) in 12cR1

ORA-00845: MEMORY_TARGET not supported on this system

1..  While trying to start database 2.. The new Automatic Memory Management functionality uses /dev/shm on Linux for SGA and PGA management. The errors occur if either MEMORY_TARGET or MEMORY_MAX_TARGET is configured larger than the configured /dev/shm size, or if /dev/shm is mounted incorrectly. 3.. Now login with the root and make sure that the … Continue reading ORA-00845: MEMORY_TARGET not supported on this system

Easy to drop Oracle database using rman 11gR2

Purpose :-  Use the DROP DATABASE command to delete the target database and if RMAN is connected to a recovery catalog, unregister it. RMAN removes all data files, online redo logs, and control files belonging to the target database. By default, RMAN prompts for confirmation. Prerequisites :-  Execute this command only at the RMAN prompt. … Continue reading Easy to drop Oracle database using rman 11gR2