foalabs

When Starting weblogic JPS-01055: Could not create credential store instance Error: JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreException: javax.persistence.PersistenceException: java.lang.ClassCastException:  Caused by: oracle.security.jps.service.policystore.PolicyStoreException: Can not connect DB with URL [jdbc:oracle:thin:@/<DBCS_INSTANCE_NAME>:<PORT>/<SID>.<NAME>.oraclecloud.internal] Solution: Find the file jps-config.xml that resides on $WEBLOGIC_DOMAIN_HOME/domain_name/config/fmwconfig and make sure the hostname is correct. Below is the piece of code with hostname reference. Fix it and startup again.       <propertySet name="props.db.1">             <property name="jdbc.url" value="jdbc:oracle:thin:@catdbsrv:1521:FUNDB"/> Also find other files using below command grep "<pattern>" $DOMAIN_HOME/config/jdbc/*.xml | awk -F ...

How to Clear Weblogic Cache 1. Shut down Weblogic Server. 2. Delete all the contents of the folder  ORACLE_HOME/user_projects/domains/your_domain/servers/your_server/tmp… Also delete  ORACLE_HOME/user_projects/domains/your_domain/servers/your_server/cache (optional) Your Server can be -- Adminserver, managed_servers 3. Restart Server. If you like please follow and comment

Oracle Application DBA Interview Questions In this post I will only be sharing questions, Please try to find the answers by yourself. Questions: 1) Explain the architecture of the EBS environment where you are working currently? 2) Why does a shared APPL_TOP beneficial over non-shared APPL_TOP? 3) Please share the details step to apply an Oracle EBS application patch ? 4) What is the purpose of Applying AD and TXK Delta patches  ? 5) Is there any mandatory step after apply AD delta patches , if yes please describe ? 6) If I want to create a new EBS test environment then what would the process explain the steps ?   7) When a concurrent job is running long , what would be the approach to dig/solve the problem ? 8) Please explain the setup process for Parallel Concurrent Processing  on 2 node application ? 9) Give detailed steps for setting up Oracle Application workflow with Office 365 IMAP and SMTP mailer ? 10) What is change when working with 19c DB along with Oracle Appl...

Query to find the form personalization in Oracle Apps  select * from FND_FORM_CUSTOM_RULES where function_name='ONT_OEXOEORD'; select * from FND_FORM_CUSTOM_RULES where form_name='OEXOEORD'; If you like please follow and comment

Data dictionary corruption error in Oracle Apps Adop While running adop phase prepare getting below  error Error: Verifying data dictionary.     [UNEXPECTED]Data dictionary corrupted:     [UNEXPECTED]Data dictionary corruption - missing parent     334686 ORA$BASE        APPS            XX_CUST_QUERY         SYNONYM     334688 ORA$BASE        APPS            XX_CUST_OTHERS           SYNONYM     [UNEXPECTED]Data dictionary corruption detected. Provide details to     [UNEXPECTED]Oracle Support and ask for a bug to be opened against the     [UNEXPECTED]Online Patching component of Oracle Application Install. Solution: To fix the data dictionary corruption (missing-parent), execute the following steps: 1) Run the $AD_TOP/sql/ADZDDBCC.sql script as apps user to ...

How to Create and Move SQL Profile from One Database to Another Steps: 1. Create SQL Profile in APPS schema The SQL Profile is created based on the tuning task created and the recommendations given by the tuning task: DECLARE  my_task_name VARCHAR2(30); my_sqltext CLOB;  my_sqlprofile_name VARCHAR2(30);  BEGIN    my_sqltext := 'select /*+ no_index(emp pk_emp) */ * from emp where empno=20';    my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(sql_text => my_sqltext,          user_name => 'APPS',          scope => 'COMPREHENSIVE',          time_limit => 60,          task_name => 'fun_ebs_tuning_task',          description => 'Demo Task to tune a query');     DBMS_SQLTUNE.EXECUTE_TUNING_TASK( task_name => 'fun_ebs_tuning_task');  my_sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE (task_name ...

Docker Basic Commands 1) Run docker run nginx It will try to find the image locally, if not found it will fetch from docker hub. 2) ps docker ps list all running containers docker ps -a all container, even they are stopped 3) stop Stop running container Container id docker stop <name> 4) rm remove permanently docker container which is not in use/stopped  docker rm <name> 5) images List images present on host docker images 6) rmi Remove images from host docker rmi  nginx make sure no container is running from that image. Delete all dependent containers to remove image. 7)  pull Download an image without running and stores it. docker pull nginx 8) sleep docker run ubuntu sleep 5 it wait for 5 sec before container stops 9) exec execute a command   docker exec flamboyant_mcclintock cat /etc/hosts 10) Attach/Detach when running an image it will run  web app in attached mode on foreground docker run ngnix in background  docker run -d ngnix d...

Install a Docker Engine on Linux Docker Engine is an open source containerization technology for building and containerizing your applications.Docker Engine is available on a variety of Linux platforms, macOS and Windows 10 through Docker Desktop, and as a static binary installation. Refer : https://docs.docker.com/engine/install/ for version where you are trying to install. I am installing on Linux Mint. Will use Ubuntu method Uninstall old versions sudo apt-get remove docker docker-engine docker.io containerd runc As it is not installed in my system it will not uninstall himanshu@himanshu-server:~/Desktop$ sudo apt-get remove docker docker-engine docker.io containerd runc [sudo] password for himanshu:           Reading package lists... Done Building dependency tree        Reading state information... Done E: Unable to locate package docker-engine There are multiple methods to  install. I will use script to install Install using t...

Query  to find a Concurrent Request Submitted by Users and its Count Query: ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-RRRR HH24:MI:SS'; SELECT     user_name,     request_date,    count(*) FROM     fnd_concurrent_requests fcr,     fnd_concurrent_programs_tl fcp,     fnd_responsibility_tl fr,     fnd_user fu WHERE     fcr.CONCURRENT_PROGRAM_ID = fcp.concurrent_program_id     and fcr.responsibility_id = fr.responsibility_id     and fcr.requested_by = fu.user_id     and fr.language='US'     and user_concurrent_program_name='&Program_name' group by user_name, request_date order by request_date desc; Other Query: select user_name , req_date, count(*) from( SELECT     user_name,   to_char( request_date, 'DD-MON-RRRR') req_date FROM     fnd_concurrent_requests fcr,     fnd_concurrent_programs_tl fcp,     fnd_responsibilit...

ORA-65011: Pluggable Database Does Not Exist in Oracle EBS Database after 19c upgrade After upgrading EBS database to 19c see we can see issue when setting the Pluggable database session. Error: SQL> show pdbs    CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------         2 PDB$SEED                       READ ONLY  NO         3 PBEE                       READ WRITE NO SQL> alter session set container=PBEE; ERROR: ORA-65011: Pluggable database PBEE does not exist Solution: This is due to  _pdb_name_case_sensitive set to true SQL> show parameter case NAME                                 TYP...