foalabs

Query to identify printers set with the Printer profile, at the all profile levels in Oracle Apps Script: select distinct t.user_profile_option_name "Profile Option Name", decode(v.level_id, 10001,'Site Level', 10002,'Application Level --> ' ||application_name , 10003,'Responsibility level-->'||responsibility_name, 10004,'User Level-->' ||u.user_name, 'XXX') "Profile Option Level", profile_option_value "Value" from fnd_profile_options o, fnd_profile_option_values v, fnd_profile_options_tl t, fnd_responsibility_tl r, fnd_application_tl a,fnd_user u where o.profile_option_id = v.profile_option_id and o.application_id = v.application_id and start_date_active <= SYSDATE and nvl(end_date_active,SYSDATE) >= SYSDATE and o.profile_option_name = t.profile_option_name and a.application_id(+) = decode(level_id,10002,level_value,null) and r.responsibility_id...

How to Deploy SSL Certificates on Oracle Weblogic Oracle Weblogic uses the Java Keystore architecture to manage and deploy SSL Certificates. We need to get the certificate from the certifying authority and download the root certificate, intermediate and main certificate out of that. Steps to deploy: 1) Set Weblogic Environment /wlserver_10.3/server/bin/setWLSenv.sh 2) Concatenate Certificate with Root Certificate(s) into 1 file Sequence would as below Main Signed Cert + CA Intermediate(s) + CA Root and Save file as: fullcertificate.crt 3) Import Full Cert into identity.jks Keystore keytool -import -trustcacerts -alias funoracle -file fullcertificate.crt -keystore identity.jks 4) Create Empty Trust Store This Trust Store will be used to store the Root and Intermediate certificates alone keytool -genkey -keyalg RSA -alias dummy -keystore truststore.jks ## Answers DO NOT MATTER you will delete this dummy record next What is ...

We can use below query to check all concurrent managers status with node name and number of actual/target processes. Script: col "Concurrent Manager" for a40 col Node for a20 set lines 200 pages 200 SELECT   distinct b.user_concurrent_queue_name "Concurrent Manager", a.TARGET_NODE "Node", a.running_processes "ACTUAL Processes", a.max_processes "TARGET Processes"    ,DECODE (b.control_code      ,'D', 'Deactivating'      ,'E', 'Deactivated'      ,'N', 'Node unavai'      ,'A', 'Activating'      ,'X', 'Terminated'      ,'T', 'Terminating'      ,'V', 'Verifying'      ,'O', 'Suspending'      ,'P', 'Suspended'      ,'Q', 'Resuming'      ,'R', 'Restarting', 'Running'      ) status   FROM apps.fnd_concurrent_queues a, apps.fnd_concurrent_queues_...

In this post I am going to cover the concepts of Oracle Data Guard. Oracle Dataguard is part of Oracle Maximum Availability Architecture(MAA) which includes various Oracle technologies like RAC,ASM,Flashback, Active DataGuard and Goldengate. Dataguard is part of MAA and used for Data protection which provides a disaster recovery solution for Oracle Databases. It also be considered as a High Availability Solution*. For Dataguard we can  keep the DR on different servers,data centers or geographical location to provide best data protection. In the DR environment the source database from where data is synced to target database is called as PRIMARY Database and the target database is know as Standby Database . The above picture represents simple architecture for a basic DR configuration. DR sends the redo log files to standby database so it is also know as log  shipping based replication. DR is a unidirectional replicatio...

Hello and welcome to the Oracle DataGuard Tutorial Series of post. In these post I would be sharing the guide to start understanding and working on data guard. You should be having some prior knowledge on  a) Oracle Database administration Basics b) Basic of Linux Command c) Have knowledge of working on virtual box and setting up server. I will be covering topics related to below in this series. 1) Introduction to Oracle DataGuard- Understanding the concepts. 2) Create and Manage Physical and Logical Standby database. 3) Understanding and Configuring Data Gaurd Broker and using it to monitor Data Guard. 4) How to do role transition (Switch Over and Failover) 5) How to setup Fast-Start Failover(FSFO) 6) How to setup Active Data  Guard 7) How to setup Snapshot Standy Database 8) Implement Client Failover 9) How to Use RMAN for dataguard environments I would be using Oracle Virtual Box to setup the Oracle Data Guard Environment. Environment Requirement...