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….
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
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
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
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….
Assumption :- Same version 12cR1 (22.214.171.124.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
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
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
1.. Sql query to find database growth month wise and year select to_char(creation_time,'RRRR') , to_char (creation_time, 'Month') , round (sum(bytes)/1024/1024/1024) as GB from v$datafile group by to_char(creation_time,'RRRR') ,to_char (creation_time, 'Month')--,creation_time order by 1,2 2.. sql query to check the database growth (select min(creation_time) from v$datafile) "Creation Time ", (select name from v$database) "Database Name", ROUND((SUM(USED.BYTES) … Continue reading Sql queries to find out Database growth
1.. The redo log files are common for the whole CDB. All PDBs in a CDB share the archive log mode of the CDB. 2.. The control files are common for the whole CDB. The control files are updated to reflect any additional tablespaces and data files of plugged PDBs 3.. The UNDO tablespaces is … Continue reading Multitenant Container Database Architecture 12cR1 …