User is Unable to See a Responsibility In the Home Page of Oracle E-business suite…

SYMPTOMS :- A user has been assigned a responsibility, however the responsibility is not shown in the user's home page. Data in Workflow Directory tables has been checked and found to be OK. Neither clearing the global cache nor bouncing Apache solve the issue ... CAUSE :- Responsibility has been explicitly hidden by user, through … Continue reading User is Unable to See a Responsibility In the Home Page of Oracle E-business suite…

Creation of basic networking components of Virtual Cloud Network in OCI and provisioning Compute Instance

1.. Login to OCI Cloud account click on hamburger menu and again click on Networking Tab. Once You are on the Networking page, select compartment where you want to create your VCN. 2.. Give name for VCN and enter CIDR block and select CREATE VIRTUAL CLOUD NETWORK ONLY to create all other basic networking components … Continue reading Creation of basic networking components of Virtual Cloud Network in OCI and provisioning Compute Instance

Creating User in Oracle Cloud Infrastructure in simple way

What is user in Oracle Cloud Infrastructure ? An individual employee or system that needs to manage or use company's Oracle Cloud Infrastructure resources. Users might need to launch instances, manage remote disks, work with your virtual cloud network, etc. End users of your application are not typically IAM users. Users have one or more … Continue reading Creating User in Oracle Cloud Infrastructure in simple way

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 …..

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….